Compare two tables in VBA

  • Thread starter Thread starter Sal
  • Start date Start date
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
 
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

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top