I'm very new to access - so please bare with me here (I'm more of an excel guy)
I have a database with a form. When you click the button on the form, it opens an input box which asks you to "enter the date in YYYYMMDD format"
Once you enter 07012009 it looks up a text file in a specific folder with that same end trail, then imports it with specific delimited specs I have pre-set.
It then imports all the records into it new individual table (using the end date trail) but also dumps it into a master table as well.
Okay - so knowing this - heres my quesiton:
How do can I get the input box "YYYYMMDD" into the column called "Date imported" within the master table and formated as "MM/DD/YYYY". Also, how can I get it to automatically put the text "IMPORT FILE" in the column called "Media" for each record?
It's VERY important that it only does this for the imported records. Is this possible?
Here is the code I have so far:
Also - everything I have works so far, I just need to add the features I said above.Please Login or Register to view this content.
Thanks!!
Bookmarks