Search results

Thanks, I will check it out

Great to hear that you've already worked on ShellandWait, please let us know when the code has been added to the site and I'll check it out.

Thanks Michael, that's what I was afraid of. I think what I'll do is create a batch processing file in Adobe to password protect the PDFs for me. Now here's another question. How do I call the Adobe batch processing command from my Access VBA module? I could just put a message box that...

Here's an example of what I'm talking about: DoCmd.OpenReport ReportName1, acViewPreview, , "[District]= '" & District & "'" DoCmd.OutputTo acOutputReport, "", acFormatPDF, "" & FilePath & "District " & District & " - " & ReportName1 & ".pdf" DoCmd.Close acReport, ReportName1 I use the...

Anyone have any ideas? Thanks!

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

Really? So if we decide to begin tracking Performance and Potential for Store Managers, I wouldn't have any reason to update the fields in my succession planning table to include those variables? I should have known that in advance when I first designed the query?

Nothing wrong with your suggestion, but it obviates the need for an update query at all. You could just delete and append every time something changed and never use an update query. I'm not sure which is more efficient, but the query runs very quickly for me. Thanks again for your help.

As business needs change, the required fields in a query can also change. There's nothing wrong with the design; the queries reflect the current needs of the business.

The update queries change over time as the tables being updated change (fields may be added or removed). I think I found a decent solution. I can copy the source table name and paste it into the update to field for each field, then all I have to do is type the first couple letters of the field...

Exactly, append queries are a lot easier but for some reason Access requires you to type in each field name by hand for update queries. Unfortunately, I have several update queries to maintain, containing around 40 fields each, and the queries change over time.

That's a good suggestion, but doesn't it defeat the purpose of an update query? I was hoping that I missed something obvious and there was an easier way to specify the fields to be updated in the query.

Let me ask a simpler question: Is there a shortcut to specify the "Update To" field in an Update query without needing to manually type the table and field names? For example, I currently have to type the following in the "Update To field" for Zone: [spupdate - Current SM-AM...

No problem, does anyone else have a suggestion on how to efficiently write an update query so it updates all fields in one table with the same named fields in another table?

Can you tell me how? I know how to use the * to add the fields to be updated, but how do you use it to update all of those fields with the appropriate fields from the source table?

I have a temporary table that I use to update a master table. I use both update and append queries to bring in information from the temporary table to the master table. The structure works fine, I'm just wondering if there is an easier way to create an update query without needing to manually...

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...