I have a large macro that I created in 2007 Access Database. When I converted to Access 2010, I can't find how to add a new query to the middle of the Macro. Any help would be appreciated.
I have a large macro that I created in 2007 Access Database. When I converted to Access 2010, I can't find how to add a new query to the middle of the Macro. Any help would be appreciated.
So easy in VBA. I don't use macros. I think I did something like this once trying to help another poster. Didn't find it easy at all. Seem to remember having to delete the queries and rebuild the macro to get the queries in particular order.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Okay, here's how... add it into the box at the bottom of the macro, then use the up/down arrows to position it in the desired sequence.
Thanks, you make it sound sooooo easy. Are you describing Access 2007 or 2010?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Access 2010... in 2007, you can just right click on a row and pick "Insert Row". In 2010, this method is gone. You have to add it to the bottom, then move it up.