Somebody tell me WHY? looks good in preview but not in SNP?

  • Thread starter Thread starter TheNovice
  • Start date Start date
T

TheNovice

I have a form and the code behind it is such in laymens terms.

I push a button to email a SNP to a Salesperson. I OutPut to a file. I am
using Mr. Labens convert to PDF (which by the way works extremely well!!!)
and later exporting it via Outlook.

If I preview my reports, they look great! but as soon as I code it and send
it it is missing so much information (i.e. report header, Text etc.) and
never the same place, sometimes the whole report!

the code that I am using is pretty simple.

I am declaring the fields

DoCmd.OutputTo acOutputReport, stDocName, "Snapshot Format",
"c:\common\RecallB00.snp"

I am also telling it to:
rpt.visible = false

I know what your might be thinking, because i thought of the samething, its
the Labens Code. I wish it was something that simple, but Mr. Labens is only
converting what he gets and if the info is not there, So-Be-It! its not. I
have checked the SNP files and they are blank or missing info just as well.


Do I need to slow this thing down? I am down to my last two Tylenols and
really need you GURUS guidance.

Charles Davis
 
I use the following format to send a report by email. Substitute
rpt_names_all for the name of your report
Change All Names Report to the subject of your email etc.

DoCmd.SendObject acReport, "rpt_names_all", "SnapshotFormat(*.snp)", "", "",
"", "All Names Report", "", True, ""

Allan
 
Alan,

Thanks for the reply, I am not currently doing that for the customers that I
am sending this to do not have access, I also wanted to make it corporate
compliant and standardize it so that it goes out in a PDF Format. the
SendObject works great for internal projects. I just wanted to know if there
was a way to slow it down, if possible, and have it draw it slower when
printing.

any help is greatly appreciated.
 
Back
Top