Insert keystroke ENTER in macro

[Willem]

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

 

[Steve Schapel]

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.

 

[Willem]

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.

 

[Steve Schapel]

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.