Adding print button in form query

Pinoycoderz

New member
Local time
Today, 13:35
Joined
Jul 20, 2017
Messages
1
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.
 

Attachments

  • Capture.PNG
    Capture.PNG
    12.5 KB · Views: 81
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
 
Create a report that does what you want rather than printing the Form which was not designed for printing.
 
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! :(
 
Not with me I hope. I meant no disrespect Sir.
 
Nah, it's generally from the folks asking the question.
 
I don't see it in this case. You just having a bad day?
 
I didn't say it happened here, I just said it's what usually happens when I try that. :p
 
Got it. Happens to me as well and I simply quit assisting a recalcitrant poster.
 

Users who are viewing this thread

Back
Top Bottom