I have small database which is used for booking hire cars. It has a few append queries that run through macros to get rid of bookings that are now out of date. However, everytime I load the database I get a series of annoying messages asking me if |I really want to do this. Is there a way of hiding these messages and letting access just get on with it?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Update messages when loading database 1
- Thread starter ccs2
- Start date
-
1
- #2
Hi!
Don't do any macros mesself, but browsed the macro editor. There's a SetWarnings action you can use before and after the lines running the queries. NOTE - apply Warnings On = No before execution, but be sure you set it to Yes after execution!
If you refer to VBA coding, you'd use the commands:
[tt]docmd.setwarnings false
docmd.runsql ssql ' or whatever "runsqlmethod" you're using[/tt]
[tt]docmd.setwarnings true[/tt]
HTH Roy-Vidar
Don't do any macros mesself, but browsed the macro editor. There's a SetWarnings action you can use before and after the lines running the queries. NOTE - apply Warnings On = No before execution, but be sure you set it to Yes after execution!
If you refer to VBA coding, you'd use the commands:
[tt]docmd.setwarnings false
docmd.runsql ssql ' or whatever "runsqlmethod" you're using[/tt]
[tt]docmd.setwarnings true[/tt]
HTH Roy-Vidar
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question