Hi All.
I am working in Access 2003. I am importing a text file (import.txt) and saving specifications.
Once I get the txt file imported, I run the following queries:

1. cRQs in N,A,P Status (Yr End) 1 CONVERT dates (within the txt file)
Converts the text dates to mm/dd/yyyy
2. cRQs in N,A,P Status (Yr End) 2 APPEND
Appends the converted dates text file to the main table
I had to add another field to the main table to hold the dept names.
I also have the main table so that once the dates are converted I can change it from a text to a date filed.
3. cRQs in N,A,P Status (Yr End) 3 ADD depts.
Updates the added filed with the department names which are based off of certain characters in an ID field.
This is a reoccurring function.

What I want to happen is the following:
When the database opens
1. Delete old data in all main tables being used.
2. Import all txt files using proper specifications.
3. Convert date field within txt file.
4. Append to main tables.
5. Add depts.
6. I want this to happen as soon as the databases main form is opened.
7. Within these processes, not have to have the user select Yes to proceed with any query actions.

Cant this all be put in a code? I want to make this program less user interaction (user friendly) as possible. Am I asking for too much???
Can someone give me some suggestions please?
Thanks to all!!!

Thanks, I'll try it and let you know how it turns out.
Thanks for the insight to use VB help vs Access.