Recent content by dwinn86

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

Hi James, I am still a little confused as to what I am doing...would you mind explaining this a bit more please? Thanks, Dan

Hi James, Thank you for your very quick response. Ok then, I will try that and see how it goes. Thank you :-) Dan

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

Hi Guus, Thank you very much. Sorry I have explained it wrong. I have a view that selects data from a database depending on the CentreNumber. So the 48 views can be created from this query by running the query with a different CentreCode each time. Do you understand what I mean? I...

Hello Guus, Thank you very much for getting back to me and thank you for that :-) Is it possible to take this further and put a loop in so that when it runs, it can go through 48 tables that I have got and produce individual spreadsheets for these tables. Each table you see is for a...

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