EvilTwinOfAtrus
Technical User
Hi
I have a button that runs an update query called 'Query1'. In my code for the button I use the 'DoCmd.SetWarnings False' command as I set my own dialogue boxes, and use the ''DoCmd.SetWarnings True' command at the end to turn it back on again at the end.
When I run an update query manually, one of the screens tells me how many rows I'm about to update. Is there anyway of displaying a dialogue box of my own, saying how many rows I'm about to update, without turning all those ugly warnings back on ;-).
Many Thanks,
Karl
I have a button that runs an update query called 'Query1'. In my code for the button I use the 'DoCmd.SetWarnings False' command as I set my own dialogue boxes, and use the ''DoCmd.SetWarnings True' command at the end to turn it back on again at the end.
When I run an update query manually, one of the screens tells me how many rows I'm about to update. Is there anyway of displaying a dialogue box of my own, saying how many rows I'm about to update, without turning all those ugly warnings back on ;-).
Many Thanks,
Karl