Search results for query: *

I'm going to give it a whirl. Thank you for your help

I think 1 field in each table. Files Table-Description Document Table- Title of Document Stored Files-Box Label I'm cheering for the simple side.

That is good......we just need to add the department and the file description. When I look at your image it looks so simple, am I making this more complicated in my head than it needs to be?

I should have added above that I also want them to put in Check Vouchers and be able to find out what department is responsible and how long they need to be kept.

I'm not doing a very good job at explaining myself-sorry. Files Table: File Name -Accounts Payable Records Description - Records Documenting....... Document Table: Title of Document - Check Vouchers File Name - Accounts Payable Records Date of...

Thank you everyone for your assistance. Duane-there are tables for types of files, documents that are in the files, stored files (by box #) destroyed files and a table that has the departments-12 of them. There are some people in the office that are a bit challenged when it comes to anthing...

I have 3 books here: Access VBA, Access 2007 & Access 2007 VBA for Dummies (last resort)..... I have read and read. I guess my problem is I don't know exactly what it is I'm looking for, I cant find anything that says "here is how you search your entire database". I don't have a problem working...

Any ideas on where I could find that expert?

I have a File Retention DB that needs to be easily used by all employees. I want a search function on the main page that they can type a keyword in and search the entire database. I have 5 seperate tables; I would like for the search to automatically search ALL of them and bring back all results...