Creating an idiot proof search form

[stefan-west1@hotmail.com]

Hi all,

I am fairly new to access but am just trying to create a fairly simple search thing.

Basically I have created a table and have made a form to use to search for specific records. However there are a few things I want to be able to do and I assume the easiest way is with a macro and using a button to run the macro.

1. When I press search and it runs a query I have to manually close the query before I can search again how do I stop this

2. Is it possible that I can press the search button, it runs the query, opens the results in a report and then closes the query again so it can be used again?

3. How can I make it so that for example I could have this form running on a computer in an office so anyone can use it to find a certain record but cannot actually touch the records. Basically so they can open a file, it comes up with the search form, the type the details they want, the results come up in the report as asked above and they cant actually get to the main table or query containing the records.

4. Finally if the above is possible is there a way to do that without any toolbars or anything so that it is literally just the form and the report they can see

I know I'm asking a lot but it is essentially one question that kind of leads on depending if the previous is possible.

Many thanks in advance

[June7]

It is my belief there is no such thing as 100% idiot proof.

1. Should not allow users to interact directly with tables and queries. Use forms and reports.

2. Do not have to 'open' query before running report. Just open the report that uses the query as RecordSource.

3. & 4. Review
http://office.microsoft.com/en-us/ac...010342026.aspx
Google: Access 2010 securing database
http://office.microsoft.com/en-us/ac...010341741.aspx
http://forums.aspfree.com/microsoft-...tc-324677.html

File tab > Options > Current Database > make choices as appropriate.
Uncheck: Use Access Special Keys, Display Navigation Pane, Allow Full Menus, Allow Default Shortcut Menus
Be aware that holding down Shift key while database opens will override these option settings, which is what you as developer will do when opening so you can do design edits.

It is possible to programmatically hide the Access application window frame.