Search results

Tried manking those amendments. I changed the name of the form to 'fill'. I changed the format of the text box to 'Short Date' as there was no option for 'date/time' and I left the form open. Still not coming up with anything.. ...Donny

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 managed to… ”set up the unbound text boxes on your form, formatted to Date/Time and with an Input Mask: 99/99/0000;0;_ Then reference these two fields in your criteria row within each query: Forms!frmMyFormName!txtStartDate” However there are 2 more things. I want the query to select...

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

I have a similar problem, I am trying to run several queries using a macro within M/Access. I then want the results of these queries to be exported to an excel file. It just won't work. I think I am using the wrong instructions in the Macro design but I've tried every option. Any help and advice...