Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-08-2019, 10:36 AM   #1
NearImpossible
Newly Registered User
 
Join Date: Jul 2019
Posts: 62
Thanks: 47
Thanked 0 Times in 0 Posts
NearImpossible is on a distinguished road
Weird behavior

Today when I open a new database that I've been working on for about week, its acting weird.

When I open it, it launches the main page, but when click a button to open a new form, nothing on that forms works unless I open and close the VB editor.

After that, everything on the form works, until I close and reopen the database.

any thoughts?

NearImpossible is offline   Reply With Quote
Old 09-08-2019, 10:44 AM   #2
NearImpossible
Newly Registered User
 
Join Date: Jul 2019
Posts: 62
Thanks: 47
Thanked 0 Times in 0 Posts
NearImpossible is on a distinguished road
Re: Weird behavior

Don't know what happened but its working now.

Tried compact and repair several times with no luck. Made a copy of the database, no luck

Not wanting to have to start from scratch as there are about 100 lines of code on that form, I made a copy of the form to start digging into it line by line. Just for the heck of it, I clicked the button to launch the original form and it loaded correctly.

I've closed and reopened the database about 10 times and its working correctly.

Not sure how making a copy of a form fixed the original, but its working.....
NearImpossible is offline   Reply With Quote
Old 09-09-2019, 05:32 AM   #3
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 14,363
Thanks: 87
Thanked 1,644 Times in 1,526 Posts
The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold
Re: Weird behavior

The answer to the implied question is possible code corruption caused by a "ragged save" that didn't save everything correctly. In general, when editing things, you should be sure that you don't have anything else active in the background (like timers on a different open form). I know we sometimes take shortcuts in editing, but you should always save from an idle application. You should also always make a backup copy if you are going to do a Compact & Repair (C&R) after a long sequence of editing. And the C&R is probably not a bad idea if you are editing complex code or forms or reports, because editing objects like that tends to add "bloat" (wasted unreclaimed space) to your DB and the only way to do the reclamation is a C&R.

__________________
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.
The_Doc_Man is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Weird VBA behavior ASherbuck Modules & VBA 3 12-25-2011 06:11 PM
Weird SubForm behavior. marimo Forms 10 07-26-2007 01:49 PM
Weird field name behavior Cabong Tables 2 08-06-2005 08:23 AM
Weird field name behavior Cabong Tables 4 08-04-2005 09:47 PM
Weird Weird behavior fmm Modules & VBA 0 05-04-2001 06:34 AM




All times are GMT -8. The time now is 06:46 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World