Can I eliminate dialog message?

[Jan Il]

Hi all - Access 2002, WinME

I have created a report from a query that has From-To date period criteria
for text boxes on a filter form that opens the related form. However, every
time I want to open the report for preview, I get a dialog box that pops up
and asks for parameters for these two text boxes. Once I click ok for both
boxes, the report opens for preview. The part of the query SQL for the date
boxes is;

HAVING (((tblLaborCosts.JobDate) Between [Forms]![frmLaborFilter]![Text62]
And [Forms]![frmLaborFilter]![Text64])) OR
((([Forms]![frmLaborFilter]![Text62]) Is Null)) OR
((([Forms]![frmLaborFilter]![Text64]) Is Null));

Is there some way I can ignore the dialog message requesting the parameters
for the date boxes when the report is previewed? I've tried using the On
Open event in the report properties, but, so far nothing has worked. I
haven't used this kind of query for a report before, and I have not been
able to pinpoint a Help file on this.

Best regards,
Jan

 

[Rick Brandt]

Hi all - Access 2002, WinME

I have created a report from a query that has From-To date period criteria
for text boxes on a filter form that opens the related form. However, every
time I want to open the report for preview, I get a dialog box that pops up
and asks for parameters for these two text boxes. Once I click ok for both
boxes, the report opens for preview. The part of the query SQL for the date
boxes is;

HAVING (((tblLaborCosts.JobDate) Between [Forms]![frmLaborFilter]![Text62]
And [Forms]![frmLaborFilter]![Text64])) OR
((([Forms]![frmLaborFilter]![Text62]) Is Null)) OR
((([Forms]![frmLaborFilter]![Text64]) Is Null));

Is there some way I can ignore the dialog message requesting the parameters
for the date boxes when the report is previewed? I've tried using the On
Open event in the report properties, but, so far nothing has worked. I
haven't used this kind of query for a report before, and I have not been
able to pinpoint a Help file on this.

Generally if it is asking for those parameters it means it can't find those
controls. Is the form open? Are you sure you spelled the names of the controls
correctly?

 

[Jan Il]

Hi Rick!

Hi all - Access 2002, WinME

I have created a report from a query that has From-To date period criteria
for text boxes on a filter form that opens the related form. However, every
time I want to open the report for preview, I get a dialog box that pops up
and asks for parameters for these two text boxes. Once I click ok for both
boxes, the report opens for preview. The part of the query SQL for the date
boxes is;

HAVING (((tblLaborCosts.JobDate) Between [Forms]![frmLaborFilter]![Text62]
And [Forms]![frmLaborFilter]![Text64])) OR
((([Forms]![frmLaborFilter]![Text62]) Is Null)) OR
((([Forms]![frmLaborFilter]![Text64]) Is Null));

Is there some way I can ignore the dialog message requesting the parameters
for the date boxes when the report is previewed? I've tried using the On
Open event in the report properties, but, so far nothing has worked. I
haven't used this kind of query for a report before, and I have not been
able to pinpoint a Help file on this.

Generally if it is asking for those parameters it means it can't find those
controls. Is the form open? Are you sure you spelled the names of the controls
correctly?

Yes, the form is open, and the control names are correct. When I have a
From-To date period entered and displayed on the form the preview works
fine, no parameter request. However, if I don't need a date period and
there are no dates displayed in the date controls on the form, when I try to
preview the report then the parameter box comes up. Also, in the report,
when there's no date period displayed on the form, the error #Name shows up
in the date controls on the report form. I would like to have the date
controls to also be blank on the report if there's no date period in the
form date controls. If the form date controls are blank, then the date
controls of the report should also be blank.

Thank you for your time and help. I really appreciate it.

Best regards,
Jan