Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Question
Saturday, January 12, 2013 2:09 AM
Using Access 2007
How can I copy a Query from one Group to another?
In the Navigation Pane, I've tried Copy on the name of a Query in the source Group, then I place cursor in the destination Group, and Paste. The pasted Query appears in the source Group.
All replies (2)
Saturday, January 12, 2013 2:32 AM âś…Answered
To move:
Right-click the query in the source group, then select Add to Group... > <destination group> from the context menu.
To copy:
Copy, then paste the query within the source group, then use the method described above to move the copy to the destination group.
Regards, Hans Vogelaar
Saturday, January 12, 2013 5:45 PM
Thanks! With your encouragement, I did some general hunting.
Turns out, with the Navigation Pane showing Tables and Related Views, a right-click on the Query name produced a context menu with no Add to Group button.
With the Nav. Pane showing Custom, the Query name is displayed in a different group, and right-click's menu shows Add to Group.
The Nav. Pane is confusing, what with objects bouncing among different Group names, and Group names appearing and disappearing, depending on which Category I choose. (I have been fooling with this database for several years, and have successfully applied a fair amount of nonsense.)
Regards, Bob