473,836 Members | 1,529 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Some Help on Navigation Categories and Newly Created Queries

208 New Member
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
14 16426
12,516 Recognized Expert Moderator MVP
I have no idea what you mean by category.
Jan 2 '12 #2
208 New Member
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
32,584 Recognized Expert Moderator MVP
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
208 New Member
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
32,584 Recognized Expert Moderator MVP
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
32,584 Recognized Expert Moderator MVP
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

"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
8,834 Recognized Expert Expert
I'm afraid that your initial assumption may be correct in that there is no way to programmaticall y add a New Item to a Category, the only Option being through the User Interface.
Jan 3 '12 #8
208 New Member
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
208 New Member
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
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

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

Similar topics

by: yootzee | last post by:
Greetings all, I'm having a problem with scrolling vertically in a newly created browser window. The vertical scrolling is to reach some anchor point within the new browser window. I'm attempting to do this by using an anchor point name of an anchor located
by: pmatos | last post by:
Hi all, Sometimes I have a function which creates an object and returns it. Some are sets, other vectors but that's not very important. In these cases I do something like this: vector<int> * f() { vector<int> * v = new vector<int>; return v; }
by: NB | last post by:
Hi This has been tickling my mind for quite some time. Can someone tell me if Access 2003 has a solution for it. After a period of development, your front end will definitely bloat despite all the compacting and decompiling you do. The best solution so far I have found is to create a fresh new mdb file and import all table (links), queries, forms, reports, menu, macros and modules. That is great: file size shrinks and it runs faster...
by: Earl Teigrob | last post by:
I am having a problem where the bitmap image that I just created and saved to disk can not be found but the code in another area of the program. When I reattempt to access the same image, it always works becuase the image has been fully saved to that drive by that time. Is there a way to make sure that a newly created bitmap image is phisically saved to disk before it is accessed? The code that creates that new bitmap image is as...
by: mcwooq | last post by:
Hi, I just installed the VS.Studio 2005 Team Edition for Developper and encountered severe problems with debugging ASP.NET 2.0 projects. Even newly empty created ASP 2.0 projects can't debug (setting breakpoint in page_load()). I'm getting the following message: "Unable to start debugging on the web server. An error occurred that usually indicates a corrupt installation (code 0x80004002). If the problem persists,
by: Eddie Suey | last post by:
I'm creating a directory and a file in the directory. When I try to write to the file I get the following error: "Can not access the file ... because it is being used by another process". The directory and file are created just fine - in fact, I can restart the program and since the path has already been created, I can write to the file with no problem. I only get the error when I have to first create the path and then I try to write...
by: mcmwhite | last post by:
Hi, Does anyone know how I can open a newly-created HTML page in a new window, using ASP.NET? Eg. I have an ASP.NET page which creates some new HTML, based on what the user has entered into a textbox. The ASP page has a textbox (txtYourName) and a button. Clicking the button will run this piece of code:
by: Edward Lorden | last post by:
I created a new website, using the ASP .NET Website template. Before I did anything, I tried running it in debug mode. This worked, giving a blank page. I then moved the site to become the default site on my machine. At first, I had issues with an XML error that came up. After I setup IIS to use ASP .NET 2.0, I started getting the 403 -- You are not authorized to view this page, when I try to look at localhost. Is there some code...
by: =?Utf-8?B?RGFuaWVs?= | last post by:
I'm working with the FileSystemWatcher which has a Created event. But this event is raised as soon as the new file begins to be written on disk. What I want is a notification after a file being entirely written. Is there anyway to achieve this? Thanks. Daniel
by: HerbAsher | last post by:
Hi! I have some questions. I'm evaluating berkeley db as a embeddable storage engine for a project I'm working on. My questions: 1. Now that Berkeley DB is part of Oracle, is it still being maintained? Is it free? 2. Are there good python libraries for bdb available, that are being
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.