Search for records

zoe81uk · Jul 15, 2003

Hello there,
please help me. I am trying to build a database for a company who have many clients. I woudl like a form which has a text area where you could enter the client reference number, then press on an option button which would find the details of that client and present a form with all their details on. How do I do this?
Please reply.
Thanks for your time
Zoe

IMO · Jul 15, 2003

Have a look at this example, it should get you on the right track. Let me know if you need the 97 version

IMO

zoe81uk · Jul 15, 2003

Thankyou for your example thats great it will definately help.
Where did you get your animated picture from. I thought it was great. WHere can I access more.

IMO · Jul 15, 2003

I got the .gif from

http://www.animationfactory.com/

and here's the search results from yahoo for animated gifs

http://search.yahoo.com/bin/search?p=animated+gifs&ei=UTF-8

There are hundreds of sites with free .gifs, but you may have to change its size as the maximum Avatars size here is 50 * 50

Hope this helps

IMO

zoe81uk · Jul 17, 2003

Hi IMO Ive just tried the search but its telling me that the macro isnt working so I am unable to use it. Woudl you be able to send me another one? Have you any worksheets on this search?
Thanks
Zoe

IMO · Jul 17, 2003

Do you mean my example isn't working or have you tried to duplicate it in your DB and it's not working?

IMO

toddbingham · Jul 17, 2003

IMO, could you pst the 97 version?

IMO · Jul 17, 2003

Here you are

IMO

toddbingham · Jul 17, 2003

IMO,

I tried to recreate the same type of search list, the problem I am having is when I double click th ename to open the form, it does not open to that person, the form will open but it displays nothing.

toddbingham · Jul 17, 2003

I fixed the above problem, now when I have the form pop up from double clicking in the list box, I want to make that form disappear just like in yours. How do I accomplish that?

IMO · Jul 18, 2003

In the OnOpen event of the form which is opened from the Double Click add....

Code:

Private Sub Form_Open(Cancel As Integer)
DoCmd.Close acForm, "NameOfYourSearchForm"
End Sub

Hope this helps

IMO

toddbingham · Jul 18, 2003

It did, thanks.

Search for records

zoe81uk

Guest

IMO

Now Known as ___

Attachments

zoe81uk

Guest

IMO

Now Known as ___

zoe81uk

Guest

IMO

Now Known as ___

toddbingham

Registered User.

IMO

Now Known as ___

Attachments

toddbingham

Registered User.

toddbingham

Registered User.

IMO

Now Known as ___

toddbingham

Registered User.

Similar threads

Users who are viewing this thread