Exit Button for Switchboard in Access 2003

[gls007]

I am building a database and trying to make it simple for others to use. I am attempting two things and am not sure how to complete them. I would like to add a search for single record choice and an exit button that would close the database. Any guidance would be appriciated.

Gary

[PercyPercy]

I am building a database and trying to make it simple for others to use. I am attempting two things and am not sure how to complete them. I would like to add a search for single record choice and an exit button that would close the database. Any guidance would be appriciated.

Gary

Gary,

Are you using a "switchboar d?" If you are, there is already a feature for the "quit" or "exit" already built in. Assuming you are using a switchboard, try this:


1) Under the TOOLS menu, go to DATA BASE UTILITIES, and select SWITCHBOARD MANAGER


2) The Switchboard Manager window will open. Select the Switchboard that you want to contain your quit/exit button, and select the EDIT button


3) The Edit Switchboard Page window will open. Select the NEW button


4) The Edit Switchboard Item window will open. There will be three fields here.

A) In the "Text" field, type QUIT or EXIT or CLOSE DATA BASE, whatever you want to call the thing

B) In the "Command" field, pull down the drop down list and select "Exit Application"

C) In the "Switchboar d" field, pull down the menu and select the Switchboard you want this to appear on.

D) Select the OK button


Then select the CLOSE button on the Edit Switchboard Page, and the CLOSE button on the Switchboard Manager


NOW for the "searchable " thing... you need to do a query with a key word parameter.

Decide what you want them to search on -- a name, an item number, product code -- or something like that. In my data base, I have them search by a key word in the publication title

Then, in your query, under that column --in the CRITERIA row, add this text:

Like "*" & [Enter a word or part of a word as it appears in the publication title] & "*"

Now when they go to open the form, they are prompted with the text to "Enter a word or part of a word as it appears in the publication title" -- note that they don't have to enter the entire word, just something that appears in the title. Play around with it and you'll see.

I've added an "Access Tip" on my main switchboard page which tells the users "If you are prompted to enter a word or a word part of a title, but wish to see "all records," leave the field blank and select "OK." All records will be displayed in the result.


Hope this helps!

[gls007]

Thank you for this information. I wish my university had taught reading then I would have already known about the exit command :o .

As for the search function have you added this to a switchboard? I have the switchboard open full so that the users cannot see the query/report/table screen.

Gary

[PercyPercy]

Thank you for this information. I wish my university had taught reading then I would have already known about the exit command :o .

As for the search function have you added this to a switchboard? I have the switchboard open full so that the users cannot see the query/report/table screen.

Gary

Yeah -- I hate that reading thing too. I usually struggle on my own... then pick-up the manual and wow -- there it is! *S*

Actually, that parameter is in the query the a form or report is based on. The form or report is located on the Switchboard. When they clock on the form or report they want to open -- they get prompted with the little input window.

[gls007]

The search method you showed me works like a charm. My confusion ( a normal thing for me) is how to make the form open in the switchboard. I get the search box you told me about when I run the query. I created a form called search for the switchboard. I guess what I do not know how to do is cause the query to fill out the form :o