rkm360
asked on
Access 2003/2007 Switchboard Issues
Experts, I need help!
I have a secured DB I built in Access 2003 that I am now opening in 2007. The switchboard does not work correctly and I cannot figure out what is missing.
When I open the switchboard form, I get a switchboard form with one visible button. When I click this button, I get the attached screen shot.
I have added several options in the switchboard manager, and have deleted everything and created a new switchboard from scratch, but still this is all I get.
I seem to recall a few posts I have seen before with other having this issue, but I could not find them in the archives. I do not understand what is missing or why I can't get it to work correctly.
Thanks in advance for any help!
Robert
Access-Switchboard-screenshot.doc
I have a secured DB I built in Access 2003 that I am now opening in 2007. The switchboard does not work correctly and I cannot figure out what is missing.
When I open the switchboard form, I get a switchboard form with one visible button. When I click this button, I get the attached screen shot.
I have added several options in the switchboard manager, and have deleted everything and created a new switchboard from scratch, but still this is all I get.
I seem to recall a few posts I have seen before with other having this issue, but I could not find them in the archives. I do not understand what is missing or why I can't get it to work correctly.
Thanks in advance for any help!
Robert
Access-Switchboard-screenshot.doc
Error: Function name is missing.
Are you sure you don't have a function being called that spelled incorrectly? Or it's set to private? Possibly a module is missing?
Are you sure you don't have a function being called that spelled incorrectly? Or it's set to private? Possibly a module is missing?
ASKER
I tried to run the reference tool, and it is asking for a VB password. I never set a VBE password because I am the only person with access to the VB module so I am not sure how it got a password what to do there.
The weird thing now is I am working with the same front end in both 2007 and 2003. Everything works perfectly in the 2003 version, but in 2007 it does not work at all.
Even when I create the switchboard in 2007, then close the DB and open it in 2003, the new switchboard (that was created in 2007) is in place and works perfectly, but then I open back in 2007 and it won't work.
The weird thing now is I am working with the same front end in both 2007 and 2003. Everything works perfectly in the 2003 version, but in 2007 it does not work at all.
Even when I create the switchboard in 2007, then close the DB and open it in 2003, the new switchboard (that was created in 2007) is in place and works perfectly, but then I open back in 2007 and it won't work.
Can you upload the DB ?
Never heard of asking for a pwd if it was not set ...
mx
Never heard of asking for a pwd if it was not set ...
mx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you, I will work on that as soon as possible and see how it does......if not I'll try to upload it.
Robert
Robert
Other than the 'oddness' of the password gig, pretty sure it's a reference problem.
ASKER
Ok, I ran the decompiling as you suggested. Then, when all was done, I reopened and created a new switchboard using the manager in 2007. This time I at least got a code error to start with.
The error is in this code line:
Set con = Application.CurrentProject
(the note says <data source object is already initialized>
Unfortunately I am still unexperienced with VBA, expecially troubleshooting, so I am not sure where to go from here.
The error is in this code line:
Set con = Application.CurrentProject
(the note says <data source object is already initialized>
Unfortunately I am still unexperienced with VBA, expecially troubleshooting, so I am not sure where to go from here.
Are you able to do this now:
Open the VBA editor >> Tools >> References. Look for any listed as:
**MISSING <SomeReferenceName>
?
Open the VBA editor >> Tools >> References. Look for any listed as:
**MISSING <SomeReferenceName>
?
ASKER
I can open it in 2003, but it only shows me a list of possible reference lists with a handful of them checked to show. I don't see anything "missing" anywhere.
When I open VBA in 2007, the References link is grayed out and will not let me open it.
When I open VBA in 2007, the References link is grayed out and will not let me open it.
OK .... did you run the Decompile in A2007 also ?
ASKER
I did, and it will still not let me run the "reference".
However, I did just discover a new piece of this puzzle.
I used my boss' computer (he has Office 2007 loaded on his desktop) to decompile in 2007. When I open the DB on his computer in 2007, everything is perfect. When I open it through the Citrix window on my computer, I'm back to the same old error.
So, it looks like Citrix is the key here, not the 2007 aspect. I am going to upgrade my machine in the morning to 2007 and see if I get the same results.
However, I did just discover a new piece of this puzzle.
I used my boss' computer (he has Office 2007 loaded on his desktop) to decompile in 2007. When I open the DB on his computer in 2007, everything is perfect. When I open it through the Citrix window on my computer, I'm back to the same old error.
So, it looks like Citrix is the key here, not the 2007 aspect. I am going to upgrade my machine in the morning to 2007 and see if I get the same results.
There ya go :-)
mx
mx
ASKER
Ok, I installed 2007 on my desktop and the links work fine now. Once I enable the Macros the switcboard works correctly too, so it appears the issue is with Citrix. Now that I can open correctly without it, I will leave it at that.
Thank you for all your help!
Thank you for all your help!
Excellent.
mx
mx
**MISSING <SomeReferenceName>
Resolve.
Possibly the ADO reference is missing - which the switchboard needs ?
mx