Switchboard Issues

[TashaSpicer]

I have a database that is set up in Access 2007, but saved down to 2002-2003 to accomodate multiple users. On my machine, which has 2007, I am able to open the database which opens to the switchboard and all the information is there, no issues. When I try to open the database on a machine that uses Access 2003, I get the following prompt on open:

Enter Parameter Value

TempVars!Switchboard ID

I haven't intentionally set an temporary variables, and don't see any anywhere in the macro and I haven't set up any queries yet so getting the prompt is very confusing to me. I have had to rebuild this datbase twice due to it crashing on our shared drive and I am about to pull my hair out, or quit my job one and I would not be attrative bald nor do I wish to be looking for a new job in this economy so any and all help is very much appreciated!! Thanks.

Tasha

 

[Uncle Gizmo]

"TempVars" is only available in Access 2007.

 

[Uncle Gizmo]

You should build your database in the lowest version it will be used in....

 

[TashaSpicer]

If it is only available in 2007 why is it popping up the prompt in 2003 and when I go in to 2007 it doesn't show any TempVars? Is there anyway I can take it out? The Help button mentioned doing it in the argument section of the Macro, but it won't let me alter that information.

 

[Uncle Gizmo]

Try making the switchboard in 2003

 

[SOS]

The TempVars collection is available in 2007 from macros or VBA code. The macro that is using this is probably an EMBEDDED Macro which Access 2007 sets up by default for most of the actions when you go to add something (including the switchboard).

So, since that object does not exist in 2007 then it can't use it in 2003, as Uncle Gizmo has said.

For what it is worth, I would just get rid of the switchboard altogether and then create your own form to do what you want done and that way you can have more control about how it is built and what gets added to it. Personally, I do not like using the switchboards as they feel too limiting to me.

 

[Uncle Gizmo]

>>>I do not like using the switchboards as they feel too limiting to me<<<

I know what you mean; switchboards out of the box so to speak are a bit limited. However with some minor tweaks you can make them much more powerful, in that you can have them run functions, and also pass variables into those functions.

The other thing to note about to the switchboard functionality is that it’s a very good example of how to build and control an object programmatically.

The Switchboard is only one form with eight controls on it, the text for each control is passed in from the switchboard table. The switchboard table also controls what should happen when you press on one of the buttons. It’s well worth studying if you want to take your programming skills to another level in this regard.

 

[gemma-the-husky]

fwiw, i actually think the MS provided switchboard is very useful.

i actually extend mine to 21 selections, which is more useful, and have tweaked some of the functions to make them more informative/flexible

I tend to use two columns of 10 commands with an extra final slot for the return menu options.

I think the hierarchical menu format is appropriate in large systems with many options - where there are too many options to include them all on a single page.

I also tend to provide a modfieid menubar - and leave it up to users whether they prefer to work from the switchboard, or from the menu bar.

 

[TashaSpicer]

I have reloaded Access 2003 on my machine and I have all elements in the 2003 database, but the switchboard is still giving me problems. Whenever I go in and set it up using either the macros I have desiged or I use the functions given in the drop down boxes when creating the switchboard I get the following message:

"The expression On Open you entered as the event property setting produced the following error: Object or class does not support the set of events."

I have no clue what I have done. The macros are as simple as this:

Open Form in add mode

Open Report in Print Preview

I know the macros work, as I have ran them from the macro area, but the switchboard refuses to work.

Any clues?

Thanks!
Tasha