Replies

Hi Hans,

Can you help me to look following error message? I don’t know why call funcation is not wok?

Thanks

Thanks.

But I need to use network global list to select name, so I don’t have anybody’s email address yet. The problem I have is Access don’t call funcaiton.

I need help, please.

Regards

Thanks

I fixed it. Now it works.

Hi Hans,

Still have error message, please see below: Thanks

Image cropped to 640 pixels wide by HansV

Thanks.

I insert the lines but error message pops up. Please see below:

Thanks

Hi Hans,

Thanks! I added a reference to Outlook library. But I don

Hi Hans,

Thanks! After I reviewed post 322,094 and use code provided by Francois, please see below. Everthing is works except the path of PDF folders. Where I should put the path in the code?
Please review the attached code provide by Francois.

“This program is tested on a win xp and I don’t know if it will run on other windows version.
In the attachment you’ll find to txt files.
Extract them and copy the content of each of the files in a different new module. Save the modules but don’t use the name RunReportAsPDF as this is the name of the sub and a sub may not have the same name as a module.
For each report you want to run, use an instruction as follow :
Call RunReportAsPDF(“ReportName”,”PrinterName”)
Replace ReportName with the name of your report.
Replace Printer Name with the printer name you find in the registry when the Adobe Distiller is set as default.
To find this out :
Set the adobe distiller as default printer.
Go to Start , Run and type regedit.
Navigate to the key HKEY_CURRENT_USERSoftwareMicrosoftWIndows NTCurrentVersionWindows
Look in the right pane form the key Device and note the string. (On my pc it’s : Acrobat Distiller,winspool,Ne01: )
This is the text you have to use as PrinterName.
Close the regedit.
Set you usual printer as default back.”””

Thanks

Thanks.

I did search in this forum by typing sending PDF files, but I didn’t find any useful information. Can you provide me some examples or detail of printing PDF file.

Thanks a lot.

Regards

Thanks. Now I am understood how link works is.

For my situation, I should use print to PDF. Below is my current process to send report of PDF format as email attachment:

1) Open the report
2) Select Adobat printer
3) Select email after PDF open
4) Change back to my default printer.

Is anyway to set step 2-4 automatic? I found a sample file regarding automatic change print to Adobat then change back to default printer from the website, but it doesn’t work when I click “Print PDF.” Please check the attachment.

Thanks

Yes. The text boxes are in the deatail section of the report. Can you provide the code with sample?

Thanks a lot.

Regards

Thank you so so much. I really learn a lot from you.

But I can’t relink all tables to the backend using a UNC path. I select Tools | Database Utilities | Linked Table Manager, and the “Select New Location of Reports pops up.” Should I just type the UNC path on the file name field or something else. If I go to my computer, then network drive, share folder, the link address will be “H:AccessMyDatabase.mdb”

Thanks again.

Regards

What I do now is to link the table from backend to frontend.

I am kind of confused about “using a UNC path of the form serversharefolder…database.mdb, the frontend should work for all users.” Can you provide more detail of it?

Thanks

Thank you for all information.

I still have the following questions need you assist:

1) The time of running database will be shorter if put backend database on the server and Frontend database on the local drive compare put both BE & FE on the server.
2) Should I zip the FE database and email to user, so user can download to their local drive?
3) Can we link the version of database to the current database? Or something likes that to let user to copy it easier?

Thanks

Thanks a lot.

I will take your advice.

Regards

Thanks a lot.

I did turn on Request read receipt on my outlook, but I still have to manually turn it on in each email from access. Can you provide more detail of set up read receipts in the VBA code, so I don’t have manually turn it on everytime???

Thanks

Regards