Search results

  1. D

    Printing out multiple values on the same line in a txt file

    Hi everyone, I have been developing a form in Access 2010 that has 3 text boxes: 1. Start number for example, 1001 2. Number of pages for example, 4 3. No of copies for example, 4 When the user then clicks on to the button, a txt file is created based on these 3 numbers. The first line...
  2. D

    Code to split CSV file fields and put in to a table

    Hello Everyone, I am trying to create a module in VBA within Access 2010 that when run, will open up a specific .csv file, and will split values up according to a spec I give (where to start, length of field etc) and put the information then in to an Access table. E.g. I have a file that...
  3. D

    Call VBA module to create spreadsheet along with SQL query to populate spreadsheet

    Hello everyone, My name is Dan. I have created a module in VBA that creates an Excel spreadsheet when executed (mdlExcelCreation). I have also created an SQL query, that selects records from a view (qrySpreadsheetData). I am at the stage now where I wish to combine the two, so that a...
Back
Top Bottom