Using Dates as Criteria to Display Records in FORM

[Guest]

Employees who work on a Client File will enter the payroll information on a
continuous form linked to the Client Record. To edit employee information,
the employee record is accessed through the Client Record.

At the end of a pay period, I would like to have access to a list of all
employees who have worked during that pay period so I have designed a form to
display a list of part time employees, sorted by date worked, showing the
hours they worked. When I open the form, all of the records in the table are
displayed. I would like to display only those employees who have worked
within a particular pay period. How can I make that happen?


To access a REPORT that displays the identical information I need,
I set the criteria to…..

=[forms]![msgReportRange]![Between] And <=[forms]![msgReportRange]![And]

And then enter the begindate and enddate of the payroll period. But I
cannot edit the information in a report.

How can I open the newly designed FORM? Any thoughts?

R Marko

 

[tina]

the same way you did with a report. if you're opening the form from another
form (a switchboard or main menu, perhaps), then you can add controls to
that first form for the user to enter the start/end dates, and refer to
those form controls in the query underlying the second form.

hth

Employees who work on a Client File will enter the payroll information on a
continuous form linked to the Client Record. To edit employee information,
the employee record is accessed through the Client Record.

At the end of a pay period, I would like to have access to a list of all
employees who have worked during that pay period so I have designed a form to
display a list of part time employees, sorted by date worked, showing the
hours they worked. When I open the form, all of the records in the table are
displayed. I would like to display only those employees who have worked
within a particular pay period. How can I make that happen?


To access a REPORT that displays the identical information I need,
I set the criteria to...

=[forms]![msgReportRange]![Between] And <=[forms]![msgReportRange]![And]

And then enter the begindate and enddate of the payroll period. But I
cannot edit the information in a report.

How can I open the newly designed FORM? Any thoughts?

R Marko

 

[Guest]

Thank you for your response.

How can I do that? I already have a form that will request a begin and end
date. Where do I enter the criteria?

the same way you did with a report. if you're opening the form from another
form (a switchboard or main menu, perhaps), then you can add controls to
that first form for the user to enter the start/end dates, and refer to
those form controls in the query underlying the second form.

hth

Employees who work on a Client File will enter the payroll information on a
continuous form linked to the Client Record. To edit employee information,
the employee record is accessed through the Client Record.

At the end of a pay period, I would like to have access to a list of all
employees who have worked during that pay period so I have designed a form to
display a list of part time employees, sorted by date worked, showing the
hours they worked. When I open the form, all of the records in the table are
displayed. I would like to display only those employees who have worked
within a particular pay period. How can I make that happen?


To access a REPORT that displays the identical information I need,
I set the criteria to...

=[forms]![msgReportRange]![Between] And <=[forms]![msgReportRange]![And]

And then enter the begindate and enddate of the payroll period. But I
cannot edit the information in a report.

How can I open the newly designed FORM? Any thoughts?

R Marko

 

[tina]

in the query underlying the form.

hth

Thank you for your response.

How can I do that? I already have a form that will request a begin and end
date. Where do I enter the criteria?

the same way you did with a report. if you're opening the form from another
form (a switchboard or main menu, perhaps), then you can add controls to
that first form for the user to enter the start/end dates, and refer to
those form controls in the query underlying the second form.

hth

Employees who work on a Client File will enter the payroll information

on
a

continuous form linked to the Client Record. To edit employee information,
the employee record is accessed through the Client Record.

At the end of a pay period, I would like to have access to a list of all
employees who have worked during that pay period so I have designed a

form
to

display a list of part time employees, sorted by date worked, showing the
hours they worked. When I open the form, all of the records in the

table
are

displayed. I would like to display only those employees who have worked
within a particular pay period. How can I make that happen?


To access a REPORT that displays the identical information I need,
I set the criteria to...
=[forms]![msgReportRange]![Between] And <=[forms]![msgReportRange]![And]

And then enter the begindate and enddate of the payroll period. But I
cannot edit the information in a report.

How can I open the newly designed FORM? Any thoughts?

R Marko