Solved

Buttons fail on ACCDE

Posted on 2012-04-02
8
683 Views
Last Modified: 2012-04-02
Windows 7 32, Access 2007

I have an Access 2007 ACCDB that works fine.  The Trust Center settings in Access cover both the folder where the backend is (server) and where the front end is (local PC).  I create an ACCDE since I don't want users putzing with the application. Right now it is in the same folder as the ACCDB.

None of the buttons on the switchboard form work when I run the ACCDE.  Tabs work. Just the buttons fail.  I get no messages.  The button 'depresses' to show it was clicked but no new form opens.    

I have just discovered something.  If I open the ACCDE with the shift key held and I then do Alt-F11 to get into VBA there is no code available.

What am I missing?
0
Comment
Question by:IBMJunkman
  • 4
  • 3
8 Comments
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
Comment Utility
The reason the code is not available is because it is an ACCDE

Cannot say that I've run into a similar problem where code in an accde installed in a folder which is a trusted location will not run.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
Comment Utility
Is this an issue just with the switchboard buttons...?

...In other words, ...Will buttons on other forms work?

Before you created the accde file, did you compile your code and compact/repair the DB...?
0
 

Author Comment

by:IBMJunkman
Comment Utility
How to I compile the code?  I thought creating the ACCDE did that?

I opened a couple of other forms and their buttons don't work either.
0
 

Author Comment

by:IBMJunkman
Comment Utility
I just tried the ACCDE on Windows 7 64 Access 2010.  Still does not work.

Then I created the ACCDE with Access 2010.  Still does not work in Access 2010.  And understandably Access 2007 complains about the DB format.
0
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 250 total points
Comment Utility
<How to I compile the code?  I thought creating the ACCDE did that?>
Yeah, but why wait until you create the Accde file to find out if there are any errors?
;-)

In the VBE click : Debug-->Compile...

<Then I created the ACCDE with Access 2010.  Still does not work in Access 2010.  And understandably Access 2007 complains about the DB format.>
Let's be clear...
What "Format" is the DB in...

I thought you stated that this was an Access 2007 format DB...?
If so then you should create the accde file in Access 2007.
...just to see if it works...

In other words, *Before* you ever opened the DB in Access 2010, ...could you create an accde file form this accdb in Access 2007?


You also did not state if (or when) you were running the C&R utility...

Here is the sequence I would use, just to be sure...

Access 2003 running an Access 2003 format DB (.mdb):
Compile code-->Compact repair-->Create MDE file
Does MDE file work?
If, No, then stop and fix.
If yes, then continue....
Create new blank Access 2007 format DB (.accdb) in Access 2007
Import all objects from the mdb file into the new accdb file
Compact and Repair-->Compile code--> Compact and repair again-->Create accde file
Does accde file work?
If, No, then stop and fix.
If yes, then continue....
Create new blank Access 2010 format DB in Access 2010
Import all objects from the access 2007 format DB into the new Access 2010 format file
Compact and Repair-->Compile code--> Compact and repair again-->Create accde file
Does accde file work?
0
 

Author Comment

by:IBMJunkman
Comment Utility
In Access 2007 I just compiled the VB code.  Exited Access.  Opened the ACCDB and created the ACCDE. Closed Access and opened the ACCDE.  Now the buttons work.

I don't want a 2010 version.  The users have 2007.  The version I made my changes to was already 2007.  I was just playing around with 2010 trying to see what was wrong.
0
 

Author Closing Comment

by:IBMJunkman
Comment Utility
Compiling the VB code seemed to fix the problem.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
Comment Utility
Just note that "Playing" around with a 2007 format db in Access 2010 (and saving the changes) will sometimes cause the Access 2007 users to get the "Unrecognized format" error when trying to open the db, so be careful not to do anything "2010 specific" (navigation forms, ...et al)
see here for more info:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/thread/99e2eedf-0a36-4d38-9713-f3c82018c804
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now