S
swordsman8
OK so here is where I am and what I am trying to do next.
Where I am.
I have my Visual Basic code tied into the OK command button. I have a Form
to search through my data and only put the requested information in a query.
So far I have all of this working fine. I have the code clear the query each
time it is used and repopulate the querry with the new choices.(The Where
From etc...)
The Problem with what I am trying to do next.
It has been decided that there needs to be a comments column. They then
what the option to search for a key word in the column to define the results.
The other problem is that the comments field has no specific order of info
in it. This means while multiple rows have the same info in the comments
field each row could have a different was of saying it.
Example
Laser Cut, Production
Production, Laser Cut
So here is it.
In visual basic I need to be able to do the following:
Leave Field blank (so not to limit results)
Input a key word to limit results
Thank you,
Swordsman8
If you have question just let me know.
Where I am.
I have my Visual Basic code tied into the OK command button. I have a Form
to search through my data and only put the requested information in a query.
So far I have all of this working fine. I have the code clear the query each
time it is used and repopulate the querry with the new choices.(The Where
From etc...)
The Problem with what I am trying to do next.
It has been decided that there needs to be a comments column. They then
what the option to search for a key word in the column to define the results.
The other problem is that the comments field has no specific order of info
in it. This means while multiple rows have the same info in the comments
field each row could have a different was of saying it.
Example
Laser Cut, Production
Production, Laser Cut
So here is it.
In visual basic I need to be able to do the following:
Leave Field blank (so not to limit results)
Input a key word to limit results
Thank you,
Swordsman8
If you have question just let me know.