Search results

I have many queries that 'should' pick up dates from a form. For some reason they don'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'...

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

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

I have set up a macro to run several queries. Within the queries are dates which are used in the selection of entries from the database. EG. “Select the entries between this date and that date” Is it possible to create a switchboard ‘button?’ whereby a user could enter a date into a field and...