I have some modules that I use to create and email spreadsheets and PDF reports. I've been able to password protect the spreadsheets in the modules, but how do I password protect PDFs? Anyone know of some VBA code I can use as a template?
Thanks
Is there an efficient way to update all fields from one table to another table, when both tables have an identical structure?
I can quickly add all of the fields in the table to be updated, but how do I tell the query to update these fields from the update table without having to type each...