Search results for query: *

Nevermind, I figured it out. Just had to change the True to False in the macro. Duh! All is good now.

Hi MajP, After the conversion, Adobe Acrobat remains open. Is there a way to close it? sleepy

Hello all, I have a Word macro which converts a word document to pdf and copies it to a network folder. I would like to code VBA in Access which will go to a specific directory containing a bunch of Word documents and run the macro on each file before returning to the database. Can someone get...

Thank you very much majP! Works like a charm. Just made a small ammendment to grab existing file name and change it from .doc to .pdf Sub ExportSectionToPDF() Dim rng As Word.Range Dim doc As Word.Document Dim theStart As Long Dim theEnd As Long Dim strDocName As String Dim...

The example given from the link is: With Selection.Find .ClearFormatting .MatchWholeWord = True .MatchCase = False .Execute FindText:="library" End With But how do I find what page number that relates to?

I just tested it and my assumption was correct; however, this doesn't work for me because the end point is not actually a table. Is there a way to modify this so it looks for a specific phrase instead of a table?

Sorry, I've been distracted and haven't had a chance to test this yet. If I want to go to the 2nd table instead of the first, would I just change the code to Set tbl = doc.Tables(2)?

This is drving me crazy and I've tried suggested solutions which don't seem to work. I have a simple query which includes LastName and FirstName fields. I can sort the query just fine for LastName then FirstName. I created a Report based on this query but it doesn't sort. I read that you're...

Sounds doable. Will give it a try, thanks.

Hello all, I'm not sure if this is more of a MS Word Macro question or an Access database question but here it goes. I have documents in .doc format which need to be converted to .pdf for processing. I am able to write code in Access to grab the .doc files and convert them to .pdf but now...

Hey MajP, forgot to get back to you earlier but just wanted to let you know it's done and works like a charm. Thanks very much for your help!

Actually, I have a better idea. I will write code to rename the csv file so the link doesn't need to be updated. Of course, I will copy the original filename to an archive folder first. Will let you know how it turns out, thanks!

Sounding better. Can I update the link to the new file using code or do I have to do it manually through the menu?

Thanks for the speedy reply. The csv filename changes every time though. I can code the exact path and filename if that helps.

Hello all, I have a table with client transaction information and a check box to mark whether it has been sent to a different department for processing. Once processed, the other department sends me a csv file with all the transactions it has processed successfully (some don't get processed due...

OMG, I feel like such a newb. Thank you! All I did was make a copy of my query, change it to an update query and put change to "true" in the checkbox. Simple but brilliant, thanks again!

Hi folks, I have a query which I use to periodically export data to an Excel file. I use the <DoCmd.TransferText acExportDelim> command to do this. After I do the export, I would like to update the checkbox field in one of the tables so that it doesn't get exported again when I run the...

SELECT tblWorkloadhrs.Tech, Sum(tblWorkloadhrs.Hours) AS SumOfHours, tblPersons.FirstName, tblPersons.LastName, tblWorkloadhrs.WorkLoadID FROM tblPersons INNER JOIN tblWorkloadhrs ON tblPersons.[autoIDPerson] = tblWorkloadhrs.[Tech] GROUP BY tblWorkloadhrs.Tech, tblPersons.FirstName...

Okay, I started over instead of trying to modify my mess and now it works! I must have been including extraneous fields that caused problems. Thanks for your help!

I still don't get it. I'm either getting the same thing or an error no matter what I try.