Can the yes or no box be removed

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi Everybody,

Thanx for the help for my last question about changing
text datatype to datedatatype, but it does not work as
wish it to, but i think there might be another way.

Can anybody show my a code to get rid of the dialog box
that pops-up after the import of a excelsheet, when i try
to get rid of the all the empty and not usefull fields by
using a delete query.

Example:
DoCmd.TransferSpreadsheet acImport, 8, "Excelfil", fil

stDocName = "Deleteemptylines"
DoCmd.OpenQuery stDocName, acNormal, acEdit

stDocName = "Deleteemptylinesinbot"
DoCmd.OpenQuery stDocName, acNormal, acEdit

To go back to my question about the date change if anybody
should have a good idea please drop a line or two...

Thanx for all the help.

Thomas Olsen
 
One approach would be to "wrap" the command that executes the query with the
SetWarnings command, i.e., something like:

DoCmd.SetWarnings False
...your command
DoCmd.SetWarnings True

Good luck

Jeff Boyce
<Access MVP>

Be sure to get the 'warnings turned back on, or Access could be crashing and
burning and you wouldn't know a thing...
 
Back
Top