We help IT Professionals succeed at work.

opening form

urjudo
urjudo used Ask the Experts™
on
Hi Experts,
I have a Access DB in 2007 version (32bit) and I convert to 2016 access(64bit).  I have a login page, user enter the user name and password, then open a form with few buttons (one of these button is open an entry form name "Add/update Case"), this button was working fine in the old version, however, after I converted to 2016 version, when I click this button to open the form,  once the "add/update case" form opens, it circling for about three to four seconds, it close the whole database then make a backup of it.  I checked all the coding and nothing get change.  I can figure it out why.  any help will be very appreciate.

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Dale FyeOwner, Dev-Soln LLC
Most Valuable Expert 2014
Top Expert 2010

Commented:
Have you attempted to compile the database after migrating it to Access 2016?  You may have missing references or other issues.

Dale

Author

Commented:
@Dale,
I did compile and check the references.
Owner, Dev-Soln LLC
Most Valuable Expert 2014
Top Expert 2010
Commented:
is this a .accde file or .accdb?

if it is a .accde, that behaviour would be normal when an unhandled error is encountered.

if it is a .accdb file, open the applicaition in design view.

then open the form (the add/update case form) in design view.

Check to see if there is any code behind the form.  If so, add a breakpoint to the Open, Load, or Current events if any of those have code in them.  then right click on the form and select "Form View".  Does it open and run properly?  If not, then the form may be corrupt.  If you have a backup copy of the database, see if you can import an older copy of this form.

Then go back to the form which contains the button and put a break point in the code that fires when you click that button, change it to Form view and click the button, trace the code with F8 so that you can determine where the problem is occuring which is causing Access to crash.

Dale

Author

Commented:
Thank you!
Dale FyeOwner, Dev-Soln LLC
Most Valuable Expert 2014
Top Expert 2010

Commented:
Glad to help.

So, what worked?

Author

Commented:
There was a problem with a calculation field in that form.

Thanks!