Need counter to print

[miziri]

Hi,
I have table with one filed named number.
and I made form with two field,start and end type number .
i will put range from 232 to 900 into start and end,i want to copy all number between 232 to 900 inside table field number after press botton on that forms
see attached file database


Thanks
Salih

[khalid]

Dear Salih welcome to the forum!

First of all remember that field names should not be used as reserved words like number, text, currency etc. it will create errors while using in VBA coding etc.

you can use the following code to insert the value in your table range from 232 to 900 by clicking a button on your form:

create a button on your form and on button Click event property put the following code:

Private Sub Command1_Click()
Dim i As Long
i = 232
DoCmd.SetWarnings False
For i = 232 To 900
    DoCmd.RunSQL "INSERT INTO Table1 (number1) VALUES (" & i & ")"
    i = i + 1
Next i
DoCmd.SetWarnings True
End Sub

Regards,
Khalid Afridi