Forbid an ID

[sharkantipav]

Hello All,


I have a Database that I fill through VBA/Excel...
My main field is TRADE_ID which is set on NoDuplicates.
I have some trades that reset every month for 3 months for example
So my field TRADE_ID will look like

ABCDEFGH-1   'for 1st month
ABCDEFGH-2   'for 2nd month
ABCDEFGH-3   'for 3rd month

When my trade is closed... I want to forbid ABCDEFGH as the beginning as an ID

I dont know how it can be possible

[June7]

Why is Excel involved?

What would you use in place of ABCDEFGH?

What criteria would be referenced to 'know' that ABCDEFGH should not be used?

[sharkantipav]

From excel I import several fields
In column B I have TRADE_ID
In Column A I have NEW/RESET/CLOSE

So basically when there is CLOSE Just before he will import the record with the last ID.... ABCDEFGH-3 for this example and will forbid ABCDEFGH
Next trades will look like GHTFRES-1 etccc

[June7]

Generating unique identifier is a common topic in forum. However, the usual requirement is to assign ID at time record is created.

Doing this during import from Excel will be difficult if not impossible. Maybe have to run code after import to 'fix' the ID.

What method are you using for import?

Still doesn't explain why Excel is involved. How does this data get into Excel? Why not directly into Access?