Search results

I figured it out. Two of the fields have periods at the end of them: - Customer Part No. - MPA Part No. When I ran my code I would get an error that it could not find the field "Customer Part No#". It changed the period to the number sign. I went into the table and added the number sign to...

That did not work.

IDK. The people I do see stuff use VLOOKUP for everything. I am not concerned about how they used to it, I am focused on how I want to do it.

It is mine to deal with so that is what brought me here. Sometimes when questions like this are asked the replies become more about the way it should be instead of the way it is. I am stuck with the file they send me. They are not going to change it just for me.

I am fairly new at this company and this is the second one I have received. Initially I deleted row 1 and imported it manually to get the table created. Access dropped the periods in the field names during the import. I did not notice there were periods in the name until I tried to use the VBA...

The Excel files are supposed to come every month but they only come when there is a change. Is Excel Automation something I can add to the VBA in my Access database so it will work on the new sheets as they come?

Good morning. I receive an Excel file from another department in my company. I cannot have the field names changed - it is what it is. The Excel file has data from A to G. Row 1 has the effective date so it will have "Effective July 1st 2024" in Column G. Row 2 has the field names. Two of...

I work in the automotive aftermarket. The entire industry is based on the tail wagging the dog.

I love seeing comments like this. We pay a company to convert our data into a specific XML format. They require the data be loaded using (11) sheets. It is what it is. It is not my circus, not my monkeys. There's the way it ought to be and there's the way it is.

I figured it out. Not all the LOAD_* tables have the field "Part Number" in them. I found this thread here and added gemma-the-husky's code to mine: Function ClearPartNos() On Error GoTo ErrorHandler Dim T As TableDef For Each T In CurrentDb.TableDefs If T.Name Like...

I just setup a dummy db and the code works 100%.

It shows all the records I want deleted.

I ran the Compact and Repair database function and tried running it again. Now I am getting "Too few parameters. Expected 1."

I went Create -> Query Design -> SQL view and typed in: DELETE FROM LOAD_Asset WHERE [Part Number] NOT IN (SELECT [PartNo] FROM PN_Keep) When I opened the LOAD_Asset table the only data still in the table were for the numbers that matched what I had in the PartNo field of the PN_Keep table.

I have eleven tables that have data appended via queries. All the table names start with "LOAD_". All the tables have a field named "Part Number". The queries build data for all our part numbers. Sometimes I need data for all part number and sometimes I only want data for specific part numbers...

@MajP - I found this thread after trying to use ConcateRelated on a large data set. I downloaded a few different versions of the db you posted on here. I tried to run the query "qry_artist_DConcate" so I could see how your code worked. I get #ERR3078. Any ideas on this?

I thought about a master make table. The db will be used by other people so I have no control over making sure a make master table is updated.

That worked. Thanks.

The first data set I worked with had the FREIGHTLINER - TRUCKS - MEDIUM / HEAVY DUTY so I used: IIf([Make] Like "* - *",Left([Make],InStr([Make]," - ")-1),[Make]) That worked fine. My boss asked me to see if it would work on another data set. That data set has the HINO (MEDIUM DUTY). I do not...

No because I have makes like Alfa Romeo, John Deere, etc that would split them. I specifically need it for " - " and " (". And just in case something else came up I could add in a Text(3) to my code.