Rakier
Registered User.
- Local time
- Today, 12:28
- Joined
- Mar 21, 2002
- Messages
- 75
I'm having a similar problem to other ones that have been listed, but mine is slightly different (at leas I think so).
I have a table that uses three fields as its primary key:
dtmOrderDate
strUser
strItem
Basically, it is to make sure that the same user does not enter orders for the same item more than once a day.
I have a form where the orders are placed. There is a button to click to place the order when the form is completed. Everything works great.
However, here is where the sticky part comes in. If the user tries to place an order for the same item more than once on the same day, the order seems like it goes through fine. There is no error codes that crop up. However, only the first order for that item and user is stored in the table.
I thought that there would be an error message that would crop up if the same user tried to place the order more than once, but this is not happening. The order's not being placed, but Access isn't showing an error either.
There is error trapping on the form (generic but workable), but for some reason it is not displaying an error for this.
Any thoughts?
I have a table that uses three fields as its primary key:
dtmOrderDate
strUser
strItem
Basically, it is to make sure that the same user does not enter orders for the same item more than once a day.
I have a form where the orders are placed. There is a button to click to place the order when the form is completed. Everything works great.
However, here is where the sticky part comes in. If the user tries to place an order for the same item more than once on the same day, the order seems like it goes through fine. There is no error codes that crop up. However, only the first order for that item and user is stored in the table.
I thought that there would be an error message that would crop up if the same user tried to place the order more than once, but this is not happening. The order's not being placed, but Access isn't showing an error either.
There is error trapping on the form (generic but workable), but for some reason it is not displaying an error for this.
Any thoughts?