Insert keystroke ENTER in macro

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

Guest

Hi,

While creating a table with a macro the New Table dialogue box pops up and
asks input from me. I have to press enter or click oke but like to avoid
that. In other words how can I insert the keystroke enter within the macro so
that it will continue to run.

Thanks
Willem
 
Willem,

Just guessing here, but one possibility is that you are using an
OpenQuery action in your macro to runa Make-Table Query. Is this the
case? If so, you can put a SetWanrnings/No action in the macro, before
the OpenQuery action, to suppress the display of the action query
confirmation prompts.
 
Steve,

Thanks and no, I make a new table by using the NewObjectTable in the
runcommand action. I have set the SetWarnings to NO but still two boxes are
still popping up.
Would the MakeTableQuery solve the problem??
However, I am still interested to know how to tackle the present problem. Is
there a way within macros to stop all boxes from popping up?? Has VBA the
possibility to do the job??

Thanks in advance

Willem.
 
Willem,

I have never used the RunCommand/NewObjectTable action in a macro
before. But obviously, if you are creating a new table, there are some
options you have to define. A MakeTable Query would give you control
over the fields of the new table. Maybe if you explain a litle more
detail about what you are trying to achieve, someone may be able to
suggest a better way. I can't think of any use at all for opening a new
table object in datasheet view with Access's default field settings.
 
Back
Top