By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,237 Members | 1,332 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,237 IT Pros & Developers. It's quick & easy.

Forms not Opening from Buttons or Navigation Pane

100+
P: 104
Our office is using Access 2010 with Windows 7 Professional. We have a back end file on our secretary's computer and there are 5 machines that run separate front end files. Very often my coworkers try to use some of the buttons I made to open forms or reports and they won't work. These buttons are run by simple Open Form macros, no VBA. You can't double click on the object in the navigation pane- nothing happens. It won't even open if you right click and choose "Open" from the menu. I have noticed this problem on every other computer except my own laptop which the application was developed on. The only way to get the object to open is to right click on it in the navigation pane and choose design view, then switch it to form/report view. For obvious reasons I not want people going into design view, but they definitely don't want to have to jump through these hoops to get a form open. Furthermore, if I open their FE file on my own laptop it works fine. Has anyone ever seen or heard of this problem before? I was thinking it must be some type of system setting that I don't know about.
Apr 29 '14 #1
Share this Question
Share on Google+
7 Replies


zmbd
Expert Mod 5K+
P: 5,397
Most likely issue is a broken link; HOWEVER, you do not mention any error messages.

When you distribute the front-ends out, do you have code in place to relink the back-end to the front-end or are you doing this by hand?

Next, is the use of Macros... I can not say enough about how much to avoid these unless you are going to be publishing to a sharepoint site. Macros were not really designed with a split database in mind from ACC0000 thru ACC2007 (IMHO, not even in ACC2010 nor 2013 either; however, at least they'll do something).

I think the following will work with ACC2007:
Open one of the macros behind your problematic command button, press <ctrl><a>, all of the command entries should be selected
<ctrl><c>, copy

Please, click on the [CODE/] button in the post toolbar and then paste your macro script between the [code] [/code] tags by placing the cursor betwee the two tags and <ctrl><v>.

If this doesn't paste your Macro code into the post, then you will have to hand type the script between the code tags.
Apr 30 '14 #2

Expert 100+
P: 1,240
I think the OP is saying the problem is not limited to the macro. It happens even when they click on the Form name itself.

GKJR, what events are being handled in form? Is there an "Enable this content" button appearing anywhere on the Access window of the users having the problem?

Jim
Apr 30 '14 #3

zmbd
Expert Mod 5K+
P: 5,397
jimatqsi :
I think the OP is saying the problem is not limited to the macro. It happens even when they click on the Form name itself.
Which if you will read my post, I said that most likely there is a linkage issue.

Also I Inquired about any code to handle any re-linking.

I then asked about the Macro - as macro security can prevent certain commands from running.

Is there an "Enable this content" button appearing anywhere on the Access window of the users having the problem?
Now that is a very good question and I should have asked... I forget that ACC2007 has that security "feature" along with simply disabling some commands without notice.
Apr 30 '14 #4

100+
P: 104
I'm going to try writing the code in VBA instead and see if that works.
Btw I'm using Access 2010, not 2007.
As far as a linking issue, why would I be able to get the form open from design view if there was a linking error? I should also add that many of the forms that are giving me an issue are unbound forms that I use to create filter strings to open a report with.
Apr 30 '14 #5

zmbd
Expert Mod 5K+
P: 5,397
I'm going to try writing the code in VBA instead and see if that works.
You can also try the convert macro to vba tool
(ACC2010)
Open the form in design mode.
Select the control with the embedded macro
In the standard ribbon>Form Design Tools>Tools>Convert Form's Macros to Visual Basic.
Should convert all of the Macros associated with the from into the VBA equivalent. Not pretty coding by any means and often not the most effecient conversions; hoewever, it can save you alot of time.


Btw I'm using Access 2010, not 2007.
Sorry, don't know where I got that 2007 from. I'm blaming the grimlins (^_^)

As far as a linking issue, why would I be able to get the form open from design view if there was a linking error?
Just a guess based upon an old issue I encounted in my ACC2003 days. The forms worked just fine on my pc; hoewever, not on my bosse's. Turns out that I had some macros behind the buttons (used the wizard back then and didn't realize the limits of Macros). Seems that the forms would error when opened via code or directly but not indirectly via the design. Re-linked the tables and the issue went away... go figure... when you've been at this for 20+years you get to see some unique stuff.
I've had things that work on my PC at home and not at Work - other than a network connection, same setup.

I should also add that many of the forms that are giving me an issue are unbound forms that I use to create filter strings to open a report with.
So the macros pull information from the form and then attempt to open other forms?
As jimatqsi mentions; Do you have any on-open/load events? Do your other users have the security pop-up?
Apr 30 '14 #6

100+
P: 104
"So the macros pull information from the form and then attempt to open other forms?"
There is a separate button on my pop up form that opens the report and there are no problems with that.
"Do you have any on-open/load events?"
There is an on-load event in the pop up form in question to update one of the combo box controls.
Apr 30 '14 #7

zmbd
Expert Mod 5K+
P: 5,397
There is an on-load event in the pop up form in question to update one of the combo box controls
Please see here first: > Before Posting (VBA or SQL) Code
Goto one of the problematic PC
Then follow the setup and troublshooting steps as given in the above link.
Please post back any errors you receive.
If you do receive an error also post your code.
Apr 30 '14 #8

Post your reply

Sign in to post your reply or Sign up for a free account.