Creating Groups and adding tables to them

[Hector H]

Does any one know how to use vb to create group shortcuts using vb? My goal is to populate Access database with tables and create group shortcuts for sorting in one click(not including prompt for table name)

 

[SOS]

As far as I know, the groups within the Navigation Pane of Access 2007 (which I'm assuming you are talking about) are database specific and there is no method for importing them to another database.

 

[SOS]

Well, I could be wrong about the importing, so maybe there is a way. I just found this which says that there is an option to import the groups when you do import objects, just like where you can select to import the IMPORT/EXPORT SPECS. But I haven't seen any code to add tables to custom groups yet.

 

[Hector H]

Thanks, I don't want to import the groups. I just want to automate the process of creating a group short cut and sorting the tables into approriate group. Example: for case X five different tables will be created named X_1, X_2,... Now I want to create a group called X_tables and populated with tables for case X.

 

[SOS]

Haven't seen anything like that available currently. I'll keep looking but they probably didn't enable that functionality

 

[Hector H]

Thanks. I was thinking I could try to use the Edit menu. Tell VB to go to tool bar select Edit, then New Group..., maybe.

 

[SOS]

That would require the use of SendKeys and that is not a stable way to do things.

 

[Hector H]

I was able to find this DoCmd.RunCommand(acCmdNewGroup) but it only opens the dialog box to enter the name. I want to pass the name to it not have the user enter it. Any suggestions

 

[SOS]

Any suggestions

No as I saw the dialog too and once I had seen that, I knew it was pretty much a manual process. You could try using SendKeys but it is something I've stayed away from as there are so many who have said, "Don't use them as they aren't stable and don't work in all situations."

 

[Hector H]

Well, thanks anyways, I'll probably steer clear of the Sendkeys, but if you come across anything useful please post it.

 

[Hector H]

If I wanted to use the SENDKEYS how would I have it enter into the dialog box. I can't put it after because it does not get to that part of the code and if I put it before nothing happens.

 

[SOS]

Frankly, I'm not sure and I don't have 2007 here with me to be able to play with it. Maybe someone else might know. (hint, hint to those reading this right now...)

 

[HiTechCoach]

Hector H,

I am really curious why you would need this. Are you wanting to do this to help the developer/programmer when working in back end database?

 

[Hector H]

I am actually using 2003 if that makes a difference.

 

[Hector H]

Coach,

We run a large number of different scenerios for comparisons and each case has multiple input files, case by case comparisons, and tables htat return calculations based on the inputs. It would be really helpful to have them grouped together becuase the database will get pretty large.

 

[SOS]

I am actually using 2003 if that makes a difference.

I can't see anywhere that you could reference that dialog object in code. As for SendKeys, I haven't used them in so long, I don't know if I could use them or not.