ODBC Access Command - Auto 'Yes'

[Cwang]

Hi Bros,

When I run my query as follows:

SELECT * INTO Current_Rate
FROM ADM_TBLGS_INTEREST
WHERE ADM_TBLGS_INTEREST.INTDT>=#6/30/2011#;

there is this command box that kept appearing, is there any code to make it automatically run? As in skip the prompt from the command box.

Command Box Prompt:
"You are about to run a make-table query that will modify data in your table. Are you sure you want to run this type of query? Yes / No / Help"

Please help!
Thanks!

[ranman256]

If you mean the box to confirm the query is going to append data, then yes,
before you execute the query, turn off messages with,
docmd, setwarnings off.