I want to open two tables (rsNL, rsDL) and loop through one.
If a record in rsNL is not in rsDL I want to add that record to rsDL
If a record in rsNL is in rsDL I want to edit that record in rsDL to equal the same record in rsNL
The field [MLS #] is common in both tables
I have attached the code I have so far.
The loop does add a new record in rsDL if it is not in rsNL
But it is not updating those records in rsDL that are found in rsNL
Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted. Others take a little more time and effort and often providing a sample database is very helpf…
The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…