Search results

Thanks all. As the files are being downloaded by month and year I was randomly selecting and opening files to view the data and for a while, things seemed to fit a particular pattern, then it changed. Now am scanning random files after each download. Have made a few adjustments to the regex...

Thank you Eberhard. Appreciate it. Seems to work with my test document. I tried with another file and looks like will have to play around with the pattern a bit more as am discovering additional variations and even cases without the keyword MP or CP. I imagine for those, will have to do...

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

Couple more variations on the trim and remove spaces functions using Access vba. Examples: ? removespaces("1234 567 89") 123456789 ? removeextraspaces("1234 567 89") 1234 567 89 ? trimall(" 1234 567 89 ") 1234 567 89 ...

this example doesn't address getting the data into the clipboard, just getting it out using vba to paste data from the clipboard into a field of a table. if using edit rather than addnew, you will need additional code to locate the correct record to be updated. Sub TestCliptable() 'Paste data...

Edgar, Thank you for the code. I did a test and looks like it will meet the need. Have some appointments today so will work on this later on and let you know. The Doc Man, I did look on the MS site for reference/example before and couldn't quite put into practice.

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

Assuming you are using Outlook, here is an example from code I use. The first code section will go in the form in the button click event for your email, so only copy what is between the Sub Subcontractors and End Sub. I think I copied all the necessary parts, if not, then we'll need to...

Couple questions: Will the receiver (to) email be taken from the form or does the user add it to the email (is it to one person or group or to a predefined recipient? Does the data to be sent need formatting or can be plain text? If formatted, then would need to use some html. Depending on...

Assuming this was your suggestion, I saved the records that came up empty (which turned out to be a manageable 24 unique records) into a table and then added a field and manually pasted the Segment into it. After that, added this exception table to the query and defined it as Segment...

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

Tried your suggestion, closed the browser, edited the preference file and unfortunately, didn't seem to affect the download location. Assuming the files were all downloaded in the same time frame, that would work, however, when there are interruptions, files get comingled with other downloads...

At this point, would rather not clear the downloads as I use it as a lazy repository since we receive files from all over (web, network, email) and some will have additional work done with them and get renamed. Since I know where all the files are, I can get to them easily if someone has a...

good idea and agree would rather not mess with Registry (may not even have permission to do so at work). maybe I'm missing something though. follow up question...even though I can know ahead of time where the files are default saved to, what will tell the code which files to move to the final...

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

In reference to the code for RegExReplace, it can be found here under post #15: https://www.access-programmers.co.uk/forums/threads/regex.309793/

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

Seems to me, the only things that were asked have nothing to do with vba. They suggested to attach a copy of your database and that instead of providing pdf files, that you simply add a screen shot into your message which would make assisting you easier in allowing them to provide guidance.

Not sure if already doing this...you could insert code to test if form is opened stand alone and have vba adjust settings based on that condition, then wouldn't need to click the button to move the buttons between different parts of form as could happen automatically by your code...

Had a chance to try today and yes seems to work with the Boolean (original code) from my Post #6. Wonder if it has to do with my computer or windows/office version at the time I grabbed the code as it didn't work for me prior to your encouragement for another go at it. I have a new laptop...