Conditional Printing

[anoob]

I have a record set with a checkbox titled "Print_Invoice". I am trying to figure out how to make this a toggle switch.

I know how to create a button with a macro that prints an entire record set -

RunCommand > Print

but how would I take this macro and make it only print the records with the checkbox ticked? (I think it would be similar to Print_Invoice="1").

Any help appreciated!
Thanks.

P.S. - Just as an example, lets say these are my fields and I have 20 records.

[Print_Invoice][Invoice_Date][Due_Date][Business_Name][Mailing_Address][Phone][Website][Email]

[pbaldy]

I'd use VBA code, but you can continue with the macro. Use the where condition argument, which would look something like

Print_Invoice=-1

[anoob]

Thank you pbaldy - I'll stick with the macro... I just need this to work for myself, so I don't want to take shortcuts but... I dunno... I'll check this out - thanks.

[anoob]

Hmmm.... well, I am still printing every record for some reason. I added a condition, but maybe I am doing so incorrectly?

The Macro Looks Like This:

[CONDITION]                    [ACTION]                    [ARGUMENTS]
[Print_Invoice]=-1             RunCommand               Print

When the print dialog comes up, the option to print all is selected - this prints every record. If I try to use Print Selection, it only prints the 1, selected record.

Any idea what I'm doing wrong?

[pbaldy]

Sorry, I assumed you were using the OpenReport action. That action includes the where condition; it wouldn't be a Condition. Are you trying to print a report?

[anoob]

Oh - sorry it's my fault for being unclear.

Not trying to print a report - the setup is just 1 table and 1 form, I just want to print the "forms" that are checked, not the ones that are unchecked when I hit a print all button.

[pbaldy]

Personally I'd create a report and print that; you have a lot more control over the format and content of a report. Basically, forms are designed for user interaction, reports for presentation. Offhand, I don't know how to restrict a form to certain records when it's printed.

[anoob]

Ah I see... crap.
I haven't really got to reports yet...
But I guess now is as good a time as ever.

If you don't mind - can you walk me through it a bit?

I would start by creating a blank report, setting up my "styles" and such, and then would I have to define that it only "reports" or shows records with the "Print" checkbox set as true somehow? (Not sure how to do this part)

Then just print the report?

Thanks for all your help on this.

[anoob]

Nevermind - that worked like a flippin charm.
This really is a pretty neat program...

Thank you so much for the help!!

[pbaldy]

Glad you got it sorted out. I've been out getting sloshed at a charity wine tasting.

[anoob]

Good for you!
I'm drinking by myself... sad face...

[anoob]

Got one question though - when I click the button to run the report - can I change the [Invoice_Date] field across all records in my "SubscriptionServices" table?

So that way i don't have to update every record manually before i run the report.

Know what i mean?

[pbaldy]

I was lucky enough to be drinking with my blushing bride and some friends. I'm not really sure what you're after, as normally I wouldn't expect all dates to change, but this would update all dates to today:

CurrentDb.Execute "UPDATE SubscriptionServices SET [Invoice_Date] = Date()"

You could add " WHERE Print_Invoice = -" if you only wanted to update the ones being printed. If I've misunderstood, sorry, my brain probably isn't firing on all cylinders!

[anoob]

Congrats on the blushing bride.
My angry pregnant wife is asleep in the couch.

I'm being quiet...

[anoob]

Um... where might I add this tidbit?

CurrentDb.Execute "UPDATE SubscriptionServices SET [Invoice_Date] = Date()"

Or maybe, "how" is a better question.
Thank you for your patience...