469,300 Members | 2,248 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,300 developers. It's quick & easy.

Some Help on Navigation Categories and Newly Created Queries

Brilstern
208 100+
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 :-(

14 15548
Rabbit
12,516 Expert Mod 8TB
I have no idea what you mean by category.
Jan 2 '12 #2
Brilstern
208 100+
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
32,173 Expert Mod 16PB
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
208 100+
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
32,173 Expert Mod 16PB
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
32,173 Expert Mod 16PB
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
8,800 Expert 8TB
@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
208 100+
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
208 100+
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
32,173 Expert Mod 16PB
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
208 100+
I think I might make the better decision here and leave it alone. Thx for everything.

Sgt B
Jan 3 '12 #12
ADezii
8,800 Expert 8TB
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
208 100+
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
32,173 Expert Mod 16PB
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.

Similar topics

2 posts views Thread by yootzee | last post: by
29 posts views Thread by pmatos | last post: by
reply views Thread by Earl Teigrob | last post: by
4 posts views Thread by mcwooq | last post: by
18 posts views Thread by Eddie Suey | last post: by
1 post views Thread by mcmwhite | last post: by
4 posts views Thread by Edward Lorden | last post: by
3 posts views Thread by =?Utf-8?B?RGFuaWVs?= | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by harlem98 | last post: by
1 post views Thread by Geralt96 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.