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!
Search results for query: *
- Users: jamescen
- Order by date
-
My first attempt at record set - cant get it to work
Go to your VBA form and check if Microsoft DAO 3.6 Object Library is selected under Tools, Reference menu. If you only wanted to check if a name already exists in a record, why not try the DCOUNT Function? Look under Help for more details. dim intCount as integer intCount =...- jamescen
- Post #10
- Forum: Microsoft: Access Modules (VBA Coding)
-
Check a Field against a table's field--S/B simple
The single quote is used when you use string types. I think that LoanNumber is of type Integer so the single quotes are not needed. Try this: If DCount("[LoanNumber]", "tblLoanInfo", "[LoanNumber] = " & Me![loannumber]) > 0 Then MsgBox "Duplicate...- jamescen
- Post #10
- Forum: Microsoft: Access Modules (VBA Coding)
