Hi everyone. I need some help with a dialog box. I have a button that users select to update a data set- this button runs an update query. Is there anyway i can get around this dialog box that asks if they want to update 'X' rows etc..? Can I automate the response or make it where access doesn't ask them? Please help.. I have worked my butt off on this project, and this one last thing has been holding me back for almost 2 weeks. Thank you in advance.
I use the second option to make sure it is always turned off when the code is running, but it is turned on when I am doing manual updates/deletes. If you turn it off for the database then you won't see any warnings before you delete records.
run SQL Do something
Don't forget to it on again
hope this help
See clear as mud
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.