Search results

Thanks, do you know if I have to put any reference to the query which the prompts are in. My query has prompts called [Start Date] and [End Date]. So in my report I have added a field called =[Start Date] and another called =[End Date] Is this correct ? Sorry, I am very new to access.

Hi, Thanks for your reply, however when I enter this into my report and run it, I am prompted for dates, but the dates I enter do not show on the actual report ?? Any Ideas ?

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

Thanks for your reply. The paste special would be the best way to do it, however my boss has set me this task which is to link in 10 spreadsheets to Access so he can report on them, therefore he does not want any manual work at all. These linked tables need to be changed every month and I...

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

Thanks, I work with Business Objects and believe a union query would work better. However I dont seem to have this option in Query. I am running Access 2003. Can you advise where I can make this query ? Thanks

Hi, Thought I would post a reply as managed to do this by linking the 3 tabs seperately and creating a Make Table query on one and an append query on the other 2. Thanks

The 3 tabs hold Account Numbers, Dates, Time and Quantity. Therefore these are all variable and never the same for all 3 tabs. Would it be easier to create a macro in excel first which creates a 4th tab amalgamating the other 3 ? Thanks

Thanks, I thought with linking tables you can still only import one tab at a time ? and although all the tabs hold the same information there is no common link between them to build a query using the 3 seperate tables. Thanks in advance for your help.

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

Thanks for your response. I will try this, however its not just one line that contains the word "data". So how do I tell the module to keep looking and return every line which contains it ?! I thought about declaring variables as i = 1 and j = 1 to 32 Then saing looking for Data(i) Loop...

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