Search results

Pulling data out of many historical documents. Put together this regex pattern and has been working fine. Unfortunately, the latest batch has a slightly different format. I modified the pattern, however, would like to know if it could be refined to maintain the original output format of previous...

I am using the following to find the table number for a word phrase in an MS Word Table. This allows me to determine a reference point to tell the code what cell or cells should be located to extract from word into an access table as in some files the table number is <x> and in other files, the...

Would like query to get data from one table into the query from another table based on matching a word within a string. There are a few records where the functions I used didn't quite get there and wondering how might be able to get the stragglers. In this example containing the relevant...

Was wondering about vba code to change the default download location for Chrome so that I can have some files be saved somewhere other than the default. I found code that can show where the downloads are being saved to, didn't seem to locate code for how to change it. I manually changed it and...

Found an almost workable vba solution to the issue of printing a specific page and saving it as a pdf and thought I'd share it. Searched through many threads and sites and combined a few commands from each. The nearly fully automated solution used SendKeys which I commented out and left them...

Probably took on more than my current knowledge. Read a few threads here and did searches and read other sites. Have gotten close, still missing something(s) since haven't been able to get the code fully functioning. I had some help setting up the account with someone from Procore API...

Probably making this more complex than need be. Can this be done in code/formula to do one the following without having to create a table of dates. Different statements trying to reach the same result (whichever is easier). Option 1: Find the 4th Monday of the Month, EXCEPTION - if the...

Sharing this idea... Had a project to rename a bunch of scanned documents. Was given a name convention to use. After spending some time manually renaming by keying in the same information over and over decided to see about automating the repeating value portion of the rename. I had a rename...

I have used the great code from MajP FAYT on a few forms and some work perfectly and a few have an issue. I read the post Populating Combobox with a lot of data and the link in there. The issues I am experiencing are When I refresh the underlying table (I click a button on my form and it...

I've seen a few discussions about interacting with Word documents from Access and thought I would post a few questions regarding some items that aren't functioning very well. Background: A set of word documents were developed to be used as templates (starting point as they aren't real...

Putting this out for our next meeting this coming Friday in a new thread rather than in the original thread. Pre pandemic we had in person meetings at the Microsoft Offices in Mountain View, California. Since then, we have begun using zoom. We would like to invite a few people from this...

Pre pandemic we had in person meetings at the Microsoft Offices in Mountain View, California. Since then, we have begun using zoom. We would like to invite a few people from this great/useful forum site to our next monthly Access user group meeting via zoom this coming Friday. For now, we...

I briefly saw a system popup and then my access "froze" as it is waiting for me to click on one of its buttons. I tried minimizing Access, and it won't respond. I tried pressing Alt+Tab and can see and let go of the keys on it, but it still won't become the active window and stays behind the...

Background: Our department does not have Adobe Acrobat Pro. We are using Bluebeam Extreme. I have been successfully using PDFTkServer through VBA to automate the process of merging PDF files. Due to the current situation, there is now an increase in the number of digitally signed pdfs...

A couple months ago, our company was upgrade from 2013 to 2016. Seemed to go fairly smoothly. Today I wanted to try the compare database feature. After I provided the two files and clicked the button, it told me it was missing a component support file. I don't recall the name as I'm writing...

Was looking for how to find and go to a line number in the code window since the information of the line and col is visible. While not as straight forward as Ctrl+F, found this code snippet...

This query seems to work and not asking how to get it working. Rather, checking if this is the right approach or is there another preferable method. Have a list of document numbers and would like to display the highest one, however if there are documents that contain a title of TBD, would like...

In earlier versions of access the F4 key would open a drop down in both Normal view and design view. Unfortunately in newer versions such as 2013, the F4 key opens the Property Sheet when in design view. Have been searching periodically over the years to locate a keyboard shortcut replacement...

A typo was discovered in a word document that we receive. Was advised that they are not going to provide a corrected version to users until there is a major change to the file. Since via Access, I have been able to edit text elsewhere in the word doc, I thought would be simple enough to add a...

I am using the following to Select the textbox when the date is before another date. I thought it wasn't working. However when I stepped through the code it does select the text until the End Sub and then becomes unselected. I have this in the after update event. Is this the right spot? Or...