Printing & Sending

[matthewnsarah07]

2 Quick questions, which I hope with have easy answers

I have a Holiday Request form on Access which basically looks like an old paper version our business use to use. I have replicated the format on he access form but I have two questions:

1) The form only prints properly in Landscape, but access always switches to portrait. How do I set it up so where ever someone use this form, if they press the print button it always prints as Landscape

2) I use to have this form on MS Infopath, but there were some technology issue with it, when you email an infopath form the recipient receive an attachment which when opended displays the form as it appears to the user.

Is there a way to email an access form whereby the recipient actually receives a copy of the form as it appears, rather than just the info in the fields?


Thanks for your help

 

[GaryPanic]

the print setting on the report itself should allow this.

 

[matthewnsarah07]

Thanks for your reply

Has anyone got the answer to sending a form as it appears, rather than as just the data or is the solution to convert it into a report prior to sending?

 

[GaryPanic]

pdf the report-form itself - whiel this is a relatively simple process - ie download a pdf printer preview .

making it smooth - ie pdf report straight out .. thats a little bit more tricky and you are going to need someone with more brains than me (which won't be hard to find -lol)

my take on this would be -

get the pdf to output to a set folder for ease lets say c//temp (i know the switches are wrong - dodge keyboard)

now have your report pdf output to this directory and call it reportx or whatever - now it is realtively easy to attach to an email -

i have a xls report that i push 1 button and it outputs to c//temp as test.xls and push another button and the .xls is attached to an email - and the email address is in my controlling form ..(so 1 button to create xls. one to attached to email and then send from outlook)

the hard part is the output to pdf automactically -as it will have to overwrite the existing report all the time - unless you get a bit fancy with your coding then you could output the pdf with a name that is registerd to your form/table then have outlook look it up and attach it ...

 

[GaryPanic]

ps.. a macro might do this for you - ie select a printer -pdf run and save as etc....