Switchboards

[BrentJ]

Quick and simple. I have several switchboard pages. Is there a way to call a particular switchboard page (not the main switchboard) with a macro? Thanks.

 

[hneal98]

Rename each of the other switchboards and then have your main switchboard setup to call each of the other switchboards.

 

[BrentJ]

Thank you for the help but that does not accomplish what I want it to do. I have other things that need to be done as well upon changing switchboard pages, therefore I have to use the main switchboard buttons to run a macro to accomplish them prior to changing pages and effectively leaving me no way to actually change the page without doing so via the macro. I am sure that it can be done but I cannot figure out how to have the macro open the switchboard to a particular page.

I have a database with information for the entire company, with 8 sub-sections. All reports and forms can be filtered to a particular section. All reports and forms are identical with the exception of the filtered data. Currently I have to create a switchboard button for every form and report for every section which results in a horrendous mess of switchboards. I want to essentially have the main switchboard choose the section, and the rest of the switchboards will be generic, simply opening the universal form or report, filtered according to the section selected via the main switchboard.

I have thus far been unsuccesful in accomplishing this via a macro and I am experimenting with doing this via vb code, but I know very little about vb (Just experimenting with copying and manipulating existing code.)

This problem is very critical for me to resolve and any help will be greatly appreciated. Thanks in advance.

Brent

 

[hneal98]

So do it via the macro you already have. Just call the new page after whatever it is you have to do is done.

It almost sounds like you need to rethink the design. Perhaps some of the forms could be called from other forms.

 

[BrentJ]

Okay, the macro that I have now is a work in progress that I created specifically to call the switchboard after the other things were done, the problem is in calling the switchboard to a page other than the default. I can have the macro open the switchboard but it always goes to the default menu. I need to specify a submenu (i.e. [SwitchboardID]= 2)I know that there has got to be a way to have the switchboard open into a specific page or be sent to a specific page after opening(maybe by using runcode and using conCmdGotoSwitchboard in vb?) I am not knowledgeable enough about vb to pull it off. I am trying but I am pretty much blindly putting code together.

 

[hneal98]

What kind of stuff needs to be done before you open your forms? Is it something that initializes something for the forms? Is it possible to open the form and then on opening the form, have the form call the macro?

Unfortunately, I don't have time to teach you Access. I know it can get frustrating, but you need to somehow get a basic knowledge to save you a lot of time and efford.

 

[BrentJ]

Okay, obviously I am not going to get any help here, other than people stating the obvious. I have more than a basic knowledge of access and have created a number of local databases for different sections and offices at work, good enough for them to ask me to do a central database for the entire company. Just because you don't know the answer is no reason to attack my proficiency, especially seeing as how no-one else seems to know either.