Link to home
Create AccountLog in
Avatar of RDNorris
RDNorris

asked on

Autorun Access Macro and auto respond to questions generated

I have an access macro that executes a "Make table" query.  Would like to accomplish the following:

  1.  Have all prompts generated by the query automatically answered...  Questions generated are:
              You are running a Make Table Query.....  want "YES" automatically selected.
              Existing Table will be deleted .................   want "YES" automatically selected.
              Asks if I want XXXX records to be pasted into new table.....  want "YES" automatically selected.

2.  Want to be able to run this macro when database is opened, and then automatically close the database after the macro runs.


ASKER CERTIFIED SOLUTION
Avatar of Eddie Antar
Eddie Antar
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Rey Obrero (Capricorn1)
add  at the beginning of your macro

SetWarnings NO



at the end

SetWarnings YEs
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account