hide pop-ups that seek permission

[infoscion]

Hi All:
I am trying to create reports from access tables. These reports are tied with queries that pull data from the tables and spool it to another table. Everytime a report is run it seeks permission that it will append the data to the table and whether it is OK. I want to hide/get rid of this pop up and have the data appended to the existing table. Is there a way to achieve this functionality.
Pretty much run all the query in the background and let the user not be aware of it.
Regards,
Info

 

[PHV]

Take a look at the DoCmd.SetWarnings method:
DoCmd.SetWarnings False
' your stuff here
DoCmd.SetWarnings True

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244