File Search by keyword

[avenger619]

Hello everyone,

I have search the web and came across something pretty similar to what am looking for (http://access.mvps.org/access/modules/mdl0051.htm), unfortunately this database sample does not work with my Access 03, so I cant really play with it.

What I want to do is have 3-4 Paths save on my form to folders on our office server, this is were we keep client files. I like to have the ability to search for individual folders by either client ID or name or even partial name if possible too, knowing that it may display more than one folder for the employee to pick and open.

I have included a picture of the form I have in mind. Can anyone help or convert that database for me to use? Help is appreciated. Thanks

 

[avenger619]

So I found something actually even better, check out this post by John Big Booty ( http://www.access-programmers.co.uk/forums/showthread.php?t=188663) db sample.

This is almost perfect if only the search results could be displayed for folder paths on my network were I keep client files and be able to search by file name or id.

Can anyone help with tweaking this modification?

Thanks

 

[avenger619]

Can anyone help with this?

I would appreciate very much. Thanks