473,320 Members | 1,766 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Forms not Opening from Buttons or Navigation Pane

108 64KB
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
7 7007
zmbd
5,501 Expert Mod 4TB
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
jimatqsi
1,271 Expert 1GB
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
5,501 Expert Mod 4TB
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
GKJR
108 64KB
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
5,501 Expert Mod 4TB
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
GKJR
108 64KB
"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
5,501 Expert Mod 4TB
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

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

Similar topics

1
by: SteamyFrog | last post by:
I'm looking to place an icon for my app on the Navigation Pane (lower right of task bar), yet haven't been able to find any information on how to do this. The app basically is a running file...
4
by: robert.waters | last post by:
Hello, I have a main form that is maximized when my application loads; this main form contains links to all other forms. I've had to specify the Popup property of these other forms, so that...
0
by: Wayne | last post by:
I've been looking and maybe I've missed something but is there a way to undock the navigation pane or at least not have it "always on top" in design view? I realize it can be minimized, but having...
5
by: Patrick | last post by:
I have set the Navigation Pane so that it is not displayed on startup of my application. However, if I programmatically link to an external Access table, the navigation pane automatically...
1
by: chupachup32 | last post by:
I'm a student trying to teach myself to use access. I somehow managed to minimize my navigation pane and now I can't figure out how to reopen it. The Access handbook says that, even when minimized,...
2
by: Bob | last post by:
Hi, In runtime environement my access 2007 application dont show the Navigation Pane, anybody have this problem ? Thank's for reply Bob
0
by: Walter Raymond | last post by:
Our backend Access 2007 database will be locked but we don't want our users to have access to the Navigation Pane, accidental or otherwise. W
2
by: Mihail | last post by:
Hy ! I use following code to print out a report WITHOUT open it Private Sub cmdPrintReportRAM_Click() DoCmd.SelectObject acReport, "ReportName", True DoCmd.PrintOut acPrintAll, , , , , 1...
4
by: anewuser | last post by:
Hi, At the risk of repeating myself in other questions. I have a multi-user login screen which works using the following code: Option Compare Database Private Sub Login_Click()...
2
RockKandee
by: RockKandee | last post by:
I am using Access 2013 in Windows 8. The security features are gone (grumble, grumble). While I understand that those feature were not really security, they did have value. My goal is simply to...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.