Go Back   Access World Forums > Search Forums

 
Showing results 1 to 2 of 2
Search took 0.00 seconds.
Search: Posts Made By: Gasman
Forum: Forms 09-24-2017, 10:30 AM
Replies: 13
Views: 1,286
Posted By Gasman
Re: Check Userform entry not a duplicate

From what Pat was saying perhaps you should clear the .Text property?
Forum: Forms 09-24-2017, 06:27 AM
Replies: 13
Views: 1,286
Posted By Gasman
Re: Check Userform entry not a duplicate

That syntax works only if the control is numeric. For text you need to surround with a single quote.

So try


DCount("Category", "Tbl_Category", "Category='" & Txt_NewCategory & "'") > 0

...
Showing results 1 to 2 of 2

 
Forum Jump



All times are GMT -8. The time now is 07:37 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World