AllenBrown TypeAsUFind ?

  • Thread starter Thread starter Bandit
  • Start date Start date
B

Bandit

Ihave been reviewing the TypeAsUFind and have a ? My form have Part Name,
Part Number, Qty, Location, Remarks columns. I want to use this feature to
search this form. Can I change the code to look up this info using the
TypeAsUFind code. And if so, how do I go about doing this. I downloaded the
module and ran the debug. I copy and pasted the search boxes from the sample
database into my form and set the Onload property box as instructed. Now I
want to change the code to search for the columns listed above.
 
If you want to modify the code, that's fine, but you're on your own. I can't
do that for you.

As it stands, the utility at http://allenbrowne.com/AppFindAsUType.html
loops through the controls on your form, and does a bunch of work to figure
out which ones are bound to fields and the label by which the user knows the
field. For combo boxes, it looks to see if the bound column is the display
column, and responds differently depending on the capabilities of your
version of Access.

All this is transparent to you, i.e. you don't need to write a single line
of code to get it to work with your forms. If you have controls bound to
fields [part ame], [part number], etc, it will find them and offer those
fields in the combo where you choose which field you want to search in.
 
Wow. so this will work just as it is? I must have missed something. I will
go back and relook at it and see if I can figure it out. I followed the
instuctions and it just didn't work for me. I thought I had to change
something to meet the search critieria I wanted. ie. Part Name, Part
Number, Remarks versue city.

Let me go back and try to take another look and see if I can figure out what
I am doing wrong.

Thanks.
--
Bandit


Allen Browne said:
If you want to modify the code, that's fine, but you're on your own. I can't
do that for you.

As it stands, the utility at http://allenbrowne.com/AppFindAsUType.html
loops through the controls on your form, and does a bunch of work to figure
out which ones are bound to fields and the label by which the user knows the
field. For combo boxes, it looks to see if the bound column is the display
column, and responds differently depending on the capabilities of your
version of Access.

All this is transparent to you, i.e. you don't need to write a single line
of code to get it to work with your forms. If you have controls bound to
fields [part ame], [part number], etc, it will find them and offer those
fields in the combo where you choose which field you want to search in.

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

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

Bandit said:
Ihave been reviewing the TypeAsUFind and have a ? My form have Part Name,
Part Number, Qty, Location, Remarks columns. I want to use this feature
to
search this form. Can I change the code to look up this info using the
TypeAsUFind code. And if so, how do I go about doing this. I downloaded
the
module and ran the debug. I copy and pasted the search boxes from the
sample
database into my form and set the Onload property box as instructed. Now
I
want to change the code to search for the columns listed above.
Click to expand...
Click to expand...
 
Back
Top