Verify Entry

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a text box on a form that the user enters in the last name of a person
for a record. It is critical that the name be spelled correctly, I am
expiriencing multiple input errors. What I would like to do is have the user
enter the persons name and then for it to ask for them to enter it again. If
the second typing does not match the first then it should ask them to start
over and type it twice until the name is the same twice in a row.
 
Terry,
I think your making the entry more difficult than needed.

Use a combo box, with the query behind it, based on all the "legitimate"
names from your table.
Set the LimitToList =Yes.
Now, a user can not enter a mispelled name, or any name that is not
listed, and... with AutoCorrect = Yes, the user will be helped with
legitimate entry... as they type the name.
Also, since there could be duplicate LastNames, you could include
FirstName in column 2 of the combo to further assist the user in finding the
correct person.

But, the best solution is to locate a record by it's unique identifier
(key field) value... not LastName.
If you have 4 Smiths, your "find" will probably turn up the first one
every time.
 
Al Camp said:
Terry,
I think your making the entry more difficult than needed.

Use a combo box, with the query behind it, based on all the "legitimate"
names from your table.
Set the LimitToList =Yes.
Now, a user can not enter a mispelled name, or any name that is not
listed, and... with AutoCorrect = Yes, the user will be helped with
legitimate entry... as they type the name.
Also, since there could be duplicate LastNames, you could include
FirstName in column 2 of the combo to further assist the user in finding the
correct person.

But, the best solution is to locate a record by it's unique identifier
(key field) value... not LastName.
If you have 4 Smiths, your "find" will probably turn up the first one
every time.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions



Hello Al Camp
Click to expand...

Can you please help me with my problem. I have a similar situation, but I
would lik e to put the combo box on a form as I have a report reading from
multiple queries, with the same criteria - "name", and instead of being
prompted for the criteria multiple times, I would to just be prompted once.
Thanks
 
Christina,
It might be best to post this as a new question, rather than a tag on to
this one. It could get pretty confusing with 2 problems under one thread.
When you do repost, please explain more clearly as to whether your
problem is the form/combo criteria, or the multiple prompts for a Name
parameter. Please add more details in either case...

First, you shouldn't be using a Name to find anything. It's very
possible to have 2 Bob Smiths. You must use a key field associated to the
name to exactly identify the person you're looking for... or reporting on.
If you multiple queries behind your report, only one of them should call
for the Parameter. If the Name parameter is included in several of your
queries, you're probably getting a prompt for each one. Forget about the
report right now, and just run the final query behind it. Get that to run
clean... with only one prompt. Then when you run the report and you get
multiple prompts, you know it's the report that's generating them.

Try what I suggested (really shooting in the dark...) and if you still
have problems, start a new post with more detail about the problem.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
 
Thanks I have posted a simpler vesion of my problem. However my situation is
that I have several independent queries with prompts. and for 1 final query I
combined those queries.

I trust you will be able to help.


Thanks

Christina
 
Several problems exist for me beyond my control and changing capability. The
progam tracks pasess issued to different people. There are multile passes
issued to the same person. When one pass expires a new pass is issued. There
is no unique identity assigned to each pass and the only way to tell the
difference between the passes is by checking the issue date and the expire
date. Before issuing a new pass, the person has to turn the old pass in.
Prior to me developing an access data base to track it they were using
multiple excel sheets, which was causing data corruption and duplication. The
passes are issued to thousands of people and with the multiple spellings of
names I can not make a table to hold their names. The only thing I can think
of to minimize mispelling the name is to have it entered twice so the user
verifies that it is correct otherewise they enter so many names, they end up
mispelling it because of this.

How do I get it so that when a name is entered, the user has to verify the
name twice so that it is not spelled incorrectly or at least minimizes
incorrect spelling.
 
Terry,
Have you considered simply using 2 fields. Many applications/web sites
use that method. Even Windows uses that method in high security functions.
You are asked to enter your ID, and in the next field reenter it again.
I've seen the same, many times, with email address entries when ordering
products over the web.

Field1 must equal Field2 before execution can continue...

Using the BeforeUpdate event of Field2...
Private Sub Field2_AfterUpdate(Cancel as True)
If Field1 = Field2 Then
'procede with your code
Else
MsgBox "Don't Match, vbOKOnly, "Verification"
Cancel = True
Field2.Undo
End If
 
Back
Top