I created a form called FrmDateRange. The form has two text boxes, 'fromdate' and 'todate'.
Then in my query criteria i've referenced this form and its text boxes in the following way.
Between [forms]![FrmDateRange].[FromDate] And [forms]![FrmDateRange].[ToDate]
Hope it sorts your date...
hi tim,
Might have a solution for your 1st issue. Try it out by putting this code in the click event behind a button - for example.
DoCmd.OutputTo acOutputQuery, "Name of your query", acFormatXLS, "C:\temp\" & [phone_number] & "_" & [employee] & "_" &...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.