Hi everyone,
I'm hoping someone might be able to assist me with this small database I'm working on. I've attached a quick dry bones example of what I'm looking for and made so far.
Details
6 keyword buttons
1 column of data. These are file paths to .pdf files to be made in to hyperlinks later
1 sub form query in the main form that updates on keyword tab (for now).
For the most part, I have that working.
Issue
Ex: C:\ARCHIVE\NAME1 - C180 J487E 943 U777.pdf
If I put C180 as the first keyword and U777 as the second, this record shows up.
If I swap them and place U777 as the first keyword and C180 as the second, the record does not show up.
What I would like to happen
I would like to be able to search these records by keywords from the 6 text boxes, in any order.
I'm not yet comfortable scripting any VBA myself but have been able to follow along with other examples in the past if that's a route that's best. Would just need to be pointed in the right direction if you don't mind.
Edit: Here's what I have currently in my search criteria if that helps.
Like "*" & [Forms]![Search]![txtbox1] & "*" & "*" & [Forms]![Search]![txtbox2] & "*" & "*" & [Forms]![Search]![txtbox3] & "*" & "*" & [Forms]![Search]![txtbox4] & "*" & "*" & [Forms]![Search]![txtbox5] & "*"
Cheers,
I'm hoping someone might be able to assist me with this small database I'm working on. I've attached a quick dry bones example of what I'm looking for and made so far.
Details
6 keyword buttons
1 column of data. These are file paths to .pdf files to be made in to hyperlinks later
1 sub form query in the main form that updates on keyword tab (for now).
For the most part, I have that working.
Issue
Ex: C:\ARCHIVE\NAME1 - C180 J487E 943 U777.pdf
If I put C180 as the first keyword and U777 as the second, this record shows up.
If I swap them and place U777 as the first keyword and C180 as the second, the record does not show up.
What I would like to happen
I would like to be able to search these records by keywords from the 6 text boxes, in any order.
I'm not yet comfortable scripting any VBA myself but have been able to follow along with other examples in the past if that's a route that's best. Would just need to be pointed in the right direction if you don't mind.
Edit: Here's what I have currently in my search criteria if that helps.
Like "*" & [Forms]![Search]![txtbox1] & "*" & "*" & [Forms]![Search]![txtbox2] & "*" & "*" & [Forms]![Search]![txtbox3] & "*" & "*" & [Forms]![Search]![txtbox4] & "*" & "*" & [Forms]![Search]![txtbox5] & "*"
Cheers,