Search results

Hi Trevor, Thanks for your response, I have set up other queries to output to an excel spreadsheet in the same mannor as your last post, they work fine, but it doesn't work with the method in your post of 14 Dec 12, 06:56. I have tried it and the error message I posted gets generated. I...

Good day Trevor, Having followed your instructions to open the 15 queries with the same date range criteria, I’ve been trying to work out how to then export the contents of each of those queries into the same excel spreadsheet, each occupying their own tab. The problem I am coming across is...

Hi Trevor, That works a treat, I'm now moving onto my next bit of my process, so I may ask some more questions depending on whether or not I run into difficulties. Cheers John

Hi Trevor, Thanks very much for your response and excellent explanation. In all the years of been using Access I never knew about the ability to use the wizard in the criteria of a query. Goes to show there's is no much still to learn. Thanks once again and I'll let you know how I get on...

Hi Trevor, Thanks for your reply, I'm not familiar with the Search Form Date Parameter in a query, I note your using a later version of Access than I am, I'm useing Access 2000, so is that a new feature in later version. Regards John

Good afternoon, Is it possible to pass a date range criteria to upto 15 queries from one input in one instance. What I would like to do is using a form as the front end is enter a start date and an end date that would be passed to mulitiply queries that will then run consecutively using that...

Hi, It's very difficult to help you because your data is ambiguous, you have 5 instances of John,1 instance for teh 21st clocking out 3 instances for the 22nd 1 clocking in and 2 clocking out and one instance on the 23rd clocking out. So is this John the same person through out? If this...

Hi, I keep getting the following message despite having checked that the object does exist and it is spelt correctly, does anyone know why this keeps happening and of any fixes for this: "The microsoft Jet Database engine could not find the object '01_Q'. Make sure the object exists and...

Hi, Further to my last post, attached is the resulting spreadsheet with all the various tabs, I have been able to get the first tab formatted, I'm really struggleing to get the remainder of the tabs formatted, in my last post the first code block showed the code for formatting which came...

Hi, I've been trying a number of ways with the existing code to try and create additional tabs in the excel file and format them from access with no luck. So I'm trying another approach in which I have been able to achieve getting all my desired data into the various individual tabs within...

Hi ByteMyzer, I tried your suggested code, but unfortunately my DB didn't like it, however with a littly playing around and using your code sample as a base, I've come up with this code below which works in that it creates a new worksheet and names it as required, however I now need...

Hi ByteMyzer, Thanks for your reponse, I'll give that a go and let you know how I get on. Regards John

Good afternoon folks, I'm hoping someone can help me as I'm stuck on how to write code to create additional worksheets within an Active workbook. Below is the code I've produced with the help of this forum and the code works fine, but I want to be able to add in additional worksheets to the...

Good day rodrigcz, In response to Question 1) to make certain fields required you will need to do that at the table level. In the design view of the table select the field you want to be required and set that fields required property to Yes. In response to Question 2) without knowing the...

Hi, If I'm reading your post correctly you've answered your own question, in the criteria row of your query beneath the field that contains that information enter Not Like "0". any values that are equal to zero 0 will not be included. Regards John

Hi Paul, Thanks for your response, I go down the route of your suggestion then, sounds like a good option. Regards John

Hi, I've done a search on this site but been unable to find anything on the subject of changing the colour of the Text in a MsgBox. Does anyone know if it is possible to change the colour of the text in a message box and if so how it might be achieved. Many Thanks John

Good day folks, I am using Access 2000 and I import fixed width text files on a dialy basis, however for sometime now whenever this data contains the pound symbol "£" the line of data within the text file that has the pound symbol in it, it changes it to this "┬ú" and this in turn pushes the...

Good afternoon Folks, I'm hoping someone might be able to assist here. I have a database that I have created that imports fixed width text files on a daily basis, which are produced by a scanning system. I have an import specification for the text files and code that uses that import...

Hi, Yes, I thought that was what was wanted, to not allow the user to see it, access it and only exit the form via the button created. Perhaps I mis-understood. Regards John