VBA Validate for duplicates

[Raanan]

HI,

Im running a basic appointment calendar in excel that feeds to access (purely because users don't have MSAccess), and feeding t this way due to problems we encounter having a shared document that multiple users update.


its a simple DATE and TIME check Is it possible that upon clicking "check buton" that it will check if datebox1 (date) AND timebox1 (time) - Match In the access database before adding the entry?
Or am I best having a formula that combines both the date and the time and having this as the primary key that way preventing duplicates?

[Kenneth Hobson]

Sounds like you would want to query Access data? You could use a Sheet's QueryTable or one of various ADO methods. To get started with the latter, search for posts here or find other links like: http://www.rondebruin.nl/win/s3/win025.htm