Form Problem

[MichaelR]

I have a form created that currently uses a combo box to validate the records.
I would like to switch this to a text box and have it validate against the
same table.

Table name is: part/description
Field name is: partnum

Basically once the user enters a value into the textbox and tabs out of that
textbox I want it to verify that they entered a valid part number. If they
do not enter a valid number I would like to see an error message "Please
enter a valid part number or see the systems administrator."

Thank you in advance for all of your assistance.

Mike R.
ERP Consultant

 

[Jeff Boyce]

Mike

I think I understand what you are trying to do, but I don't see how forcing
users to remember valid part numbers and chiding them when their memory (or
keyboarding skills) fail will help your users get their jobs done.

What is it about the combobox setup you already have that isn't working for
you/your users?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[MichaelR via AccessMonster.com]

Actually this is for a physical inventory that we perfom every 6 months. The
users are basically doing data entry from a count tag that is given to them.
The combo box caused issues during the last physical inventory because of the
"autofill, or autocomplete"
For example - We have part number 12345 and we have 12345RM , 12345/CFM - Etc.
SO during the entry they would start with 13245 and it would add the RM or
CFM etc.... While reconciling the inventory numbers we found that we were
not tying out due to that issue. Management decided that they would just
like the data entry staff to enter the numbers and then once they tab off the
field it would validate....

I hope that explanation makes sense.....

Mike

Mike

I think I understand what you are trying to do, but I don't see how forcing
users to remember valid part numbers and chiding them when their memory (or
keyboarding skills) fail will help your users get their jobs done.

What is it about the combobox setup you already have that isn't working for
you/your users?

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have a form created that currently uses a combo box to validate the
records.

[quoted text clipped - 15 lines]

Mike R.
ERP Consultant

 

[Jeff Boyce]

Mike

If I have a combobox with those kind of "part numbers" and I have the
autocomplete on, and I enter "12345R", I don't get the "/CFM" item. Perhaps
typing one more symbol (or using the dropdown to select the correct item)
would suffice?

By the way, doing data entry of 6 characters ("12345R" or "12345/") less
work that typing up to 9 (??) characters ("12345/CFM"), and you get the
benefit of only seeing valid values (no validation required).

Did management consider ALL the costs/benefits?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Actually this is for a physical inventory that we perfom every 6 months.
The
users are basically doing data entry from a count tag that is given to
them.
The combo box caused issues during the last physical inventory because of
the
"autofill, or autocomplete"
For example - We have part number 12345 and we have 12345RM , 12345/CFM -
Etc.
SO during the entry they would start with 13245 and it would add the RM or
CFM etc.... While reconciling the inventory numbers we found that we were
not tying out due to that issue. Management decided that they would just
like the data entry staff to enter the numbers and then once they tab off
the
field it would validate....

I hope that explanation makes sense.....

Mike

Mike

I think I understand what you are trying to do, but I don't see how
forcing
users to remember valid part numbers and chiding them when their memory
(or
keyboarding skills) fail will help your users get their jobs done.

What is it about the combobox setup you already have that isn't working
for
you/your users?

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have a form created that currently uses a combo box to validate the
records.

[quoted text clipped - 15 lines]

Mike R.
ERP Consultant

 

[MichaelR via AccessMonster.com]

Trust me - You are preaching to the choir here. LOL
Let me ask you this.... Is there a way to turn the autocomplete off?

I personally like typing the first 1 or 2 characters and then using the
dropdown box to select the appropriate number. I am not sure why they really
want to pursue typing in every number....doesn't make much sense to me either.

Mike

If I have a combobox with those kind of "part numbers" and I have the
autocomplete on, and I enter "12345R", I don't get the "/CFM" item. Perhaps
typing one more symbol (or using the dropdown to select the correct item)
would suffice?

By the way, doing data entry of 6 characters ("12345R" or "12345/") less
work that typing up to 9 (??) characters ("12345/CFM"), and you get the
benefit of only seeing valid values (no validation required).

Did management consider ALL the costs/benefits?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Actually this is for a physical inventory that we perfom every 6 months.
The

[quoted text clipped - 38 lines]

 

[Jeff Boyce]

So after you present the additional typing/cost and error-reminding
validation you are told "just do what I say" ... hmmm, does your boss have
pointy hair?<g>

Yes, you can open the form in design view, select the combobox control and
turn off the autocomplete property.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

Trust me - You are preaching to the choir here. LOL
Let me ask you this.... Is there a way to turn the autocomplete off?

I personally like typing the first 1 or 2 characters and then using the
dropdown box to select the appropriate number. I am not sure why they
really
want to pursue typing in every number....doesn't make much sense to me
either.

Mike

If I have a combobox with those kind of "part numbers" and I have the
autocomplete on, and I enter "12345R", I don't get the "/CFM" item.
Perhaps
typing one more symbol (or using the dropdown to select the correct item)
would suffice?

By the way, doing data entry of 6 characters ("12345R" or "12345/") less
work that typing up to 9 (??) characters ("12345/CFM"), and you get the
benefit of only seeing valid values (no validation required).

Did management consider ALL the costs/benefits?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Actually this is for a physical inventory that we perfom every 6 months.
The

[quoted text clipped - 38 lines]

Mike R.
ERP Consultant

 

[MichaelR via AccessMonster.com]

No pointy hair but close!

How do you turn the autocomplete off...I went to the design view of the form,
went to that combo field and was unable to locate where you turn that off....

Thanks again!

So after you present the additional typing/cost and error-reminding
validation you are told "just do what I say" ... hmmm, does your boss have
pointy hair?<g>

Yes, you can open the form in design view, select the combobox control and
turn off the autocomplete property.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

Trust me - You are preaching to the choir here. LOL
Let me ask you this.... Is there a way to turn the autocomplete off?

[quoted text clipped - 29 lines]

 

[Jeff Boyce]

Mike

You and I agree that "auto complete" would make more sense.

Microsoft decided to call it "Auto Expand".

Regards

Jeff

No pointy hair but close!

How do you turn the autocomplete off...I went to the design view of the
form,
went to that combo field and was unable to locate where you turn that
off....

Thanks again!

So after you present the additional typing/cost and error-reminding
validation you are told "just do what I say" ... hmmm, does your boss have
pointy hair?<g>

Yes, you can open the form in design view, select the combobox control and
turn off the autocomplete property.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

Trust me - You are preaching to the choir here. LOL
Let me ask you this.... Is there a way to turn the autocomplete off?

[quoted text clipped - 29 lines]

Mike R.
ERP Consultant

 

[MichaelR via AccessMonster.com]

Auto expand.....got it...

Thank you!

Mike

You and I agree that "auto complete" would make more sense.

Microsoft decided to call it "Auto Expand".

Regards

Jeff

No pointy hair but close!

[quoted text clipped - 24 lines]