Adding print button in form query (1 Viewer)

Pinoycoderz · Jul 20, 2017

Hi I'm a newbie here and I hope someone can help me... I just want to add a print button in form_query. but everytime I print the header of the form will be printed also. I just want to print the result in search keyword.

Please see the attachment.

Frothingslosh · Jul 20, 2017

I would do the following:

Turn off form painting with Me.Painting = False
Hide the header with Me.FormHeader.Visible = False
Print the form
Restore the header with Me.FormHeader.Visible = True
Turn form painting back on with Me.Painting = True

RuralGuy · Jul 20, 2017

Create a report that does what you want rather than printing the Form which was not designed for printing.

Frothingslosh · Jul 20, 2017

You know, RG, every time I try to teach best practices instead of just answering the question asked, I wind up with a fight on my hands!

RuralGuy · Jul 20, 2017

Not with me I hope. I meant no disrespect Sir.

Frothingslosh · Jul 20, 2017

Nah, it's generally from the folks asking the question.

RuralGuy · Jul 20, 2017

I don't see it in this case. You just having a bad day?

Frothingslosh · Jul 20, 2017

I didn't say it happened here, I just said it's what usually happens when I try that.

RuralGuy · Jul 20, 2017

Got it. Happens to me as well and I simply quit assisting a recalcitrant poster.

Adding print button in form query (1 Viewer)

Pinoycoderz

New member

Attachments

Frothingslosh

Premier Pale Stale Ale

RuralGuy

AWF VIP

Frothingslosh

Premier Pale Stale Ale

RuralGuy

AWF VIP

Frothingslosh

Premier Pale Stale Ale

RuralGuy

AWF VIP

Frothingslosh

Premier Pale Stale Ale

RuralGuy

AWF VIP

Similar threads

Users who are viewing this thread