Parameter window askes for start date and end date

[Emma]

Hello I created al form which opens when a button is pressed. The form comes
up with a pop up for the user to enter the start date and the end date. Is
there anyway I can enter the start date and end date automatically as they
never change and I don't want the user entering these dates. I just want the
form to open without the user having to enter any dates

 

[pietlinden]

Hello I created al form which opens when a button is pressed. The form comes
up with a pop up for the user to enter the start date and the end date. Is
there anyway I can enter the start date and end date automatically as they
never change and I don't want the user entering these dates. I just want the
form to open without the user having to enter any dates

Is your form based on a parameter query?
hard code the dates into the query if they never change.

 

[Emma]

Can you explain to me how to hard code the dates into the query?

 

[John W. Vinson/MVP]

Can you explain to me how to hard code the dates into the query?

Replace the parameters - which probably look like

[Enter start date]

or the like - with the actual date, in mm/dd/yyyy format delimited
with # marks:

#01/01/2007# or #12/31/2007#