Automatic Adding Record from prompt

  • Thread starter Thread starter KimTong via AccessMonster.com
  • Start date Start date
K

KimTong via AccessMonster.com

Hi,

I have a project to add a several records automatically from user's prompt.
The user has to input the range of field 'Ahhoc#' to add on 'Table1'
automatically. The prompt looks like this:
From: 10101
End : 10200

So the program will add 100 records on table1 and save 10101-10200 to field
'Adhoc#' in order. I have a logic like this:

For I=From to End
AddRecord
Adhoc#=I
Save it in table1
next

But I don't know to write exactly in VB. If anyone can help me, I'm really
appreciated.
 
Hi,

I have a project to add a several records automatically from user's prompt.
The user has to input the range of field 'Ahhoc#' to add on 'Table1'
automatically. The prompt looks like this:
From: 10101
End : 10200

So the program will add 100 records on table1 and save 10101-10200 to field
'Adhoc#' in order. I have a logic like this:

For I=From to End
AddRecord
Adhoc#=I
Save it in table1
next

But I don't know to write exactly in VB. If anyone can help me, I'm really
appreciated.
Click to expand...

look up .AddNew in the help. You can use either ADO or DAO...
 
Back
Top