Printing Date Range of Forms

[NEC-2008]

Merry Christmas to All...
Is there any way to print forms in a date range...ie...

"Print frm_Accepted...
"Enter starting Date"
"Enter Ending Date"

Thanks in advance

 

[Jeff Boyce]

I'm missing something...

Forms don't, in my experience, come in a "date range".

More info, please...

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[John W. Vinson]

Merry Christmas to All...
Is there any way to print forms in a date range...ie...

"Print frm_Accepted...
"Enter starting Date"
"Enter Ending Date"

Thanks in advance

A form is a tool to display data from a Table (or Tables) on screen and allow
the table data to be edited.

It can be printed, but that's not typical and they're not really designed for
printing - Reports are better for that purpose.

And neither Forms nor Reports have date ranges; you can use a date range in a
Query by typing

BETWEEN [Enter starting date] AND [Enter ending date]

as a criterion on a date field, and then base a Report on the query.

 

[NEC-2008]

Hello to all. Sorry about the delay, but for some reason I couldn't log in
for 3 days...strange....

About my forms, they are A, B, & C.
B & C must be printed and turned in (as in physically handed to someone)
twice a month...ie...1st to the 15th and 16th thur the 30th, and ordered bo
another field on the form.

I don't have a problem printing one form, or printing the whole group of
forms, which may contain 4 months worth, just a specified date range,
ie...1st thru the 15th, or the 16 thru the 30th.

Is there any way to manipulate the print command to accept the specified
date range for printing. This range may contain 40, 50 or 100 forms, all
within this date range.

Thanks for the help.

Merry Christmas to All...
Is there any way to print forms in a date range...ie...

"Print frm_Accepted...
"Enter starting Date"
"Enter Ending Date"

Thanks in advance

A form is a tool to display data from a Table (or Tables) on screen and allow
the table data to be edited.

It can be printed, but that's not typical and they're not really designed for
printing - Reports are better for that purpose.

And neither Forms nor Reports have date ranges; you can use a date range in a
Query by typing

BETWEEN [Enter starting date] AND [Enter ending date]

as a criterion on a date field, and then base a Report on the query.

 

[John W. Vinson]

Hello to all. Sorry about the delay, but for some reason I couldn't log in
for 3 days...strange....

There have been some real problems with the web interface to the newsgroups.

About my forms, they are A, B, & C.
B & C must be printed and turned in (as in physically handed to someone)
twice a month...ie...1st to the 15th and 16th thur the 30th, and ordered bo
another field on the form.

Well... jargon alert. In Access a Form is an onscreen tool for viewing or
editing data in a Table. A Report is a tool for generating a printout. I think
that your paper forms should be generated by using an Access Report.

I don't have a problem printing one form, or printing the whole group of
forms, which may contain 4 months worth, just a specified date range,
ie...1st thru the 15th, or the 16 thru the 30th.

Then the Report needs to be based on a Query with a criterion selecting the
date.

Is there any way to manipulate the print command to accept the specified
date range for printing. This range may contain 40, 50 or 100 forms, all
within this date range.

There would be no "print command" involved - instead you'ld just open the
Report based on a parameter query; that can be done either in a way that
immediately prints, or in Preview mode so that you can look at the report
before choosing to print.

The nature of the Query depends on the nature of your data, which you have not
described. All I can really suggest is that you do three steps:

1. Create a little unbound (no recordsource) Form named frmCrit with (say) two
textboxes txtFrom and txtTo into which you can enter date criteria.

2. Create a Query based on your table, or tables, displaying whatever fields
you want on the printout and the date field. As a criterion on the datefield
put

= [Forms]![frmCrit]![txtStart] AND < DateAdd("d", 1, [Forms]![frmCrit]![txtTo])

The DateAdd will catch records where the datefield has a time component after
midnight on the chosen end date.

3. Create a Report based on the query - your "form".

You can put a command button on frmCrit to open the report - the command
button wizard will walk you through the process.