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

Popular posts from this blog

php - Android app custom user registration and login with cookie using facebook sdk -

django - Access session in user model .save() -

php - .htaccess Multiple Rewrite Rules / Prioritizing -