?
Solved

Renaming Nave Pane Category Groups in Code

Posted on 2011-02-13
1
Medium Priority
?
508 Views
Last Modified: 2012-06-27
I have a FE that I distribute to use on multiple projects. Previously there were multiple copies all with differenct names. I now get the name of the project from the BE and display it instead of having to manually change the name fo the app for every copy distributed.

But the Nav pane uses Groups and the Category needs to reflect the project name.

I can manually rename the Category in Navigation options but I'd rather use code at startup to rename it from a record in the BE.

So how can I manipulate the Nave Pane Category Name using VBA?
0
Comment
Question by:kentgorrell
1 Comment
 

Accepted Solution

by:
kentgorrell earned 0 total points
ID: 34894092
Found what I was looking for in -
MSysNavPaneGroupCategories
Which I can modify using DAO
The change shows up straight away.
0

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
A quick solution showing how to control and open a POS Cash Register Drawer using VBA with MS Access.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

589 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question