Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
PerlMonks  

Re: How do I avoid inserting duplicate numbers into an Access table?

by Zero_Flop (Pilgrim)
on Mar 06, 2004 at 06:27 UTC ( #334459=note: print w/replies, xml ) Need Help??


in reply to How do I avoid inserting duplicate numbers into an Access table?

I have not tried this but not knowing any better here is how I would approch it.

I am assuming that the feild that you do not want to have duplicate values in is your unique identifier for each record. If this is the case you want to have Access AutoGenerate the number for that field when it is created. You set this up when you set up that field in the Table.

Now when you want to add a field through automation. Have access create the record then fill in the other data. You should not have to worry about that field

  • Comment on Re: How do I avoid inserting duplicate numbers into an Access table?

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://334459]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others rifling through the Monastery: (3)
As of 2022-05-22 02:17 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Do you prefer to work remotely?



    Results (78 votes). Check out past polls.

    Notices?