In attached DB I have written a code on Frm_Regn to print a report. But it is giving error. Please guide me. Also I would like to know how the code should be to print the report directly without print Preview.
In attached DB I have written a code on Frm_Regn to print a report. But it is giving error. Please guide me. Also I would like to know how the code should be to print the report directly without print Preview.
Maybe if you just post the code and error details, won't have to take time and effort to download db and run procedure.
Direct to printer (acViewNormal) is the default if destination not otherwise specified.
DoCmd.OpenReport "report name"
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
I've made some changes to your code and added a commented out example of how to print directly.
As June pointed out you'll get a much better response by simply posting up your code.
HMS.zip
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
Thanks a Lot!!! GOD BLESS YOU!!!!!!!!!!
I've made some changes to your code and added a commented out example of how to print directly.
As June pointed out you'll get a much better response by simply posting up your code.
HMS.zip
Thanks a Lot!!! GOD BLESS YOU!!!!!!!!!!