Hi,
I am trying to build a search page. User enter text (File Description). User can enter all or any word that match with the File Description. How do I write a "Select command with the filter" that can pull all of information about that file (like fileName, fileAuthor, dateCreated,...) I have all of these info in my db (I use MS Access 97). My files are crated in MS word, therefore I have page number of it too. Each page I have pageDescription for it. How do I display it like this:
-----
Your results:
FileId FileName Author DateCreated Page# PageDescription
1023 test.doc me 11/02/00 1 Index
2 Basic Knowlege
3 Test Process
1024 cold.doc ASAP 11/03/00 1 Intro
.
.
.
1026
...
Any help will be really appreciated
Thanks
GH
I am trying to build a search page. User enter text (File Description). User can enter all or any word that match with the File Description. How do I write a "Select command with the filter" that can pull all of information about that file (like fileName, fileAuthor, dateCreated,...) I have all of these info in my db (I use MS Access 97). My files are crated in MS word, therefore I have page number of it too. Each page I have pageDescription for it. How do I display it like this:
-----
Your results:
FileId FileName Author DateCreated Page# PageDescription
1023 test.doc me 11/02/00 1 Index
2 Basic Knowlege
3 Test Process
1024 cold.doc ASAP 11/03/00 1 Intro
.
.
.
1026
...
Any help will be really appreciated
Thanks
GH