Results 1 to 9 of 9
  1. #1
    pledbetter is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jan 2010
    Location
    Martinsville, IN
    Posts
    31

    "Shortcuts"

    I am not new to Access but had stepped away from it for a few years and now I'm back. One of the concepts that is new to me is that of a "Shortcut". This database I inherited has a number of table, form, macro, and query shortcuts that do not seem to make sense. What is it a shortcut to? In the Windows environment, a shortcut is just a pointer to the real application's location. In this inherited application, the "shortcut" seems to be the actual object, not simply a pointer, as I cannot find the "original" anywhere. Can anyone give me some general pointers on the concept of "shortcuts" in Access? I've tried to research it myself but all the references I've come up with talk about a shortcut to the Desktop. Thes "shortcuts" reside only within the database and nowhere elste that I can figure out.

  2. #2
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Are you talking about the Navigation Pane? Go to File>Options>Current Database>Navigation Options. It is supposed to make it easy to group items together but to me as a long-time developer it just confuses the issue.

  3. #3
    pledbetter is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jan 2010
    Location
    Martinsville, IN
    Posts
    31
    Yes, in the Access 2007 Navigation Pane. Attached is a Word Document that has a screen shot. What are "Shortcuts" in this context?
    Attached Files Attached Files

  4. #4
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    The custom groups are created in the Navigation Options.

  5. #5
    pledbetter is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jan 2010
    Location
    Martinsville, IN
    Posts
    31
    aytee111,
    I'm sorry but I don't understand your answer. I am asking about the concept of a "Shortcut" in the Access 2007 context and your answer has to do with Custom Groups?

  6. #6
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Hmm, maybe we are on different pages here! "Client MasterCP" is the name of a custom group which contains shortcuts to all the database objects that have been assigned to it. Sort of like making a folder containing shortcuts to only those objects. That way you can group things not by object which is the Access default but by a name you give it. The way you do this is through Options.

  7. #7
    pledbetter is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jan 2010
    Location
    Martinsville, IN
    Posts
    31
    Maybe. Here is another screenshot. "Client MasterCP" appears to be a table, and desite its icon being that of a shortcut, it appears to be the only copy of that table. There is no other table in any other group labeled "Client Master CP". The custom group is actually "Custom Group 1".
    Attached Files Attached Files

  8. #8
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Duh - sorry!

    Normal Access view (new versions and old) display objects by object type - tables, forms, etc. New to 2007 is a way to put it in groups as explained above. They are just shortcuts, however, not the real thing, as shown by the little arrow icon.

    To get back to normal Access view:
    - click on the arrow next to the word Custom
    - select Object Type - this should display them in the old way, the real objects themselves

    I hope this is what you are after!
    Attached Files Attached Files

  9. #9
    pledbetter is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jan 2010
    Location
    Martinsville, IN
    Posts
    31
    Well that opens up a whole new set of questions. I'm thinking this methodology will go the way of "Clipit". Thanks for your help.

    How does one post this thread as "Solved"?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 0
    Last Post: 01-11-2012, 12:34 PM
  2. Replies: 2
    Last Post: 11-04-2011, 02:45 AM
  3. Replies: 8
    Last Post: 08-05-2011, 02:55 PM
  4. Replies: 16
    Last Post: 07-22-2011, 09:23 AM
  5. "Group By" causes "ODBC--Call Failed" error
    By kaledev in forum Queries
    Replies: 1
    Last Post: 03-09-2011, 02:43 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums