Quick data entry

[nhood42]

Without copy/pasting, how can I enter the same date in multiple rows(50-100 consecutive). Also multiple dates are in the same table.
Thanks

 

[informer]

Hi nhood42

With a VBA program but what do you mean by "enter"? Add or update records?

For adding records with the same date, call this code on click event button

sDate ="#07/25/2016#"
For i to 100
   sqlINSERT = "INSERT INTO tableName ( field) VALUES (" & sDate & ")"
   DoCmd.RunSQL = sqlINSERT 
next i

 

[sneuberg]

More like

Dim sDate As String
Dim i As Long
Dim sqlINSERT As String
sDate = "#7/25/2016#"
sqlINSERT = "INSERT INTO tableName ( field) VALUES (" & sDate & ")"
For i = 1 To 100
    DoCmd.RunSQL sqlINSERT
Next i