Search results

Well I guess that is why I had so many problems with it.

I am trying to use it in a query. Does the Split function only work in VBA?

@theDBguy - I tried that statement and received the following error message: "The expression you entered has an invalid . (dot) or ! operator or invalid paranthesis. You may have entered an invalid identifier or typed parentheses following the Null constant." When I close the error message...

@jdraw - Thanks. That works great. I can get A LOT of use out of that. @theDBguy - Thanks for the examples. I was trying just the split part. I figured more to it so that is why I asked.

@theDBguy - I googled the Split function and tried using their examples and all I got was errors. Would you please provide an example of how to use the Split function in this scenario? @jdraw - Thanks for the function. I used arnelgp's statement but I guess if the code could be modified so that...

I have text like this: L6 - 5.9L 359ci DIESEL DI Turbocharged vin C - 4 valve OHV V8 - 6.6L 6599cc 403ci DIESEL MFI Turbocharged vin L type LGH - 4 valve OHV I want to extract the VIN info - just the letters in bold. In these examples they are both single letters. Sometimes they can be a...

No. The IN in the macro's SQL statement refers to the db where the source table is. I run that macro at least once a month every month. It has worked 100% for two years.

Vlad, the combination of your two things did it. The interesting thing with the INSERT statement is I use one in a macro to do something similar and I had to write it that way for it to work. That db is on a server so IDK if that is has anything to do with it. Pat - I want to keep the monthly...

I had thought of that. Trying that gave me an error message that had to do with my FROM clause.

I checked off the "Require Variable Declaration" but I am still getting the same error message.

The typos were in the post because I realized I could simplify the code after looking at it here. I fixed them in my post. I changed it from Option Compare to Option Explicit. I do not know what "in the VBA IDE, 'Require Variable Declaration." means.

Good morning all. I have some code that updates some local tables from one Access db into another. The source db is replaced with a new version monthly. The current file name is "VCdb_AUGUST_2021.accdb". I added "VCdb_" to the table names in the destination db. This is the code: Option...

@gemma-the-husky - six places? I hear what you are saying but no one at my company is working that hard that we would need six places. Right now I am using @arnelgp's code and it is working great. Thanks again.

@arnelgp - that code worked awesome. Thanks. If I had a payroll I would put you on it. LOL.

If I am heading in the right direction, what function would I use to count folders and files? CountIf?

I was kind of hoping someone was going to say to use this function instead because it automatically does what you need. Thinking about it now, I am thinking about an IF statement to see if the ZIP folder is already in there. If it is in there count the occurrences of the base folder name and...

Good morning. I am using this code to move a ZIP folder from desktop to an archive folder: Dim filPath Dim folPath As String filPath = Dir(C:\Users\EzGoingKev\ & "*.zip") folPath = "C:\Users\EzGoingKev\ArchiveFolder\" Dim FSO As Object Set FSO = CreateObject("Scripting.FileSystemObject")...

Did you read this part of my OP - "And FYI - Before anyone tells me this a bad way to do it and that I should be doing it this way instead - I have no control over this at all. This is the way I was told to do it. I do know if you do not open and re-save it with the UTF-8 with BOM selected the...

The export_specname tells it the first row are fields, tab separated, no text designator, etc. IDK how it would export right without that.

I have tried using the 65001 at the end when exporting using the following code: DoCmd.TransferText acExportDelim, "export_specname", TableName, "C:\Users\Name\Desktop\FileName.txt", True,, 65001 I also tried: DoCmd.TransferText acExportDelim, "export_specname", TableName...