I think this will work, without writing code. I tested it yesterday and it appeared to work. I created an update query. The table & field to be updated is [tblData(Test)].[Status]. I wrote in the "Update To:" section "[tblData-NewData(Test)].STATUS". It updated the Status field in the first...
jrbarnett,
No where since I've posted. I tried to do some research online but, can't find anything that does all I need, and works. I've tried the Update queries, but can only figure out how to change all records of a certain field, not individual records and fields. Make sense? Also, thanks...
I am long time Access user, but very new to VBA. Currently, I have a two tables, one with old "history" data, and one with newly updated, "temporary" data (this data is acually currently being imported from a text file). I want to write VBA that will:
1. Review record in Temporary table and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.