ouestque
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.