DataBase Help

[Travis33]

I have a database with one table and one form. I am building it to test the search feature when you have 20,000+
records. I have five fields(auto number,number,date,time,string) I have a command button that I want to be able to click and it writes 20 new records to the table. I want them to be auto generated so i don't have to type anything in. Can someone please help me. Thank You Travis

 

[braindead2]

you could do all 20,000 at once instead of having to hit the button 1000 times but heres the code to do 20 records at a time

place this code in the buttons on click event

dim rst as recordset,T as interger
set rst = me.recordsetclone
for t = 1 to 20 'Replace 20 with 20,000 to do it all at once
rst.addnew
rst!number = t
rst!date = Date()
rst!time = Now()
rst!string = "record" & t
rst.update
next
rst.close

 

[JerryDennison]

Please don't post the same question in multiple forums.

 

[Travis33]

Thank You so much braindead2 it worked great

Travis