Recent content by drifter96

Thank you Pat, I don't like your answer :) but I was thinking that was my only option. I've had to do that in the past with txt files and Word. I was just hoping things had changed and it could be done with pdfs and Access.

I did that first and all I found was to do it using either Excel or Word to do the search. I was hoping to find a solution that can be done through Access.

Hello, I am trying to open a pdf, search the text for a specific string and capture the following characters. The pdfs do not have any tags. Example: Fax Number: XXX-XXX-XXXX Open PDF> Search for: Fax Number: Capture XXX-XXX-XXXX Thank in advance

I tried making the changes and get the following error: An Error Occurred: 3134 - Syntax error in INSERT INTO Statement. strSQL = "INSERT INTO dbo_ESC_tblAllDeedOfTrustSecuredLoans ( [Institution Code], [Institution Abbreviation], [Account Number], [Application Number], [Source...

I was trying it from a linked Excel Spreadsheet. strSQL = "INSERT INTO dbo_ESC_tblAllDeedOfTrustSecuredLoans ( [Institution Code], [Institution Abbreviation], [Account Number], [Application Number], [Source Application Code], " & _ "[Account Status Description], Origination_Date...

Yes, that's what I was using first. Then Tried INSERT INTO.

Hi, I am trying to import a CSV file with 287,000+ records into a SQL Server linked table. Using INSERT INTO takes a little over an hour. Someone had mentioned that there is a BULK INSERT that does the whole file at one time as apposed to one record at a time and should import a lot faster...

Thank you!

Hello, Is there a way to hardcode the From field when sending an email through VBA to Outlook? We are trying to have the Department name show up instead of the person sending the email. TIA

Nevermind, I found the solution. Replace(Format(FieldName,"@@@@@@@@@")," ","0")

I have a table with a account number field that can have mixed data and I need to add leading zeros to anything shorter than 9 characters: 293613590 => 293613590 56908790 => 056908790 6128540590 => 6128540590 3600OLDC79 => 3600OLDC79 43OLDTO7 =>...

Thank you so much! That did the trick. I never knew that was a thing.

This might be difficult to explain, but I will do my best. I have a user form that has two date fields on it, [txtFromWeekly] and [txtToWeekly]. The user enters the two dates, clicks a button and it runs a query. In that query it reads the two fields using the following criteria...