Message Box Help MsAccess 2000

  • Thread starter Thread starter John
  • Start date Start date
J

John

I am new to using access so forgive me if this seems like
a silly request
I want to be able to put duplicate name entries into a
table (Requests) but have
a message box pop up on my form to indicate that this
name already exist in
the table

Any suggestions gratefully received


John
 
It sounds like the name field is a primary key. There can't be duplicates
in a primary key field.
 
Hi John,

It sounds like you might want to implement the Soundex function. This will allow you to find
matching names, as well as phonetically similar matches such as:

Tom Wickerath vs. Thom Wickerath vs. Thomas Wickerrath

and

John vs. Jhon (when combined with a reasonably close spelled last name).

The code is available, among other places, in the book:

"VBA Developer's Handbook, 2nd Edition"
by Ken Getz and Mike Gilbert
Sybex, Inc.


Tom
______________________________________


I am new to using access so forgive me if this seems like a silly request I want to be able to
put duplicate name entries into a
table (Requests) but have a message box pop up on my form to indicate that this name already
exist in
the table

Any suggestions gratefully received


John
 
Sorry, I did not make my question very sensisble.. the
name field is not a primary field
in the table, the name can contain a duplicate entry.
Table is made up this way.

Part No (Primary No Dupliicates allowed) quantity -
WorksOrderNo - Date
the name is selected via another table called
tbl_Customer from which I tranfer the name to an unbound
text box via a recordset and choose what orders to
dispatch
My problem is that if the same customer places two orders
for different destinations I print a report with the
address labels
produced twice with the same address. I canott work out
how to transfer two fields over using the recordset so
next thing
i thought of was a messgage box as indication that
duplicate name may make a problem

thanking you very much for any help

John
 
I am thoroughly confused now. Show us the code that you are using to transfer the customer's
name to your unbound textbox, and what other field that you'd like to bring over in the recordset
at the same time. We might be able to help (no promises).

Tom
______________________________________


Sorry, I did not make my question very sensisble.. the
name field is not a primary field
in the table, the name can contain a duplicate entry.
Table is made up this way.

Part No (Primary No Dupliicates allowed) quantity -
WorksOrderNo - Date
the name is selected via another table called
tbl_Customer from which I tranfer the name to an unbound
text box via a recordset and choose what orders to
dispatch
My problem is that if the same customer places two orders
for different destinations I print a report with the
address labels
produced twice with the same address. I canott work out
how to transfer two fields over using the recordset so
next thing
i thought of was a messgage box as indication that
duplicate name may make a problem

thanking you very much for any help

John
 
Back
Top