Search results for query: *

Finally sussed it out! I had spelt !ProcessData wrong, works perfectly now. Thanks for your help on this one Rick, much appreciated. [thumbsup2] Cheers, Cooch

G'day Rick, Should the statement read: If (!UOM = rstAlias!UOM) And (s <> !ProcessData) Then instead of: If (!UOM <> rstAlias!UOM) And (s <> !ProcessData) Then I am getting the error Run-time error '3265': Item not found in this collection. Don't tell me, I am going to try and work it...

Howdy Rick, Absolutely fantastic!!! It worked an absolute treat. I cannot thank you enough. Out of curiosity, if I wanted to restrict the action to only where the field UOM matched in both tables would it be possible? I didn't ask this question first up because I honestly did't think it was...

My apologies for not being clearer. The problem I have is where the Alias from tblAlias is contained within the string in ProcessData in tblData I want to strip that alias from the string. Using example 2 in tblData (2PCV04), as the string &quot;KPA.G&quot; is in tblAlias (line 2) I want to...

Thanks Rick, The main reason I was going to use a replace function was because you can't use wildcards in an IN statement. If I have been ill informed, please let me know because I would prefer not to have to use code if I dont have to. Regards, Cooch

Hi, I am trying to use the VBA function Replace() in Access 2000 to replace field values in a table based on values in a field of another. Example Tables TblData (approx 40,000 records) TagNo ProcessData 1PT5 100Kpa 2PCV04 10KPA.G 1JB12 Yellow 1PT07 7psi 5PG03...