Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Warning message for duplicated records
Bill, I used your codes but did not work. A run time error showed up saying the jet engine cannot find the record. Maybe I did not use your code correctly. I replaced "form5" with the name of my form (frmContact) and "txtid" with "id", "txtname" with "name" and txtdob with "dob". When I entered...- zhangsh
- Post #5
- Forum: Microsoft: Access Forms
-
Warning message for duplicated records
Bill, thank you so much for your response. I'll apply your codes to my DB but would like to clarify two things from you: 1. What is the "form5" in your code? 2. what are the "txtid", "txtname" and "txtdob"? They are not my variable names, right? If so, what are they? Thanks.- zhangsh
- Post #3
- Forum: Microsoft: Access Forms
-
Warning message for duplicated records
This is a MS Access question. A MS DB(let me call it CONTACT) has a table (called INFORMATION) which has three primary keys: id, name and dob. When enter a new record in a form, I'd like to have a warning message when I enter the same record twice. I'd like to see the message right after I...- zhangsh
- Thread
- Replies: 5
- Forum: Microsoft: Access Forms
-
Number of charaters were truncationed in SAS
I used PROC IMPORT to read an Excel file into SAS. One of the variable contains a string of chacters with a length from 200 to 400 character depending on the record. I noticed that SAS did not read the whole string in, instead, a substantial part of the string was truncated and that's not what I...- zhangsh
- Thread
- Replies: 1
- Forum: SAS Institute, Inc. solutions
