Too Many Duplicate Fields In FindAsUType

[Guest]

Hello All,

I am using Allen Browne's FindAsUType filter and have a question. First of
all thanks to Allen for creating this great tool! It works fine but when I
select the drop down box for the Filter Field I have 5 "Kit Number" fields to
choose from. I only want one. I'm sure it is something with my database but
I can seem to figure it out. I only want 2 fields to search on. They are
"NIIN" and "Kit Number". It doesn't matter which "Kit Number" I select it
still finds the correct kit. I just want to get rid of all the duplicates.
I am using Access 2003. Any help is appreciated.

 

[Allen Browne]

You can add the names of the controls you do not want the user to have
access to.

For example, if you want to suppress fields named "Field1" and "Field7",
change the form's On Load property to:
=FindAsUTypeLoad([Form], "Field1", "Field7")

That's Step 5 of the Installation section at:
http://allenbrowne.com/AppFindAsUType.html

 

[Guest]

I already did that so only "NIIN" and "Kit Number" were the only choices. It
shows 1 instance of "NIIN" and 5 of "Kit Number". I just want to get rid of
the 4 duplicate "Kit Number" in the drop down box.

You can add the names of the controls you do not want the user to have
access to.

For example, if you want to suppress fields named "Field1" and "Field7",
change the form's On Load property to:
=FindAsUTypeLoad([Form], "Field1", "Field7")

That's Step 5 of the Installation section at:
http://allenbrowne.com/AppFindAsUType.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Hello All,

I am using Allen Browne's FindAsUType filter and have a question. First
of
all thanks to Allen for creating this great tool! It works fine but when
I
select the drop down box for the Filter Field I have 5 "Kit Number" fields
to
choose from. I only want one. I'm sure it is something with my database
but
I can seem to figure it out. I only want 2 fields to search on. They are
"NIIN" and "Kit Number". It doesn't matter which "Kit Number" I select it
still finds the correct kit. I just want to get rid of all the
duplicates.
I am using Access 2003. Any help is appreciated.

 

[Allen Browne]

Then you will need to find out the name of the *controls* that have the Kit
Number labels attached to them.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I already did that so only "NIIN" and "Kit Number" were the only choices.
It
shows 1 instance of "NIIN" and 5 of "Kit Number". I just want to get rid
of
the 4 duplicate "Kit Number" in the drop down box.

You can add the names of the controls you do not want the user to have
access to.

For example, if you want to suppress fields named "Field1" and "Field7",
change the form's On Load property to:
=FindAsUTypeLoad([Form], "Field1", "Field7")

That's Step 5 of the Installation section at:
http://allenbrowne.com/AppFindAsUType.html

Hello All,

I am using Allen Browne's FindAsUType filter and have a question.
First
of
all thanks to Allen for creating this great tool! It works fine but
when
I
select the drop down box for the Filter Field I have 5 "Kit Number"
fields
to
choose from. I only want one. I'm sure it is something with my
database
but
I can seem to figure it out. I only want 2 fields to search on. They
are
"NIIN" and "Kit Number". It doesn't matter which "Kit Number" I select
it
still finds the correct kit. I just want to get rid of all the
duplicates.
I am using Access 2003. Any help is appreciated.

 

[Guest]

This is listed for the Row Source on Combo Box: cboFindAsUTypeField -
"NIIN";"NIIN";109;"[NIIN]";"10";"KitNumber_Lable";"Kit
Number";109;"[KitNumber]";"10";"KitNumber";"Kit
Number";109;"[KitNumber]";"10";"Text166";"Kit
Number";109;"[KitNumber]";"10";"Text204";"Kit
Number";109;"[KitNumber]";"10";"Text206";"Kit Number";109;"[KitNumber]";"10"

Any idea what I can do?

Then you will need to find out the name of the *controls* that have the Kit
Number labels attached to them.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I already did that so only "NIIN" and "Kit Number" were the only choices.
It
shows 1 instance of "NIIN" and 5 of "Kit Number". I just want to get rid
of
the 4 duplicate "Kit Number" in the drop down box.

You can add the names of the controls you do not want the user to have
access to.

For example, if you want to suppress fields named "Field1" and "Field7",
change the form's On Load property to:
=FindAsUTypeLoad([Form], "Field1", "Field7")

That's Step 5 of the Installation section at:
http://allenbrowne.com/AppFindAsUType.html

Hello All,

I am using Allen Browne's FindAsUType filter and have a question.
First
of
all thanks to Allen for creating this great tool! It works fine but
when
I
select the drop down box for the Filter Field I have 5 "Kit Number"
fields
to
choose from. I only want one. I'm sure it is something with my
database
but
I can seem to figure it out. I only want 2 fields to search on. They
are
"NIIN" and "Kit Number". It doesn't matter which "Kit Number" I select
it
still finds the correct kit. I just want to get rid of all the
duplicates.
I am using Access 2003. Any help is appreciated.

 

[Allen Browne]

It looks like the controls might be calle "Text166","Text204", etc.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

This is listed for the Row Source on Combo Box: cboFindAsUTypeField -
"NIIN";"NIIN";109;"[NIIN]";"10";"KitNumber_Lable";"Kit
Number";109;"[KitNumber]";"10";"KitNumber";"Kit
Number";109;"[KitNumber]";"10";"Text166";"Kit
Number";109;"[KitNumber]";"10";"Text204";"Kit
Number";109;"[KitNumber]";"10";"Text206";"Kit
Number";109;"[KitNumber]";"10"

