Link to home
Start Free TrialLog in
Avatar of ouestque
ouestqueFlag for United States of America

asked on

Access 2007: Autopopulating numbers

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
SOLUTION
Avatar of Anthony Berenguel
Anthony Berenguel
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial