opening form
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
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
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Have you attempted to compile the database after migrating it to Access 2016? You may have missing references or other issues.
Dale
Dale
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
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
Premium Content
You need an Expert Office subscription to comment.Start Free Trial