Any idea what I can do?

Then you will need to find out the name of the *controls* that have the
Kit
Number labels attached to them.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I already did that so only "NIIN" and "Kit Number" were the only
choices.
It
shows 1 instance of "NIIN" and 5 of "Kit Number". I just want to get
rid
of
the 4 duplicate "Kit Number" in the drop down box.

:

You can add the names of the controls you do not want the user to have
access to.

For example, if you want to suppress fields named "Field1" and
"Field7",
change the form's On Load property to:
=FindAsUTypeLoad([Form], "Field1", "Field7")

That's Step 5 of the Installation section at:
http://allenbrowne.com/AppFindAsUType.html

message
Hello All,

I am using Allen Browne's FindAsUType filter and have a question.
First
of
all thanks to Allen for creating this great tool! It works fine but
when
I
select the drop down box for the Filter Field I have 5 "Kit Number"
fields
to
choose from. I only want one. I'm sure it is something with my
database
but
I can seem to figure it out. I only want 2 fields to search on.
They
are
"NIIN" and "Kit Number". It doesn't matter which "Kit Number" I
select
it
still finds the correct kit. I just want to get rid of all the
duplicates.
I am using Access 2003. Any help is appreciated.

 

[Guest]

Is it possible to set it up to draw information from just a table and not a
query? I think that is where my problem is.

It looks like the controls might be calle "Text166","Text204", etc.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

This is listed for the Row Source on Combo Box: cboFindAsUTypeField -
"NIIN";"NIIN";109;"[NIIN]";"10";"KitNumber_Lable";"Kit
Number";109;"[KitNumber]";"10";"KitNumber";"Kit
Number";109;"[KitNumber]";"10";"Text166";"Kit
Number";109;"[KitNumber]";"10";"Text204";"Kit
Number";109;"[KitNumber]";"10";"Text206";"Kit
Number";109;"[KitNumber]";"10"

Any idea what I can do?

Then you will need to find out the name of the *controls* that have the
Kit
Number labels attached to them.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I already did that so only "NIIN" and "Kit Number" were the only
choices.
It
shows 1 instance of "NIIN" and 5 of "Kit Number". I just want to get
rid
of
the 4 duplicate "Kit Number" in the drop down box.

:

You can add the names of the controls you do not want the user to have
access to.

For example, if you want to suppress fields named "Field1" and
"Field7",
change the form's On Load property to:
=FindAsUTypeLoad([Form], "Field1", "Field7")

That's Step 5 of the Installation section at:
http://allenbrowne.com/AppFindAsUType.html

message
Hello All,

I am using Allen Browne's FindAsUType filter and have a question.
First
of
all thanks to Allen for creating this great tool! It works fine but
when
I
select the drop down box for the Filter Field I have 5 "Kit Number"
fields
to
choose from. I only want one. I'm sure it is something with my
database
but
I can seem to figure it out. I only want 2 fields to search on.
They
are
"NIIN" and "Kit Number". It doesn't matter which "Kit Number" I
select
it
still finds the correct kit. I just want to get rid of all the
duplicates.
I am using Access 2003. Any help is appreciated.

 

[Allen Browne]

Sure: set the RecordSource property of your form to the table instead of the
query.

The code just loops through all controls on the form, and finds those that
are bound to a field.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Is it possible to set it up to draw information from just a table and not
a
query? I think that is where my problem is.

It looks like the controls might be calle "Text166","Text204", etc.

This is listed for the Row Source on Combo Box: cboFindAsUTypeField -
"NIIN";"NIIN";109;"[NIIN]";"10";"KitNumber_Lable";"Kit
Number";109;"[KitNumber]";"10";"KitNumber";"Kit
Number";109;"[KitNumber]";"10";"Text166";"Kit
Number";109;"[KitNumber]";"10";"Text204";"Kit
Number";109;"[KitNumber]";"10";"Text206";"Kit
Number";109;"[KitNumber]";"10"

Any idea what I can do?

:

Then you will need to find out the name of the *controls* that have
the
Kit
Number labels attached to them.

message
I already did that so only "NIIN" and "Kit Number" were the only
choices.
It
shows 1 instance of "NIIN" and 5 of "Kit Number". I just want to
get
rid
of
the 4 duplicate "Kit Number" in the drop down box.

:

You can add the names of the controls you do not want the user to
have
access to.

For example, if you want to suppress fields named "Field1" and
"Field7",
change the form's On Load property to:
=FindAsUTypeLoad([Form], "Field1", "Field7")

That's Step 5 of the Installation section at:
http://allenbrowne.com/AppFindAsUType.html

message
Hello All,

I am using Allen Browne's FindAsUType filter and have a question.
First
of
all thanks to Allen for creating this great tool! It works fine
but
when
I
select the drop down box for the Filter Field I have 5 "Kit
Number"
fields
to
choose from. I only want one. I'm sure it is something with my
database
but
I can seem to figure it out. I only want 2 fields to search on.
They
are
"NIIN" and "Kit Number". It doesn't matter which "Kit Number" I
select
it
still finds the correct kit. I just want to get rid of all the
duplicates.
I am using Access 2003. Any help is appreciated.