access vba - DoCmd.OutputTo acOutputReport and OpenArgs Workaround -
access vba - DoCmd.OutputTo acOutputReport and OpenArgs Workaround -
i have study used study yields 0 records. reports title tells process had 0 records.
strnorecordopenarg global veriable
main form code **
strnorecordopenarg = "imported ael's" docmd.outputto acoutputreport, "rpt_universal_no_records", acformatpdf, "c:\reports\imported ael's.pdf" strnorecordopenarg = ""
report code **
private sub report_open(cancel integer) .txt_header_title.controlsource = "=""" & strnorecordopenarg & """" end sub
what happens process completes no study generated.
if rem out study code works study title #name.
i utilize immediate window , value of strnorecordopenarg holding , should available open study process.
all of automate process. if utilize
docmd.openreport "rpt_universal_no_records", , "", "", acwindownormal, "imported aels"
and utilize openarg feed study title, works prompted save file as.
any ideas?
tank you!
on form
dim integer = dcount("*", "a_import_aels_step_1") if = 0 strnorecordopenarg = "imported ael's" docmd.outputto acoutputreport, "rpt_universal_no_records", acformatpdf, "f:\desktop\imported ael's.pdf" exit sub
on report
me.txt_header_title.caption = "" & strnorecordopenarg & ""
access-vba ms-access-2010
Comments
Post a Comment