Sandy Sailer
asked on
Access 2007 - create macros to toggle between design view, form view, and layout view
In a previous version of Access, I was able to create a macro called AutoKeys which allowed me to assign key strokes to commands. Some of them are now obsolete.
Example: {F7} signifies the F7 function key. Assigned to this key was the action RunCommand and the command was DesignView. DesignView appears to no longer be valid, How could I do this type of thing in Access 2007? Thanks!
Example: {F7} signifies the F7 function key. Assigned to this key was the action RunCommand and the command was DesignView. DesignView appears to no longer be valid, How could I do this type of thing in Access 2007? Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
A list of all of Access 2007 keyboard shortcuts can be found here:
http://office.microsoft.com/en-us/access-help/keyboard-shortcuts-for-access-HP010091394.aspx
http://office.microsoft.com/en-us/access-help/keyboard-shortcuts-for-access-HP010091394.aspx
ASKER
Capricorn1 - this isn't with macros though, right? acCmdDesignView is not available in macros as an action argument.
did you click on Show all actions from the ribbon?
ASKER
Capricorn1 ... No, I hadn't done that. Now I did and the command is there. However, I'm getting a caution sign with an exclamation point through it next to the macro. When I run it, it seems fine. Not sure what the caution sign is for, but it appears to be working. This is exactly what I wanted to do. Thank you!
For example:
Ctrl+,
(Hold down the Control key and tap the comma key)
...will bring you to design view from Form view.
Note that this keystroke, and it's companion keystroke Ctrl+.
...actually toggle you forward and backward through all the views of a form/Report.
This is what I have used since Access 2003, ...thus avoiding the extra Code or Macros.
;-)
JeffCoachman