I'm trying to design a database and running into some questions which I couldn't figure it out.
1. I'd like to let the user input any keywords in a text box and the Access searches the corresponding fileds with the combination and any of the keywords the user typed, just like the Google does.
2. Is it possible to search the content of a linked file in Access, including PDF, DOC, XLS, PPT?
3. How can I open a file with only one button or link whatever the file format is (e.g.
DF, DOC, XLS, PPT)?
Any suggestions would be appreciated. I'm newbie in Access and VB coding, so please include samples if it's possible.
1. I'd like to let the user input any keywords in a text box and the Access searches the corresponding fileds with the combination and any of the keywords the user typed, just like the Google does.
2. Is it possible to search the content of a linked file in Access, including PDF, DOC, XLS, PPT?
3. How can I open a file with only one button or link whatever the file format is (e.g.
Any suggestions would be appreciated. I'm newbie in Access and VB coding, so please include samples if it's possible.