In thinking I needed to write the result directly to a table, I'm sure I'm making this much harder than it needs to be.
I will work with my controls and tables to see if I can achieve the same result without taking any more of your time.
Your help has been awesome. Thanks.
Axxe
Last Activity: Oct 25 '08, 04:42 PM
Joined: Oct 18 '08
Location:
-
This code works perfectly, except I can only cause it to increment a state by one digit.
Correct me if I just missed something, but I think this is because the output is not overwriting to an appropriate table.
It seems to me that I need to write or overwrite numeric output to the "[Start]" field of tblStateRange.
The text string that results from the operation -- Me!["txtRecNum"]...Leave a comment:
-
ADezii,
Thanks for helping me out. A quick review suggests to me that this code may be just what I need.
I'll study it closely and then see if I can make it work.
Thanks again.
Axxe.Leave a comment:
-
What I described above is the data pattern that has been in use for a very long time. I did not create the pattern. I just have to "make it work."
In addition to the state-specific identifier that I described, every individual record has a separate, unique identifier that, this year, began at 08-1001 and now is at 08-1699. That would be my candidate for a primary key, if I were to use it for that purpose. I prefer not...Leave a comment:
-
Programmatic sequential incrementation and data storage - access 2003
I have searched high and low for cogent, well-explained coding to complete a project on which I have spent six months of work.
I stumbled across something on this site that is close to what I seek, but, as is rather typical, I could understand neither the question nor the answer.
I am hopeful that someone in this forum can provide me with suitable guidance.
THE ISSUE
I am working in Access...
No activity results to display
Leave a comment: