Recent content by MaDoyle

Thanks for you help Mstef that works perfect Thanks

I'm attempting to do a running count on records in a query and reset the count starting again at 1 for each group of records displayed. Following are my fields and sample date. QualityRef - primary key AutoNumber Name- Product reference I do have other fields in the query, 4 in total but the...

i run a number of queries on the data once i have importted it .. is that not a way i can write some code to say if the file is like BranchName* then import the data, sorry im new to access so may be in a bit over my head

Thanks for you help the 2 filenames are Branch_Report - server4 6-17-08 6'08'10 AM Branch_Report - server2 6-17-08 5'15'10 AM

Sorry i may not have been clear its not that i can't access the folder where the files are saved its more that the nameing of each individual file changes on a daily basis and this is whats stoping me qutomating the import of the files

i hope some once can help We have 5 excel reports automatically saved overnight for us all the files are called Bch_report_inbopund (and then they have the time stamp and computer and and server number they have been run on added top the name field). i was using the file copy funtioon to copy...

I hope some can help I was wondering if it is possible to rename a file in excel using a module in access. I have a report populated on a daily basis and i want to rename the report and then move the report to a new location

sorry yes i still get the error when i try the other ways of importing the data

Yes, i have just been checking some other threads and people seem to have the problem when the tables is linked but my is just a nomal table

I hope someone can help I have the following code i am using to import a text file DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "TblInitialSalesData", "H\Retail Network\Public\0800Plan\Ops Team\4760\Branch_Report - 6-13-08 6'09'18 AM.txt", NO when i try to run the code i...

I hope someone can help as i am in over my head a little, the problem i am having is i have a txt file i am sent on a daily basis that has roughly 90,000 records in on a daily basis what i need to do is import this into a table. At the moment i have been manually running a mcro within excel...