Solved

Strange behavior in Access 2007

Posted on 2011-09-02
6
315 Views
Last Modified: 2012-05-12
I have an access application that is used in both Access 2000 and Access 2007, as most of the ones here at work are...

We are getting some strange behavior in one particular app that is just being built.  We Have some code that fires in the load event of a form...but it is not firing in Access 2007 until the form is closed...maybe even when it is unloaded.    I have tried it on two Office 2007 machines and it happens on both.

Head scratch...
0
Comment
Question by:snyperj
[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
6 Comments
 
LVL 61

Assisted Solution

by:mbizup
mbizup earned 100 total points
ID: 36473539
Can you post a sample illustrating this issue?
0
 

Author Comment

by:snyperj
ID: 36473667
I have just confirmed that the form load event is firing just before the form unload event, but only in Office 2007.  
It works fine in Office 2000.  ?  

I just found this link:
http://bytes.com/topic/access/answers/199175-load-event-active-form-fires-when-access-closes

Nice to know I am not going crazy.  This is the same exact problem.  
0
 

Author Comment

by:snyperj
ID: 36473702
Unfortunately (for me) the steps to reproduce, don't reproduce it.  Attached is the db I made following the instructions in the article... but it doesn't happen in this db in either Office 2000 or 2007...   grrr.

...but it is happening with mine. At least I can look into the hidden form issue as the cause and see if I can work around it.  It's odd, because I have used hidden forms, etc in other apps without this occurring... so there must be some other missing link to the problem.
test-db1.mdb
0
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 400 total points
ID: 36473868
Seems to work fine for me?

Are you compiling your code on a regular basis?
Are you running the compact/repair utility on a regular basis?

Do all machines all have the same libraries loaded in the VBE?

Note that your DB is in the 2003 format, ...so not all things may be available when the DB is opened by the Access 2000 users.

Try saving/converting a copy of this DB in the 2000 format...
Then compile the code, then run the C&R utility, ...
...then test for this issue.

Remember that Access development recommends that you develop the DB in the lowest format that the users will be using.

So if the lowest version your users will be using is 2000 then *Convert* the DB to the 200 version.
And *Only* make design changes to the DB in Access 2000.

JeffCoachman
0
 

Author Closing Comment

by:snyperj
ID: 36474048
Thanks for the tips.  I tracked my problem down to something entirely different as the culprit.  I have a subform on this form in detail section and I was hiding / unhiding the detail section in sections of the form code instead of hiding / unhiding the subform control itself.  Once I made the change, it works fine.  Not sure what is related to what in this case... but moving on...
0
 
LVL 42

Expert Comment

by:dqmq
ID: 36474272
I cannot reproduce the problem either and concur with Jeff.   Suspect it's an issue with mixed versions.  Using 2003 format from a 2000 executable is without a doubt questionable.  
0

Featured Post

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

717 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