Compare two tables in VBA

S

Sal

Hi,

I'd like to use VBA instead of the unmatched query to
determine if any new records have been added. Is there a
way to do this?

Any help would be nice.

Thanks,
Sal
 
R

RobFMS

Sal

If you add a field called "ts" or "timestamp" and set it as Date/time field
type. For default value, set it to Now().

When new records are added, the field is automatically updated. (Don't show
this field to the user.) When you need to determine if new records are
added, you can determine this by the date/time stamp.

HTH

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

List all tables, including document structure 0
Word VBA - Want to test if Full Name is NOT Present in document 0
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Finding the right style field in VBA 0
Autonumber field in Excel that behaves the same as Access 0
Changing defauls in 2019 0
Access 2013: Form problem in reading data tables; relationship one-to-one 0
I'm trying to remove duplicate phrasing and words using VBA in Word 2

Top