Forum Discussion
Help Needed: Trouble Filtering and Re-Entering Data
Hi everyone, I'm looking for some help. I've started working on something quite simple, but I can't get it to function correctly. Yep, total noob moment. The concept is straightforward, and I've at...
Hi,
I've attached what I’ve started so far.
I don't see an attachment to your post. Do others?
...currently, it still says the data has already been entered, even after deletion.
What do you do to check for duplicates?
Servus
Karl
****************
Access Forever News DevCon
Access-Entwickler-Konferenz AEK
I check for duplicates with uuid.
I try to attached what i have made so far, but it doesn't let me
Hi,
My question was about what you technically do to check for or prevent duplicates.
- Your first screenshot shows that you wrote "Primary Key" as description for the UUID field. In reality, the Primary Key is set to the Autonumber field ID. Is there a unique index also set for the UUID field or is the duplicate check done only in code or wherever?
- Your other screenshots show a form with an import button. Technically it would be necessary to see the code (or macro) behind the button if it is relevant for the duplicate check.
Servus
Karl
****************
Access Forever News DevCon
Access-Entwickler-Konferenz AEK- Your first screenshot shows that you wrote "Primary Key" as description for the UUID field. In reality, the Primary Key is set to the Autonumber field ID. Is there a unique index also set for the UUID field or is the duplicate check done only in code or wherever?