?
Solved

MS Access 2003 - The Expression on click / on unload error

Posted on 2012-04-04
24
Medium Priority
?
386 Views
Last Modified: 2012-04-22
Hi,

I am getting above error while clicking on any button or closing any form.

I tried Compact and Repair. Importing all items in a new database.

It's  working fine in 2007.

PFA the screen shot.

Regards,
Sandesh
MS-Access-Error.jpg
0
Comment
Question by:Sandesh555
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 8
  • 4
  • +2
24 Comments
 
LVL 22

Expert Comment

by:Kelvin Sparks
ID: 37805255
THis usually means you have a code error/corruption or a reference is missing.

Toheck references, in any code module, goto menu tools>references. Look for any that are marked as missing. You must file the file (dll, ocx etc...) and select it and ernsure it shows as selected.

Then try an compile the database - Menu Debug>Compile


Kelvin
0
 

Author Comment

by:Sandesh555
ID: 37805277
Hi Kelvin,

All references are ok, how to find if there is any corruption.

Regards,
Sandesh
0
 
LVL 22

Expert Comment

by:Kelvin Sparks
ID: 37805282
Can you complie the database?

Kelvin
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 22

Expert Comment

by:Kelvin Sparks
ID: 37805283
Can you compile the database (typo above)
0
 
LVL 61

Expert Comment

by:mbizup
ID: 37805284
Has this database ever worked on Access 2003 systems, or is this a new problem?

Can you post a little more detail about what leads to this error - which forms/buttons/etc...

And if possible post a sample copy of your database.
0
 

Author Comment

by:Sandesh555
ID: 37805305
Hi,

Yes I can compile the database. Earlier it was working but suddenly started giving this error. It's giving this error on each event.
PFA the database.
Regards,
Sandesh
Expedite-V1.2.zip
0
 
LVL 77

Expert Comment

by:peter57r
ID: 37805313
You'll have to post a version that does not have a vba password.
0
 

Author Comment

by:Sandesh555
ID: 37805333
0
 
LVL 61

Accepted Solution

by:
mbizup earned 666 total points
ID: 37805341
I agree that there is some form of corruption in that database.

If you remove and then re-paste  (take them out and then put them back in  again) the on click, on load, or other events that are causing this error, you'll find that they will start wotking normally again.

I haven't tried this, but before going through all the effort of removing and restoring your code, you might try decompiling it.  See the instructions here - and make a backup first:

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_27661663.html
0
 
LVL 61

Expert Comment

by:mbizup
ID: 37805347
Also,  I don't know if this caused the problem or not, but since you are developing a database for users with different versions of Access, make sure that all of your development is done in the lowest version.

In other words, if you are mixing Access 2003 and Access 2007, all of your development should be done in Access 2003.
0
 
LVL 77

Assisted Solution

by:peter57r
peter57r earned 334 total points
ID: 37805349
There is some form of corruption which can be fixed using a decompile.
Use a copy of your database and execute the following command (adjusted for your own folder locations) from the Run dialog.

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "databasefolder\Rio Tinto - Expedite V1.2.mdb" /decompile
0
 
LVL 61

Expert Comment

by:mbizup
ID: 37805359
Sorry - I gave you the wrong link.  These are the decompile instructions I'd meant to post:

http://www.granite.ab.ca/access/decompile.htm
0
 
LVL 48

Expert Comment

by:Dale Fye
ID: 37805506
Giving credit where credit is due, you might want to try MX's solution and close Access, then reboot your computer.

Dale
0
 
LVL 61

Expert Comment

by:mbizup
ID: 37805577
Dale,

Did you download the DB and try that?  It doesn't work for me.

MX's rebooting idea clears phantom breakpoints, which looks to me like a different problem (this one is resolvable by cut/pasting the code, and I imagine by decompiling too).
0
 
LVL 48

Expert Comment

by:Dale Fye
ID: 37805601
Miriam,

No, cannot download while I'm at work.  I would concur that a decompile is in order.

But whenever I run into one of those situations that just doesn't make sense, where something I know should work isn't, I blame it on Windows and try rebooting.
0
 

Assisted Solution

by:Sandesh555
Sandesh555 earned 0 total points
ID: 37826890
Hi Team,

This MS access 2003 db is using MS Access 12.0 object library reference.

Is it causing problem? and how to change the reference from 12 to 11.
It says object in use while removing the reference and did not add 11 while 12 is already there.

Please suggest.

Regards,
Sandesh
0
 
LVL 22

Expert Comment

by:Kelvin Sparks
ID: 37826895
You have to make sure that no code is running. Start the database, holding down the shift key to ensure no autoexec macro runs. Then goto a VBA page (any one) and deselect the 12 version, then scroll down and find the 11 version. May pay to check it is installed first.


Kelvin
0
 

Author Comment

by:Sandesh555
ID: 37827000
Hi Kelvin,

I could not able to remove reference, as it says cant remove control or reference: in use.

Regards,
Sandesh
0
 
LVL 61

Assisted Solution

by:mbizup
mbizup earned 666 total points
ID: 37827197
Did you try cutting / pasting a block of code as suggested earlier?

This minor edit fixed the corruption for me in your sample.
0
 
LVL 61

Expert Comment

by:mbizup
ID: 37827213
(I did the edit on an Access 2003 machine,  btw )
0
 

Author Comment

by:Sandesh555
ID: 37855029
Thanks
0
 

Author Comment

by:Sandesh555
ID: 37855042
NA
0
 
LVL 61

Expert Comment

by:mbizup
ID: 37855052
Sandesh - are you having trouble with  EE's user interface?

Click the Request Attention button if you need a Moderator's help.
0
 

Author Closing Comment

by:Sandesh555
ID: 37877291
Thanks
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
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…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Suggested Courses

765 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