FIELD VALUE TO BE RECOGNISED

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

Guest

I need my Customer Name field to be recognised by the database to avoid
missing information in reports due to data entry typos when the customer name
field is used as part of the query. Is there an easy way to do this if my
database is only 1 table? If not I guess I'll need a customer name table to
relate to my outbound manifest table. I was hoping to avoid this for now, but
if that's what it takes I could use some help.

Much Appreciated,
 
I need my Customer Name field to be recognised by the database to avoid
missing information in reports due to data entry typos when the customer name
field is used as part of the query. Is there an easy way to do this if my
database is only 1 table? If not I guess I'll need a customer name table to
relate to my outbound manifest table. I was hoping to avoid this for now, but
if that's what it takes I could use some help.

Much Appreciated,
Click to expand...

A one-table Access database sounds like a huge waste of effort. It's
like an Excel spreadsheet with only raw data, no expressions!

Bear in mind that we have NO way to know anything about the structure
of your (one) table, how you're entering customer names, or any other
information that might help - but I will say that you should be using
a Form, that you certainly SHOULD have a separate customer table (with
a unique CustomerID, not using customer name as a key), and use Combo
Boxes to *select* existing customers, rather than typing in at random
and then "recognizing" "Joe Schwartz" as being the same as "Joseph
Shwarz"... which Access cannot do for you.

John W. Vinson[MVP]
 
Hi,
I'm obviously new to access and am trying to replicate a sold access 97
product. This product used around 6 tables of which most are useless to me.
Data entry is via a form with a scanner which occassionally misreads my
customer name barcodes, so combo boxes are not likely to be time effective as
there are hundreds of them.I will definetely give a customer table a go. The
query you helped me with will do the job, but I'll have to figure out what
this 'Query by form technique' is. Sounds the type of thing I'm after. Any
links for that?

Regards,
Thanx for your help, I'm sure I'll have another post soon.
 
Hi,
I'm obviously new to access and am trying to replicate a sold access 97
product. This product used around 6 tables of which most are useless to me.
Data entry is via a form with a scanner which occassionally misreads my
customer name barcodes, so combo boxes are not likely to be time effective as
there are hundreds of them.
Click to expand...

Well... I would have answered differently had I known that, of course.
My telepathy must have been on the blink... said:
I will definetely give a customer table a go. The
query you helped me with will do the job, but I'll have to figure out what
this 'Query by form technique' is. Sounds the type of thing I'm after. Any
links for that?
Click to expand...

Open a Form based on your table. On the menu, select Filter... and use
the Filter by Form option. Give it a try!

John W. Vinson[MVP]
 
Hi John,
That was great, thanx very much. I’m now experimenting my new form with the
old Access 97 tables.
In the customer table I have CustID ( Autonumber ) and Customer Name ( text
) fields, there is also address and ph. no. fields that I don’t require. In
the Outbound table I have CustId with many other fields.
In the 97 form ( security protected ) Customer name is the input value (
and also displayed in reports ), but this field is not in the Outbound table,
the CustID autonumber is shown.
In my new form (almost a replica ), the autonumber is shown where I want the
Customer Name displayed/entered.
Using 1 table I managed to get what I wanted for now, unforunately amongst
other requirements I need the customer name value recognised, if it isn’t I
should have to correct it or use another form/sub-form to enter the new
customer name in the customer table.
I have tried various relationships, look-ups and property changes to no
avail. I tried most at CustID – CustID relationship, and a couple at CustID
– Customer Name. Which is it, if any, or is there another way?
The 97 program seems to use a very simple form for ‘create report using
wizard’. I’ve obviously got a long way to go!!
I’ll apologise in advance for the hassle, I have passed E-learning Access
2003 courses, but their idea of ‘expert’ is pitiful.
 
Back
Top