troubleshooting Question

Access 2007: Autopopulating numbers

Avatar of ouestque
ouestqueFlag for United States of America asked on
Microsoft Access
2 Comments2 Solutions301 ViewsLast Modified:
I have a form where the user enters values in two textboxes then presses a button.

textbox1 is titled: "txt_NumberStart"
textbox2 is titled: "txt_NumberEnd"
textbox3 is titled: "txt_Increments"

What VBA code would I need when the user presses a button, it will take the number from "txt_NumberStart" and add the increments given in "txt_Increments" to that number until "txt_NumberEnd"

Example:

If the user enters 200 in "txt_NumberStart"
If the user enters 205 in "txt_NumberEnd"
If the user enters .5 in "txt_Increments"

Then the code will put the following data into a field titled "IncrementNum" in a table titled: "tbl_Numbers". I would prefer SQL if this is possible...

IncrementNum
200
200.5
201
201.5
202
202.5
203
203.5
204
204.5
205
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros