Multiple Search Criteria - VB

L

Lowrider72

Hello All,

Hopefully someone can help me here...I have an unbound form and 14 unbound
text boxes which I am using to search a table for data. I have been told the
best way to go about this is to create a string and then apply the string to
the recordset. I have no idea on how to do this. Currently, I am using
temporary tables to conduct my searches and they tend to bloat the database.
The searches are also beginning to take a long time as the database is
increasing in size. I'm looking for some help in creating the code that
would create a string of all my text boxes and then apply the string to the
recordset...The following is some info regarding my unbound form...Could
someone please gimme some sample code and/or possibly steer me in the right
direction......

form: frmSearch
table: tblOccurrence
textboxes: txtCriteria1 through to txtCriteria14

Once again, any help would be GREATLY appreciated :)

Regards
 
T

Tom Wickerath

Hi Lowrider,

If you send me a private e-mail message, with a valid reply to address, I
will send you a QBF (Query By Form) sample database. This sample includes
checking listboxes, check boxes, and textboxes for criteria that is entered.

Tom

QWaos168@XScom cast. Dnet (<--Remove all capitalized letters and spaces).
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

Hello All,

Hopefully someone can help me here...I have an unbound form and 14 unbound
text boxes which I am using to search a table for data. I have been told the
best way to go about this is to create a string and then apply the string to
the recordset. I have no idea on how to do this. Currently, I am using
temporary tables to conduct my searches and they tend to bloat the database.
The searches are also beginning to take a long time as the database is
increasing in size. I'm looking for some help in creating the code that
would create a string of all my text boxes and then apply the string to the
recordset...The following is some info regarding my unbound form...Could
someone please gimme some sample code and/or possibly steer me in the right
direction......

form: frmSearch
table: tblOccurrence
textboxes: txtCriteria1 through to txtCriteria14

Once again, any help would be GREATLY appreciated :)

Regards
 
L

Lowrider72

Tom,

For some reason it says that your address is undeliverable...

Anyway, I would really like to see your sample databse (Query By Form)...My
email address is mississauga_guy@hot mail. com (<----remove spaces in hotmail
and .com)

Thank you in advance for taking the time to reply to my message and
assisting me with my problem.

I look forward to hearing from you.
Regards
Jorge
 
L

Lowrider72

Tom, one more thing....I am using Access 97...

Lowrider72 said:
Tom,

For some reason it says that your address is undeliverable...

Anyway, I would really like to see your sample databse (Query By Form)...My
email address is mississauga_guy@hot mail. com (<----remove spaces in hotmail
and .com)

Thank you in advance for taking the time to reply to my message and
assisting me with my problem.

I look forward to hearing from you.
Regards
Jorge
Click to expand...
 
T

Tom Wickerath

Sure. I already have your e-mail address, if this is the same tina that I
think it is.

Tom
_______________________________________

:

Tom, i'd be grateful for a copy of your sample db, also. may i email you?
thx, tina
 
T

Tom Wickerath

Sokan,

I am sending you a copy now. I seem to be having some trouble sending
attached files to hotmail addresses, so you may need to provide an alternate
address if you receive my message without an attachment.

Just a word of warning: it is never a good idea to post an e-mail address to
any newsgroup message. The spammers will love you for doing so.

Tom
________________________________________

:

I sure would appreciate the code because I'm in the same delema as
LowRider72. My email address is XXXXX. Thanks!
 
Top