how to show an attachment in a form

[mana]

hello

i ahve a table with an attachment field in it
i want to show this attachment field in a form
this attachment is a picture (i want to have the exact picture in my form)
do you know how i can do this ?
thank you

 

[vbaInet]

Use the form wizard to create the form and it will use the appropriate control. It's called an Attachment control.

 

[mana]

hello

yes i know this
but in this way it is like an attached file
i want to have the attachment (that is saved) as a picture
do you know how it is possible?

 

[vbaInet]

Change the Picture Size Mode property of the control to Zoom.

 

[mana]

thank you
do you know how can i show each of rows of a datasheet in a pdf format?

 

[vbaInet]

I don't understand your question. Can you explain differently.

You want each record in separate pdf docs?

 

[mana]

I mean how is it possible to make this form like a PDF file?
I mean how to send this form to a PDF file
Thank you

 

[burrina]

Not sure what you mean by send! By email, to folder on hard drive? What?
Anyway, here are 2 examples:

DoCmd.OutputTo acOutputForm, "YourFormName", acFormatPDF, "C:\YourDir\OutputFile.PDF"

'Print Single Record on Form.
Dim myForm As Form
Dim PageNo As Integer
 
PageNo = Me.CurrentRecord
Set myForm = Screen.ActiveForm
 
DoCmd.SelectObject acForm, myForm.Name, True
DoCmd.PrintOut acPages, PageNo , PageNo , , 1
DoCmd.SelectObject acForm, myForm.Name, False

HTH

 

[mana]

helllo,

thank you very much
but is there a way to work with macro?
i mean to make the pdf file with macro?

 

[burrina]

Sorry, I rarely use Macros. As has been suggested, use the wizard to obtain your results.
Also search on here and Google it.
Good Luck!

 

[vbaInet]

* Create a report that's the same as the form
* Use the OutputTo command burrina mentioned to print the report to pdf. Don't print forms.