Switchboard problem....

[BobNTN]

I zipped my db and emailed it to my sister. Have the switchboard activated.
After she unzipped it, when it comes up, all the switchboard items text display in some sort of machine language. However, all the forms, reports, etc. work fine.
I have the macro security setting set to low on my pc and both hers (home and office) and all three are running Access 2003 with same settings. At least the best I can tell.
Does the same thing on both hers. I also zipped and emailed it to me. Works fine. Sounds like some setting I'm missing on the other two Access ?
Anyone heard of this or know what may be causing it ?

 

[BobNTN]

As a follow up to my post, I redid all the 4 switchboards from scratch and made an mde file.
Emailed it again and still the same problem.
Have went through all settings on all and made sure they were the same as mine.
Only affects the text on the switchboards. Appears as encrypted code. (symbols and such)

Looked through MS knowledge base couldn't find anything.
Anyone have ANY ideas ?

 

[boblarson]

Do you both have all of the same fonts?

 

[boblarson]

Yes, it does it on mine as well. What font are you using? I still have your older version in mdb format and its switchboard works fine.

 

[BobNTN]

Well I have Romantic on the text on the switchboard form itself. I am assuming any additional switchboards are just structure copies of the switchboard form ?
I'll bet you are correct.
I would like to delete all the switchboards AND the table it builds and start it again without any text changes. Any inherent problems with the switchboard manager re-initializing it ?

 

[boblarson]

I think you can delete the switchboard, the table that goes with it and then import everything into a new mdb file and then start over. But, you should be able to go into design view on the switchboards and then select the blank labels and change the font to something standard like Arial, Times Roman, Tahoma, etc.

 

[BobNTN]

I'll bet I installed extra fonts onmy pc and when I installed the other two, I probably did a typical install. Just can't remember.

Anyway, at this point I would rather start with a fresh switchboard.
I deleted the switchboard form, exited, reopened and it said the switchboard form was missing or spelled incorrectly.
Made a new one and it had the same fonts on it.

So if I go into Switchboard manager, delete everything except the default which it won't let me do, then delete the table and the form, it won't initialize it again thru the manager ?

How does one import the whole db to a different name ?

 

[boblarson]

How does one import the whole db to a different name ?

1. Close all databases but leave Access open.

2. Click FILE > NEW and in the task pane select BLANK DATABASE and then name the file in the dialog that appears on the pane.

3. Click FILE > GET EXTERNAL DATA > IMPORT

4. Select Access from the drop down list of types

5. Navigate to your old db

6. When the dialog appears, you will see several tabs; one for each object type:
Tables/Queries/Forms/Macros/Pages/Modules, etc.

7. Click on each one and select the SELECT ALL button to highlight them all. If there are any you DON'T want imported just hold your control key down and click on its name after selecting all and it will be deselected.

Click on each tab doing that highlighting.

8. Click the OPTIONS button on that dialog and select the checkboxes RELATIONSHIPS, MENUS and TOOLBARS, IMPORT/EXPORT SPECIFICATIONS (only if you want any of those imported).

9. Also on the Options, keep the IMPORT TABLES and IMPORT QUERIES at the default (IMPORT DEFINITION AND DATA and AS QUERIES).

10. Once you've done all of that, hit OK.

You'll need to go to TOOLS > STARTUP to set your startup options.

 

[boblarson]

Yep, it works fine now - even as an MDE file.

 

[BobNTN]

Man you are a lifesaver again.

Now if you will indulge me on a couple of points I can finish this up.

1. How do i get the startup switchboard to maximize on open ? I suppose the DoCmd.maximize but in looking at the on open event codes, there are tons of code in there and I wouldn't know where to insert it.
2. Do I have to customize the toolbars on each form / report since I just want to have a very few on each ?

 

[boblarson]

1. Yes, you would put it in the switchboard's On Open event, but you really don't need to do that (unless you absolutely want it that way). If you don't want the database window showing just unselect the Display Database Window option in the Startup Options. If you do put DoCmd.Maximize in the on Open event, just put it after any of the code there and before the End Sub.


2. If you want customized toolbars, you just need to create it as a custom and then set it in the TOOLBAR property for each form/report you want it to show up with.

 

[BobNTN]

Thanks Bob, really thanks.

One more
The Exit Application in the switchboard does just that. Can it be edited to also exit access ?

That's it for tonight. Maybe for good on this db.

 

[boblarson]

Here's a revised copy for you. I added a function and then used the Run Code for the switchboard.

 

[BobNTN]

From one Bob to another, thanks greatly.
Mana is on the way.

 

[AccessJunkie]

Bob already has you covered just fine, but just in case you have other Switchboard Manager questions, I have entire FAQ page on the subject. You might in the future find some of the information useful:

http://www.accessmvp.com/JConrad/accessjunkie/switchboardfaq.html

--------------------
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------

 

[boblarson]

You might in the future find some of the information useful:

http://www.accessmvp.com/JConrad/accessjunkie/switchboardfaq.html

Thanks Jeff - Good stuff as usual. I tell you, it is so hard to remember all of the good reference material out there.

 

[ahuvas]

I think you should take that down if it is real peoples data