Auto Populate Empty Table

  • Thread starter Thread starter WPW07
  • Start date Start date
W

WPW07

Hello,

How would I auto populate an empty table with values 6000-10000. It
contains just one field [ID].

Thanks for your help.
 
This is an unusual thing to be doing. Why not create the records as you need
them?
In any case, you could use a routine like this:

Dim lngIdNumber As Long

For lngIdNumber = 6000 To 10000
strSQL = "INSERT INTO tblClient ( MainName )SELECT " & lngIdNumber &
" AS Dummy;"
CurrentDb.Execute strSQL, dbFailOnError
Next lngIdNumber
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Auto populating fields from another table 3
Auto update date in table - not form 9
Auto Populate dates 1
Auto Populate a Field on a Form based on Certain Criteria 1
Populate a Field 3
tables...somthing..somthing...god knows 2
Look up boxes 5

Back
Top