Recent content by donnycarr

Thanks for that advice.. I tried everything you suggested. For some reason it doesn't want to pick up the dates I have entered into the text boxes on the form. All my references appear to be correct. My query criteria reads: [forms]![date]![tb1] 'date' being the name of my form and 'tb1' being...

I have TRIED to set up a form with various text boxes. I just want to type in a date into these boxes (about 6 of them) I then want my queries to refer to these so they can select, 'Between this date and that date". Every time I run the queires they ask me to input the date again, but they...

Thanks, Problem is, I've never used VBA before and its a bit intimidating when you open it up. I think I'll have to stick to the macros for now. Cheers.

I have set up a macro to run several queries. It runs them and exports to Excel..but leaves them open, you then have to close them all down. Is there a way that the macros can run the queries without opening them in datasheet view OR close them down after running and exporting them? Any hints...

I have about 60 queries within 2 macros. I now need to change the export from one shared drive on our network to another. Is there a quick way of doing this rather than going into every TransferSpreadsheet 'Action' and changing the destination file name for every one. It would be great it the...

I have the following columns resulting from a query. Cat Litres LOW ALCOHOL 2.310000092 LOW ALCOHOL 6.820000112 LOW ALCOHOL 8.910000116 PREMIUM 110671.6946 PREMIUM 131329.5967 PREMIUM 138779.0585 I only want one line with LOW ALCOHOL and for the litres column to...

I have created a text box on the form, formatted to Date/Time and with an Input Mask where the user inputs a certain date). I now want to create some "boxes??" next to this with calculations to work out a date 4, 12 and 52 weeks previous to the date entered by the user. I will then...

Thanks Astrid that has worked. However, its gets more complicated. I now need to run a query to select records for the same 4 week period the previous year. Still using the date entered by the user as a guide. I was thinking I might be able to create some forms which could calculate all these...

I have set up 12 or so queries. Within these are some date criteria whereby the query picks up a date from a form ( through a text box on the form, formatted to Date/Time and with an Input Mask where the user inputs a certain date). I now want the query to work out the 4 week period before this...