Command Button: Print for Grouped Reports

[alyon]

I know how to program a command button to print a single record:
DoCmd.OpenReport "[Report]", acPreview, , "[ID] = " & Me.[ID]
DoCmd.PrintOut
DoCmd.Close acReport, "[Report]"

I also have created a command button to print one person's multiple records:
DoCmd.OpenReport "[Report]", acPreview, , "[name] = " & Me.[txtname]
DoCmd.PrintOut
DoCmd.Close acReport, "[Report]"

...I'm stating what I already know, to clarify what I've already tried..
But I have a mileage log report based off one form and one table that is grouped to print by months, I need to know how to create code for a command button, that allow's you to pick the month, and print only that current/monthly record. The idea of the 'name' above won't work because they don't have something in common, except the month in the date textbox, but there's also the day and year in the same textbox... and they will not be happy if they have to have a seperate textbox for month, day, and year. :/ Any help would be greatly appreciated!

Thank You in Advance,
A. Lyon

[pbaldy]

Along the lines of:

DoCmd.OpenReport "[Report]", acPreview, , "Month([DateField]) = " & Month(Me.[TextboxName])

Perhaps also adding a criteria for year.

By the way, if you drop the acPreview the report will print to the default printer, eliminating the need for the other 2 lines.

[alyon]

Hahaha, I had forgot I made this post, still hadn't got it working, and stumbled upon my post and your reply today! Works perfect! Thank you so much. And if it's not too much trouble, could you tell me how to add the year in? Please and thank you!

[pbaldy]

Try

DoCmd.OpenReport "[Report]", acPreview, , "Month([DateField]) = " & Month(Me.[TextboxName]) & " AND Year([DateField]) = " & Year(Me.[TextboxName])

[alyon]

Works Perfect. :] Sooo, can I maybe get your help with one more part of this?
I have a report to print monthly, for which the code above is PERFECT.
However, I also have a report that needs to be printed every two weeks..... suggestions?

[pbaldy]

I would probably use Between with 2 dates. You can probably find formulas here to calculate the dates, depending on how they're determined:

A plethora of date functions