Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: donnycarr
  • Content: Threads
  • Order by date
  1. donnycarr

    want to close queries after running macro

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

    how do I change 60 export destinations within a macro??

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

    reduce my query results to one line per cat

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

    User enters date, other dates are calculated.

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

    queries picking up and calculating dates

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

Part and Inventory Search

Back
Top