Search results

No i have not. But I will look at it. I like what he is doing with this code now I want to learn it. Thanks

Let's set it to no and do the code that way. When we are done I would like for you to explain all of the code to me to help me learn this better. Again Thanks

Ok in the table I have the Field Properties "Required" set to Yes. Is this the best way to handle this?

Thank you for what you have done so far. The "Yes" part looks good but the "No" will let you enter a duplicate number. I think it should clear it at go to new record.

Sorry this not working. It's telling me that any number that I enter is a duplicate. When I do enter a number that is a duplicate it works like it should. It's not letting me to add a new number.

Ok I got this to work. If this is good will you explain it to me so i can learn it? Thanks for all of the help

Private Sub TransactionNumber_AfterUpdate() Dim lngNumber As Long lngNumber = Me!TransactionNumber Me.Undo With Me.RecordsetClone .FindFirst "TransactionNumber = " & lngNumber MsgBox "Transaction Number " & lngNumber & " Has Already Been Entered" _ & vbCr...

Ok that works perfect!!! Now how can you get it to go to the Transaction Number if it is a duplicate? Then after you get this to work will you explain it to me so I know how this works? Thanks for taking the time to help me with this.

I'm new to vba and access. Im looking for some to code this and explain it line by line so I can understand what it does. I learn the best from detail examples. I know they are a lot to this code to get it to work. I been looking for over a week. I do know that they are a thousand ways to do the...

I'm looking how to look for a duplicate in a form and display a msgbox if it's true and go to that Transaction Number or enter new ticket if false. I have a table named InHouseAccount a field named InHouseAccountID set to autonumber and a field named TransactionNumber Data type set to number and...

My name is Cecil. I am from Jellico, TN. I am a beginner at MS Access. I learn the best for seeing examples.