Search Facility in Forms

[Mile-O]

No, it just became more blurred as I shrunk it to the forum's accepted size.

The picture as it is can be found here.

 

[Only1Abhi]

thanks for the info on pic Mile-O-Phile.

Waiting for reply on my recent problem.

See ya!

 

[Only1Abhi]

hi Mile-O-Phile bro


u seem busy!
still waiting for solution on my problem (7 posts above this)
I'm sure you can crack this problem.

Do u have a hotmail address I can contact u on?
I understand u may not want to post it here (publicly) so u can call me to any chat room and give this information there if u wish.
Just say web address and time.

Regards
Abhi

P.S. Thanks again for all the solutions u have provided.
Can u now tell me:

I want to connect a button to a form so that when I click on it, the currently viewed form is closed and another new form is opened.
Can u plz find me codes for this in VB mode and if possible also in MS Access' macro mode. Many thanks.

 

[Only1Abhi]

Hey Mile-O-Phile bro,

where are u?

I urgently need replies....

are u ill or something?

sorry to see u ill and get well soon!

OTHERWISE

plz reply to my questions above. desperatly need help!

Thanks

 

[Mile-O]

I'm here...just been busy at work.

Regarding the ID and names problem can you post a database and I'll have a look at it?

Also, to close the current form and open another.

DoCmd.Close acForm, Me.Name
DoCmd.OpenForm "frmNameOfTheFormToOpen", acNormal

should go on the command button's Click() event.

 

[Only1Abhi]

What format file should i post?

Access 97 file format, 2000 or 2002?

 

[Vassago]

Hey Mile, your wildcard search database, can you paste something that will work in Access 97? I have one already, just want to see yours.

 

[Mile-O]

Abhi, any format will do? '97 or 2002 is preferable.

Vassago - '97 sure thing. But that'll have to wait until tomorrow as I've finished work for the day and that's where I use '97.

 

[Only1Abhi]

No replies, so....


I can't fit the 2002 file format because it's tooo big.

so here's the 2000 file format 1st.

 

[Only1Abhi]

sorry Mile-O-Phile,

u posted your reply just before me.

Here's the 97 format.

 

[horsecow]

hello,


i just found this topic as i was lookignf or a search form too. This isnt the idea i had had, but it works perfectly and ive been able to use it and implement it into my own database (for instance, ive got multiple text boxes and commands searching for the different fields in the table).

My only problem is this: you do a search, the majority of records disappear. to get them back you need to close the form and open again. Is there anyway i can make a button that when pressed will 'refresh' the data. IE, make it so that it has all the records again, just like when you first open the form?



thanks alot.

 

[Mile-O]

Yep, if you just restore the RowSource of the listbox to what it was when the form loaded and requery the listbox with code behind the button all the records should come back.

 

[horsecow]

sorry to be a pain but could you explain that a little more for me. this si the first database ive created myself (for a school project) so im a bit stumped.


I assume the button would have something like


onClick lstColumn Rowsource = SELECT tblCostume.[Costume Reference Number], tblCostume.[Costume Theme Code], tblCostume.[Costume Description], tblCostume.[Costume Rack Number], tblCostume.[Costume Sex], tblCostume.[Costume Size] FROM tblCostume;


but that obviously wont owrk as i just made it up right there.


Once ive got this refreshing button nailed then my databse is done so a bit of extra help would be great!

cheers

 

[Mile-O]

I suppose you could declare a string variable at form level and name it strSource.

On the Form_Load() event, you could assign the listbox's RowSource to the string i.e

strSource = Me.lstYourListBox.RowSource

and then, on the reset information button's Click() event:

With Me.lstYourListBox
   .RowSource = strSource
   .Requery
End With

 

[horsecow]

hey,


thanks mile-o-phile

i was just aboutt o reply and say i couldnt get it to work, that when i pressed the refresh button all the details from the lst disappeared when i decided to reread what you had said, i had forgotten about setting that string variable. Now i have no idea what a string variable is but i figured all it was was somethign that was holding the details about the row source. I had an idea that i could use a textbox and call it strSource - it would hold the details and i could make it invisible so no one would be able to see it.


It worked a charm, so thanks alot for your help.

 

[mingbin]

hey mile,

can u email me that file u attached? i can't open it....my email is zekiel@hotmail.com

Thanx.....

 

[Mile-O]

I will when I get a chance - it was one I did at home and I'm at work just now.

What format do you want? '97, 2K, or XP?

 

[mingbin]

hi mile,

2k will do....thanx again and sorry for the trouble...

 

[Groundrush]

I also had problems opening the database.

I exported the contents into another database and it works fine


here is a copy (to save Mile-O-Phile some time)


Mile-O-Phile if you don't mind I may have to ask for some assistance later

I have been trying to adapt your example into mine, and I may be doing something wrong or leaving something out.

I will keep trying.....it's always something stupid.

Thanks

 

[Mile-O]

Thanks Groundrush, that's great, and no, I don't mind.