Save a Report to An Attachment field via Button? (1 Viewer)

[galvinjaf]

What am I placing in as the attachment field name if the field is simply a paperclip?

Also, for pkvalue, I'm not sure what I place in this spot. I'm searching a numeric value on my tblEmployee?

 

[arnelgp]

paperclip is just visual representation of your attachment (if there is one). you can change it in design view of your form->property->format->display as->image/icon.

 

[galvinjaf]

So I fixed the module code, and button click event code. I get an error saying that it cannot find the "ID" field referred to in my expression.

Is this because I'm running a report based off of my form and the ID is in the Form and not Report?

 

[arnelgp]

are you doing this on a report?
sorry but i don't do any coding for report.
report is for report for paper and screen only. leave it for its purpose.
if you need interaction do it in form not in report.

 

[galvinjaf]

I've attached a stripped version of my database. The form that my input is in is frmEmployee > then Equipment tab > then print agreement > then the Sign&Save button

Operator initials are Bob. Any ideas?

 

[galvinjaf]

I hear you. Okay, let me take a different approach and see if I can figure out another way to accomplish what I'm doing with a report.

 

[arnelgp]

here try this.

 

[galvinjaf]

This works exactly as I had intended. I manually typed out the code, in the correct places to get some practice. While I may not understand the code, per se, I understand what it is suppose to do. Thank you. I am very much appreciative!