By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,847 Members | 2,161 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,847 IT Pros & Developers. It's quick & easy.

Some Help on Navigation Categories and Newly Created Queries

Brilstern
100+
P: 207
Ok so after extensive searching I have only found one answer to my question. You can not use VBA to auto assign a new item to a category. Which would be awesome but apparently the only way to do so is to do it the the UI.

So my question is, has anybody came up with or know of a simpler solution than having to navigate to unassigned items and manually adding it every time I create one. Its not that big of a deal but I run a command very often that creates 6 new queries every time, and I would like to avoid "cluddering" up my Navigation pane.

Any help would be appreciated.

Sgt B
Jan 1 '12 #1

✓ answered by NeoPa

I found this somewhat less than hopeful comment in Programatically accessing "object groups" :
Anthony England:
This is what I put into the Google Groups search page:
"database window" objects groups favorites
All answers (some by very experienced Access folk) seem to point to the
answer:

"Abandon all hope of doing anything with these - they are not accessable in
any way apart from the Access UI which is provided
"
My own researches found very little more than this. I found nothing that would help you I'm afraid :-(

Share this Question
Share on Google+
14 Replies


Rabbit
Expert Mod 10K+
P: 12,341
I have no idea what you mean by category.
Jan 2 '12 #2

Brilstern
100+
P: 207
If you right click on the top of the navigation pane it gives you the option to select a category. Within each category there are groups. Essentially I want to find out if there are any shortcuts for adding new queries to a certain group within a certain category other than the normal UI way of just right clicking on them and adding them or dragging them in the Nav pane to the group desired.
Jan 2 '12 #3

NeoPa
Expert Mod 15k+
P: 31,307
Correct me if I'm wrong, as I'm largely guessing here and trying to read between the lines (which indicates how poorly expressed the question is Stevan), but are you perhaps referring to the assigning of the database objects (Tables; Queries; Forms; Reports; etc) to Groups - normally available from the main database window?

If so, you should explain which version of Access you're using (as I believe these groups are very version dependent) and you should understand that the groups merely contain links (similar to shortcuts) to the said items, rather than these items being moved out of the main Table or Query window per se.
Jan 2 '12 #4

Brilstern
100+
P: 207
I apologize for the vagueness as it is kinda difficult to explain. Here goes though...

Vr. Access 2007
I do understand that none of these objects actually move from Category to Category/Group to Group. They are indeed shortcuts unless the are in the OM created group "Unassigned Objects", which is automatically added to all Categories UI or OM created alike.

I understand that there are UI and OM created categories. For ex. I use a UI created category of "Working" for my normal Navigation Pane view. Within this category it contains various groups particularly "Weekly Build Queries" which contains 6 queries for each week of the year (sometimes more than one in a week)in ex.

Expand|Select|Wrap|Line Numbers
  1. "A001-11" 
  2. "A001-11E"
  3. "T001-11"
  4. "T001-11E"
  5. "X001-11"
  6. "X001-11E"
These 6 queries were created on the first week of the year 2011.

Now when I create these they automatically are shown in the "Unassigned Objects" group within the "Working" Category. I then manually highlight all 6 new queries, right click and add to group "Weekly Build Queries".

My questions is there any way to expedite this. From what I have found online there is no a way to move them except through the UI. Do you know of a better way than my current action?

**Reason being I currently manage this database and make all changes but I will soon return home from this deployment and change over with my replacement. He might not be as access savvy so I need to make this as dummy proof as possible.**

Thx in advance. Hope there is a solution

Sgt B
Jan 2 '12 #5

NeoPa
Expert Mod 15k+
P: 31,307
I will reply promptly by saying I have no experience with this programatically at all. I've used Groups a couple of times in 2003 (My current version) but found the manual overhead required for my circumstances outweighed any benefits, so lost interest. I will have a quick look around for you, but if any other experts have any experience it would certainly be worth their jumping in.

PS. I think your last post made the situation (and the question) much clearer, so experts can at least focus on your question now :-)
Jan 2 '12 #6

NeoPa
Expert Mod 15k+
P: 31,307
I found this somewhat less than hopeful comment in Programatically accessing "object groups" :
Anthony England:
This is what I put into the Google Groups search page:
"database window" objects groups favorites
All answers (some by very experienced Access folk) seem to point to the
answer:

"Abandon all hope of doing anything with these - they are not accessable in
any way apart from the Access UI which is provided
"
My own researches found very little more than this. I found nothing that would help you I'm afraid :-(
Jan 2 '12 #7

ADezii
Expert 5K+
P: 8,616
@Stevan:
I'm afraid that your initial assumption may be correct in that there is no way to programmatically add a New Item to a Category, the only Option being through the User Interface.
Jan 3 '12 #8

Brilstern
100+
P: 207
Thank you both very much for your replies! I was afraid from the get go that I was SOL but I figured I would at least ask. I appreciate the prompt replies.
Jan 3 '12 #9

Brilstern
100+
P: 207
This may be a stretch but if you go to your navigation options in a database and select show system objects, you will see a series of tables in ex.

Expand|Select|Wrap|Line Numbers
  1. MSysAccessStorage
  2. MSysAccessXML
  3. MSysACEs
  4. MSysComplexColumns
  5. MSysIMEXColumns
  6. MSysIMEXSpecs
  7. MSysNavPaneGroupCategories
  8. MSysNavPaneGroups
  9. MSysNavPaneGroupToObjects
  10. MSysNavPaneObjectIDs
  11. MSysObjects
  12. MSysQueries
  13. MSysRelationships
  14.  
These are all the system objects on one of my particular database's.
Is there any connection here do you think that be used like an update query or something. I know this is really dangerous messing with system objects but just curious.

Sgt B

***I can provide my database if that would be easier.***
Jan 3 '12 #10

NeoPa
Expert Mod 15k+
P: 31,307
If it works at all it would only be for 2007 or later as the MSysNavPane... tables don't exist in a 2002/2003 database :-(
Jan 3 '12 #11

Brilstern
100+
P: 207
I think I might make the better decision here and leave it alone. Thx for everything.

Sgt B
Jan 3 '12 #12

ADezii
Expert 5K+
P: 8,616
I would strongly suggest NOT utilizing the System Tables to accomplish your goal, unless you knew in advance the purpose, Data Types, and acceptable Values allowed in each Field.
Jan 3 '12 #13

Brilstern
100+
P: 207
That is exactly my reason in putting it to rest. I know pretty much nothing about the inner workings of the system tables so I am just gonna put this aside indefinitely.

sgt B
Jan 3 '12 #14

NeoPa
Expert Mod 15k+
P: 31,307
Stevan:
I think I might make the better decision here and leave it alone
As ADezii so aptly says, unless you are absolutely sure of your ground in that area, this decision sounds eminently sensible.
Jan 3 '12 #15

Post your reply

Sign in to post your reply or Sign up for a free account.