Search results

Hi, I have a report which is run from a query. when you run the report you are prompted for specific dates. I was wondering if there was a way of putting the dates you enter in the prompts into the report ? Hope this makes sense. Thanks in advance. L

Hi, I am trying to Link a table from Excel to Access which the rows contain both Numeric and Text values. However when I link it the fields come through as #NUM. I have tried formatting the cells in Excel to Text then running the below Macro Code, however some of the cells are formulas...

Hi, I have been given a large project, one stage is to import a spreadsheet which has 3 tabs (worksheets). I need to be able to create a query but based on all the information created in the 3 tabs. Does anyone know of a way of how to get the 3 tabs into 1 so I can create a single query...

Hi, I am trying to write a module which looks at a large text file and pulls out certain parts. I have written it in a way where I have declared a variable (file) and told it which line to look at (eg. If file Like "*Data*" Then Data1 = Trim(Right(Left(file, 10), 3))). However my problem is...