How do I make a script so I dont update twice?

[oais1]

Hi,

I'm trying to build a VBA code in Access that dumps Excel data into a
Access Table (Appends it to Table).

My existing Code takes data from Excel and pops it into Access Table.
However, If I click the macro twice it duplicates the data in th
field.

HOW DO I DO THIS PUHLEEASE:

Before it updates the data into the access table, it compares the exce
field with the last data entry in Access, and if its the same say
"you've already entered this record".

Thanks

 

[Dick Kusleika]

oais1

What code are you using to append the Access table?

 

[onedaywhen]

Referential integrity in the database is used to prevent this kind of
thing, not code in the client application.

Get your table's schema correct. Add constraints to your table,
including but not limited to a real primary key (am I right in
thinking you've used one of those useless INDENTITY/Autonumber columns
as you PK?)