Add records with VBA
Hi,
Is it possible to add repetitive records with VBA.
I have a table tblTasks. The fields are Name, Age, Task, Date.
I need to code that enters the following information daily without manualy typing a new record.
Name = John.K
Age =35
Task =Create Reports
Current Date = Should get registered automatically.
The user should not update the above given fields manually. The code should be able to add new records by running a VBA code.The Current Date column should not be manually updated it should take todays date from the code.
Also there should be a date range option in the code where the user provides a date range for example 25-06-2007 to 29-06-2007. All the five records with approriate dates should get automatically populated in the table tblTasks.Help will be highly appreciated.
|
