search form

karatelung · May 15, 2003

i have a table containing nearly 5,000 clients and need an efficient way to find a specific one.

i want a search form where i can enter part of the name, click a button and all the matching names will be returned. from there i'll be able to double-click the name to take me to the specific record.

if i type "smith, t",

smith, tara
smith, tracy
smith, tanner

would be returned. is this possible?

thanks.

IMO · May 15, 2003

This may help

IMO

karatelung · May 15, 2003

that's perfect.

thanks a lot!

IMO · May 15, 2003

You're welcome, glad it helped

IMO

firouz · May 21, 2003

is it working with access xp

hi:
i used your code but i got error in the vb ....the error is:

" Dim db As database "

[ microsoft error ]
[ compile error
User-Define type not defined]

and i can not go forword to see if there is another error ....
is this code working with Access XP.

thanks alot

IMO · May 21, 2003

Have you checked for missing references?

IMO

karatelung · May 21, 2003

make sure the "Microsoft DAO 3.6 Object Library" is checked in the Visual Basic editor. i doubt it's a default in XP as they're advancing ADO.

also, it might help to put a "DAO" in front...

try:

Dim rs As DAO.Recordset
Dim db As DAO.Database

hope that helps.

firouz · Jun 1, 2003

Hi:
Thanks karatelung & IMO and sorry for the delay .....
that's true i forgot to cheked the reference...now it works but i got onother error in this line .......
rs.FindFirst criteria
compile error: " method or data member not found"
Thanks again

IMO · Jun 2, 2003

Try moving the Microsoft DAO 3.6 Object Library higher up in the list

IMO

firouz · Jun 7, 2003

need help again

thanks alot IMO.........and sorry for the delay in the reply.......any way it works with out error when i moved it up in the list.......
but i have another Q

i am so sorry but you helped me alot......
when i select from the list and then press select the record i selected does not show in the form nothing happened....
it does not go the function
Function Isloaded(strForm As String) As Integer
in the (modUtilities)

if you need more descripe i will
thanks again.............

beef · Jun 7, 2003

This attachment may help. You may have to modify it to suit your need

Cheers!!!

Lou

search form

karatelung

Registered User.

IMO

Now Known as ___

Attachments

karatelung

Registered User.

IMO

Now Known as ___

firouz

Guest

IMO

Now Known as ___

karatelung

Registered User.

firouz

Guest

IMO

Now Known as ___

firouz

Guest

beef

Registered User.

Attachments

Similar threads

Users who are viewing this thread