Search results

  1. M

    Running Count

    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...
  2. M

    Copying and moving files in excel using access

    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...
  3. M

    Update Excel File name using a Access Module

    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
  4. M

    Help With Importing Txt File

    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...
  5. M

    Running a excel macro from access

    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...
Back
Top Bottom