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

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
"Sal" <(E-Mail Removed)> wrote in message
news:298c01c3a7a4$8570c060$(E-Mail Removed)...
> 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