Search results for query: *

I found it...VBAJock's code works, if you put the Cleanfunction = Sitem AFTER the EndiF. I just needed another cup of coffee to see that. Thanks again!

Greetings VBAJock and Acemam! VBAJock's code runs, but the result is the same. I end up with a null value in the Item field. The function accurately converts ZZJD1234 to 1234, but my table now shows no item. Aceman's code is what I started with. I wanted to change to a function since I am...

Hi I'm trying to modify a field in a table by calling a function. It runs without error, however the value I'm trying to modify is replaced with a null value rather than the value the function provided. Here is my code: Public Sub Clean() Dim Sql Sql = "Update [tablename] SET [Item] =...

Thanks Bob, but what I am trying to avoid is a situation where I can't see everything that is happening in my subroutine. I'd like to see all the logic in the subroutine itself so that I may be able to open it in the future and quickly see what is happening without having to bounce around...

perhaps I dismissed too quickly. OK...Let me try that. Thanks for the input. I appreciate your help and your patience with me! Dave

Can't use a union query because the tables are all very different. Everything in my TempPending table is perfect, other than the fact I can't export it sorted using just VB (no saved query).

Can't because I've got data coming from different places with similar records.

I can, but I want to do the whole thing in a module WITHOUT running a saved query. I've pasted the relevant section. I want to get rid of the saved query "CreateCSV" and do it entirely in the module. So, the line of code I'm unhappy with is: DoCmd.TransferText acExportDelim, "pending export...

Thanks for the response. I have 2, so here they are PHV: I can do a "DoCmd.TransferText and export a query, but for everything else in my program, I am not using any Access queries, just sql statements and temp tables. The program is complete when a csv file is created and exported to 'My...

Hi All, Here is my problem...I have a bunch of code that inserts records into a temp table that I've created and I export that table for upload to an ERP system. I realized now that the data isn't sorted when it's exported to a CSV file. I either want to sort the data in the table using...