Switchboard Issues

[Guest]

I have a database that is split with tables on the back end, forms, etc on
the front end. There is one user other than myself and I create an .mde for
her to work from. I use a seperate .mdb file where I make all the updates
and then create the .mde for her.

The problem I am having relates to the switchboard. My switchboard works
great in the .mdb, no problems. I have never gotten the switchboard to work
properly on her system. It opens with only option 5 of the 3rd page on the
switchboard. I have also tried making a seperate .mdb for her to use, with
no luck.

I have checked the table and the switchboard manager on both systems and
they are identical. I don't understand why it would open differently on two
different systems. Any ideas?

Thanks!
Mer

 

[Guest]

I forgot to mention that the switchboard table is local, not linked, because
I read about there being some problems with linked switchboard tables.

 

[Guest]

Have you tried building your own menu from a form?

 

[George Nicholson]

You don't specify what version(s) of Access you are using, but in any case:
make sure both machines have the most current service packs, etc. When 2
machines act differently, that's the 1st thing to eliminate.

 

[Guest]

I did start to make my own switchboard, but realized quickly I was wasting
too much time that could be used in other functional aspects of the database.
In theory, it would be nice, but we are under some serious time constraints
for this thing to do what we need it to do.

I thought about the Jet version being the problem but honestly thought it
was a long shot. I am running the most current version and she is a couple
of service packs back, but we have been unable to get this installed on her
system because we are locked down tight as a tick. I am currently jumping
through hoops to get our IT department to allow her to install the most
current update. Could Jet really cause the problem?

Thanks for your help!
Mer

 

[Jeff Conrad]

I did start to make my own switchboard, but realized quickly I was wasting
too much time that could be used in other functional aspects of the database.
In theory, it would be nice, but we are under some serious time constraints
for this thing to do what we need it to do.

I thought about the Jet version being the problem but honestly thought it
was a long shot. I am running the most current version and she is a couple
of service packs back, but we have been unable to get this installed on her
system because we are locked down tight as a tick. I am currently jumping
through hoops to get our IT department to allow her to install the most
current update. Could Jet really cause the problem?

Hi Meredith.

Certainly Jet and Access service packs can make a difference. This is not
to say that this *is* the problem, but it very well could be.

You still have not indicated what version of Access you are using, service
pack level, and Jet version.
Please provide the following information on your machine AND her machine:
1. Access version
2. Access service pack level
3. Jet file version

Let's get that established first before trying a few things.

 

[Guest]

As of today, IT finally got around to helping her update and we are now both
using the same version of Access 2003 (11.6355.6360) SP1 and Jet
(4.0.8618.0). Just got done testing and we still have the same problem. I'm
truly stumped now.

I do appreciate you guys helping with this.

Mer

 

[Jeff Conrad]

As of today, IT finally got around to helping her update and we are now both
using the same version of Access 2003 (11.6355.6360) SP1 and Jet
(4.0.8618.0). Just got done testing and we still have the same problem. I'm
truly stumped now.

I do appreciate you guys helping with this.

A couple of things to look for:
1. What macro security level is the person set at?
Sandbox mode could be interferring with the Switchboard functionality.

2. Any References marked as "Missing" on the other machine?

 

[Guest]

I apologize for the delay in getting back to you... I looked at both of our
macro security levels. We are both at Medium. Should I move this to low?

I also checked the references. I have one additional checked that I believe
I added in a long time ago which is Microsoft Calendar Control 11.0. I do
not believe I actually used this for anything, but was trying to get a pop-up
calendar of some type working. I could not find this on her list, but didn't
see anything "missing" either. I removed the check from mine, but I'm not
sure what difference that will make. I'm getting into a hazy area for me
with the references. I don't understand them very well. I'll list what we
have checked just in case:

Visual Basic for Applications
Microsoft Access 11.0 Object Library
OLE Animation
Microsoft DAO 3.6 Object Library
Microsoft ActiveX Data Objects 2.1 Library
Microsoft Outlook 11.0 Object Library
Microsoft Word 11.0 Object Library
(Only on mine and now removed) Microsoft Calendar Contol 11.0

Just so you know, I tried recreating the entire switchboard yesterday. I
removed the old one completely and had Access prompt me to make a new one. I
re-entered everything. The same problem is occuring.

I am including the FillOptions code. There is one part that has me a little
confused. The SetFocus portion says " Set the focus to the first button on
the form and then hide all of the buttons on the form but the first. You
can't hide the field with the focus." This is precisely the problem we are
having on hers. She can only see the first button. Unfortunately, my coding
abilities are limited so I may not be deciphering it properly.

Private Sub FillOptions()
' Fill in the options for this switchboard page.

' The number of buttons on the form.
Const conNumButtons = 8

Dim con As Object
Dim rs As Object
Dim stSql As String
Dim intOption As Integer

