Go Back   Access World Forums > Search Forums

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

With the code working once I click ok user form there with duplicate name still in field so I manually have to delete it. I tried code to set it to "" but keeps throwing up an error.

Any...
Forum: Forms 09-24-2017, 07:50 AM
Replies: 13
Views: 1,286
Posted By chrisjames25
Re: Check Userform entry not a duplicate

Cheers Gasman that solved the problem.

Moke - it may do, hadnt thought of it as the form creating sole purpose is to create new categorys so i instantly assumed would have to type in a textbox
Forum: Forms 09-24-2017, 05:57 AM
Replies: 13
Views: 1,286
Posted By chrisjames25
Re: Check Userform entry not a duplicate

HI Pat

Apologies for follow up but the Dcount is not working on my VBA. I must have done it wrong. Not sure how to insert the code into this message so apolioges if it goes in against forum...
Forum: Forms 09-24-2017, 12:12 AM
Replies: 13
Views: 1,286
Posted By chrisjames25
Re: Check Userform entry not a duplicate

Hi Guys

Many thanks for your posts especially the detailed one above about controls and events Pat. It really made things simple and easy to understand. Will have a play now with my forms and see...
Forum: Forms 09-23-2017, 06:39 AM
Replies: 13
Views: 1,286
Posted By chrisjames25
Re: Check Userform entry not a duplicate

Also if your suggested the right approach if you are also trying to stop duplicates across two field. I.e. First and last name?
Forum: Forms 09-23-2017, 06:34 AM
Replies: 13
Views: 1,286
Posted By chrisjames25
Re: Check Userform entry not a duplicate

Many thanks for your feedback on this and thanks pat for answering a follow up question before I even ask it about getting A more user friendly message than the one access provides.

Any chance...
Forum: Forms 09-23-2017, 02:45 AM
Replies: 13
Views: 1,286
Posted By chrisjames25
Check Userform entry not a duplicate

Hi All

First post here and just starting trying to build a stock system at work. Understand a bit about VBA etc form Excel but first project on Access.

Anyhow, my question is this:

1) Is...
Showing results 1 to 7 of 7

 
Forum Jump



All times are GMT -8. The time now is 05:42 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