Print Between Start Date and End Date...

G

Guest

Can I print a FORM created from a table (not from a query) which has a
certain period of dates entered in the field [SHPdate] ?

On the page Header, I want to show automatically when the report is printed :
Between (the Start Date of the [SHPdate]) And (the End date of the
[SHPdate])?

I do not know what is the Start date of the SHPdate and the End date of the
SHPdate entered in the field.

I appreciate if anybody can help please.

thanks
Karen
 
J

John W. Vinson

Can I print a FORM created from a table (not from a query) which has a
certain period of dates entered in the field [SHPdate] ?

No. Forms are not designed for printing; Reports are.
On the page Header, I want to show automatically when the report is printed :
Between (the Start Date of the [SHPdate]) And (the End date of the
[SHPdate])?

I do not know what is the Start date of the SHPdate and the End date of the
SHPdate entered in the field.

Use a Report object rather than a Form object, and put textboxes in the report
header with control sources like

=[Forms]![NameOfYourForm]![StartDate]

referencing controls (presumably unbound controls) on your Form; base the
report on a query using the same syntax as criteria.

John W. Vinson [MVP]
 
G

Guest

Got it, Thank You!

John W. Vinson said:
Can I print a FORM created from a table (not from a query) which has a
certain period of dates entered in the field [SHPdate] ?

No. Forms are not designed for printing; Reports are.
On the page Header, I want to show automatically when the report is printed :
Between (the Start Date of the [SHPdate]) And (the End date of the
[SHPdate])?

I do not know what is the Start date of the SHPdate and the End date of the
SHPdate entered in the field.

Use a Report object rather than a Form object, and put textboxes in the report
header with control sources like

=[Forms]![NameOfYourForm]![StartDate]

referencing controls (presumably unbound controls) on your Form; base the
report on a query using the same syntax as criteria.

John W. Vinson [MVP]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top