' Set the focus to the first button on the form,
' and then hide all of the buttons on the form
' but the first. You can't hide the field with the focus.
Me![Option1].SetFocus
For intOption = 2 To conNumButtons
Me("Option" & intOption).Visible = False
Me("OptionLabel" & intOption).Visible = False
Next intOption

' Open the table of Switchboard Items, and find
' the first item for this Switchboard Page.
Set con = Application.CurrentProject.Connection
stSql = "SELECT * FROM [Switchboard Items]"
stSql = stSql & " WHERE [ItemNumber] > 0 AND [SwitchboardID]=" &
Me![SwitchboardID]
stSql = stSql & " ORDER BY [ItemNumber];"
Set rs = CreateObject("ADODB.Recordset")
rs.Open stSql, con, 1 ' 1 = adOpenKeyset

' If there are no options for this Switchboard Page,
' display a message. Otherwise, fill the page with the items.
If (rs.EOF) Then
Me![OptionLabel1].Caption = "There are no items for this switchboard
page"
Else
While (Not (rs.EOF))
Me("Option" & rs![ItemNumber]).Visible = True
Me("OptionLabel" & rs![ItemNumber]).Visible = True
Me("OptionLabel" & rs![ItemNumber]).Caption = rs![ItemText]
rs.MoveNext
Wend
End If

' Close the recordset and the database.
rs.Close
Set rs = Nothing
Set con = Nothing

End Sub

One last thing... I have tried copying the database to two comletely
different systems, and they are able to see the switchboard with no problems.
This tells me that it's something specific to my users system. But I just
have no idea what it could be.

Sorry to bombard with so much info. I hope this helps give a better picture
of what's going on here. Thanks so much for your help!

Meredith

 

[Jeff Conrad]

Hi Meredith,

Comments inline....

I apologize for the delay in getting back to you... I looked at both of our
macro security levels. We are both at Medium. Should I move this to low?

If you were both having the same problem this would lead me to believe
that the macro security level could be interferring. However, you are
both at the same level and yet your Switchboard works just fine.

Humor me though. Change her level to Low temporarily.
Does it work now or not?

I also checked the references. I have one additional checked that I believe
I added in a long time ago which is Microsoft Calendar Control 11.0. I do
not believe I actually used this for anything, but was trying to get a pop-up
calendar of some type working. I could not find this on her list, but didn't
see anything "missing" either. I removed the check from mine, but I'm not
sure what difference that will make. I'm getting into a hazy area for me
with the references. I don't understand them very well. I'll list what we
have checked just in case:

Visual Basic for Applications
Microsoft Access 11.0 Object Library
OLE Animation
Microsoft DAO 3.6 Object Library
Microsoft ActiveX Data Objects 2.1 Library
Microsoft Outlook 11.0 Object Library
Microsoft Word 11.0 Object Library
(Only on mine and now removed) Microsoft Calendar Contol 11.0

That all looks pretty good. The swithboard code you posted is using
ADO code, but you do have that reference checked. You also have
DAO checked, but the Switchboard code is properly declaring
everything so I do not see anything immediately wrong here.

One thing to try on her machine. Uncheck this one:
Microsoft ActiveX Data Objects 2.1 Library
Then close the References box.
Open it back up and find this one and check it:
Microsoft ActiveX Data Objects 2.5 Library
(On a new database in 2003 that is the default I get)
Make sure the priority is below the DAO one.
Compile the code.

Does it work on her machine now?

Just so you know, I tried recreating the entire switchboard yesterday. I
removed the old one completely and had Access prompt me to make a new one. I
re-entered everything. The same problem is occuring.

Humm...but it only fails on her machine, correct?

I am including the FillOptions code. There is one part that has me a little
confused. The SetFocus portion says " Set the focus to the first button on
the form and then hide all of the buttons on the form but the first. You
can't hide the field with the focus." This is precisely the problem we are
having on hers. She can only see the first button. Unfortunately, my coding
abilities are limited so I may not be deciphering it properly.

While "technically" that is correct, I do not believe the code is the root of the
problem here.

One last thing... I have tried copying the database to two comletely
different systems, and they are able to see the switchboard with no problems.
This tells me that it's something specific to my users system. But I just
have no idea what it could be.

Most pecuilar.

Sorry to bombard with so much info. I hope this helps give a better picture
of what's going on here. Thanks so much for your help!

A couple of things to try. Please post back with the results.

1. Create a new database. Import just the Switchboard items table
and form from the main database file into this new container. Compile
the code and then Compact. Reopen and see if you can see all the various
menu buttons on your machine. Don't worry about clicking options
that open forms/reports, etc. I just want to know if you see all the options.

Now copy that small file onto her machine. Can you see all the options
on her machine?

2. Take the main database file (MDB one) from your machine and place
on her machine. Delete the Switchboard Items table and form from this
database. Compact the database. Now use the Switchboard wizard
to create a new table and form in her database on HER machine.
Can you see all the options on the form now?

Let me know.