Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Verification & Duplication Error
Hey everyone, Quick 2 questions...I need some help. I have a form that is dumping information into a Access Database. I need it to check to see if one of the entries is a duplicate. I already have it opening a connection to the Access database, but I need it to check Field("Claim") for a duplicate of the textbox named "Claim". Anyone have any ideas? I have an error message prepared, I just need it to verify the duplicate so it can pop the error message. 2nd question: How can I write vba so that it checks that the entry in a textbox is in proper date format? I have a textbox titled "Date" and currently it corrects the format if it's entered short (11/23 = 11/23/2006), but I've found out that Excel will accept the date format wrong. ex: it will accept 11/232/006 as a date. Is there a way to tell it to flag this date as incorrectly formatted? -- dok112 ------------------------------------------------------------------------ dok112's Profile: http://www.excelforum.com/member.php...o&userid=10581 View this thread: http://www.excelforum.com/showthread...hreadid=526160 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell verification | Excel Discussion (Misc queries) | |||
Date verification | Excel Discussion (Misc queries) | |||
How's this verification done? | Excel Programming | |||
Name Verification | Excel Programming | |||
Licence Verification | Excel Programming |