FIELD VALUE TO BE RECOGNISED

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Floyd - 01 Aug 2006 05:57 GMT

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,

Reply to this Message

John Vinson - 01 Aug 2006 06:23 GMT

>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
[quoted text clipped - 4 lines]
>
>Much Appreciated,

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]

Reply to this Message

Floyd - 01 Aug 2006 08:26 GMT

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.

> >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
[quoted text clipped - 18 lines]
>
> John W. Vinson[MVP]

Reply to this Message

John Vinson - 01 Aug 2006 19:45 GMT

>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.

Well... I would have answered differently had I known that, of course.
My telepathy must have been on the blink... <g>

>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?

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]

Reply to this Message

Floyd - 02 Aug 2006 03:06 GMT

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.

> >Hi,
> >I'm obviously new to access and am trying to replicate a sold access 97
[quoted text clipped - 15 lines]
>
> John W. Vinson[MVP]

Reply to this Message