Search results

Hopefully this explains it. I create a file on a certain day and i need the date that the file was created on to be the date recorded in access. My only problem is that initially I will be importing multiple files and i need to be able to enter those dates manually so that its correct (so that...

My understanding of Date() would be that it would only enter the date that you import the file. Now i'm importing these files after the fact (or at least some) as the files started before the report was completed hence the need for the ability to enter date (which [Enter Your Date Here] does...

Very close. My original plan was open database, run import which would ask me for the file location etc like normal and then there would be a macro there to append a date to the entries of that file once imported. I planned on using a temporary table for the import which after the append would...

Evening all, Now I will start off and say that I am very new to Access and i'm learning as I go along. And i'm sure that what I need to do is simple, I just can't figure it out so any help is appreciated. Essentially what I am trying to do is every time I import a file, I want access to ask me...

Hi. I am basically trying to make a Customer table, I am having a problem in so far as that when i click select customer (all the data shows as it should) I click on the customer data but then the data attached to this does not load in the Detail Section, where I have boxes for Name, Surname...