[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Variables suddenly lose their set values

Posted on 2011-09-16
12
Medium Priority
?
323 Views
Last Modified: 2012-05-12
Why would variables suddenly lose their values when  form loads?  I have a variable that I set to 'true' when the form loads... and I check it at different stages using a message box.  It remains 'true' all the way through the code.   The variable is then used in the after_update of a textbox... when I put a value in the textbox, the variable is gone... somehow it is getting wiped and I can't figure out why...  other ones (global) that are either set on previous forms also disappear.   This was all working up until yesterday...so it has to be something I did yesterday, but I am at a loss as to what it could be.

Are there any certain things I should check that might cause variables to lose their values suddenly?


Thanks
0
Comment
Question by:snyperj
  • 5
  • 5
  • 2
12 Comments
 
LVL 61

Expert Comment

by:mbizup
ID: 36550411
Did you add a "Stop" statement anywhere in your code recently?  That causes all globals to be lost.
0
 
LVL 75
ID: 36550503
Actually, Stop does not clear variables:

From Help:
"The Stop statement suspends execution, but unlike End, it doesn't close any files or clear variables, unless it is in a compiled executable (.exe) file."

Where are this Globals located?  In a vba module? Form module?

mx
0
 
LVL 75
ID: 36550514
Also ... does you code compile?

Are any errors occurring ... and then End is being hit?  End will clear variables.

mx
0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 

Author Comment

by:snyperj
ID: 36550526
No stop  and the globals are in a vba module.

The code does compile.
0
 
LVL 75
ID: 36550592
Can you single step through the code .. .from the point where the variable is set ... to where it's gone?

mx
0
 
LVL 61

Assisted Solution

by:mbizup
mbizup earned 800 total points
ID: 36550593
Do you have any code that deals with forms in design view?

That *might* affect your globals..

Just hazarding some wild guesses here, but we may be able to come up with something more concrete if you post your database (with any sensitive data masked or removed, please :) )
0
 

Author Comment

by:snyperj
ID: 36550621
I would post it but the .mdb is only a front end, the entire be is SQL.
0
 

Author Comment

by:snyperj
ID: 36550631
I'll find it... it will just probably take all day to back track and slowly remove yesterdays work until it is working again. groan.. is it 5pm yet?
0
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 1200 total points
ID: 36550640
You already have this right

http://www.rickworld.com/products.html#Find%20and%20Replace%209.0

?

If not, get it ... and then search for all occurrences of that variable ...

mx
0
 

Author Comment

by:snyperj
ID: 36550667
Thanks, I'll get it because I am sure it is helpful...but in this case it is all variables that were previously set that are getting wiped..
0
 
LVL 75
ID: 36550685
"I am sure it is helpful.."
I promise ... more than you can know :-)

mx
0
 

Author Closing Comment

by:snyperj
ID: 36561702
Thanks
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

834 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