MSGROUPS.NET | Search | Post Question | Groups | Stream | About | Register

create switchboard button that will close program entirely

  • Follow


I have a switchboard button that closes the database but leaves Access
open. Is there a way I can have the button close the database and
Access with one click?
0
Reply robnsd 9/2/2007 8:39:17 PM 

Dear robnsd:

Try the following code:

DoCmd.Quit

HTH
-- 
Fred Boer - Amateur Access Enthusiast
Interests: Library software / Z39.50 / Web Services
Freeware Small Library Application available here: 
http://www3.sympatico.ca/lornarourke/


"robnsd" <robnsd@sbcglobal.net> wrote in message 
news:1188765557.922703.326790@19g2000hsx.googlegroups.com...
>I have a switchboard button that closes the database but leaves Access
> open. Is there a way I can have the button close the database and
> Access with one click?
>
0
Reply Fred 9/2/2007 9:03:38 PM 

Dear Markitos:

Open the switchboard form in design view.
Select the command button.
Press "Alt-Enter", or using the main menu choose View>Properties and click 
on the "Event" tab.
Navigate to the "On Click" field - there should be "[Event Procedure]" 
displayed in this field. Clicking into this field will reveal some ellipses 
(...) on the right of the field.
Click on these.
The IDE code window will open, and you should be in a sub-routine.
I can't be sure what code will be there, but probably you will see the 
following line:

docmd.close

Replace that line with "Docmd.quit".

Post back if you need more help!

Cheers!
Fred



"Markitos" <Markitos@discussions.microsoft.com> wrote in message 
news:02826F11-C3B1-4C5A-8003-C9071FC7E0C2@microsoft.com...
> Where would the command go? >thanks-
>
> "Fred Boer" wrote:
>
>> Dear robnsd:
>>
>> Try the following code:
>>
>> DoCmd.Quit
>>
>> HTH
>> -- 
>> Fred Boer - Amateur Access Enthusiast
>> Interests: Library software / Z39.50 / Web Services
>> Freeware Small Library Application available here:
>> http://www3.sympatico.ca/lornarourke/
>>
>>
>> "robnsd" <robnsd@sbcglobal.net> wrote in message
>> news:1188765557.922703.326790@19g2000hsx.googlegroups.com...
>> >I have a switchboard button that closes the database but leaves Access
>> > open. Is there a way I can have the button close the database and
>> > Access with one click?
>> >
>>
>>
>>
0
Reply Fred 9/21/2007 6:03:00 PM
microsoft.public.access 16776 articles. 72 followers.

2 Replies
476 Views

(page loaded in 0.066 seconds)

Similiar Articles:

create switchboard button that will close program entirely ...
I have a switchboard button that closes the database but leaves Access open. Is there a way I can have the button close the database and Access with o...

Linking Switchboard button to a .doc file - microsoft.public ...
create switchboard button that will close program entirely ... Linking Switchboard button to a .doc file - microsoft.public ... create switchboard button that will close ...

Adding a command button to a switchboard - microsoft.public.access ...
create switchboard button that will close program entirely ... Adding a command button to a switchboard - microsoft.public.access ... create switchboard button that will ...

Creating a macro to search for a wildcard entry - microsoft.public ...
create switchboard button that will close program entirely ... Creating a macro to search for a wildcard entry - microsoft.public ... create switchboard button that will ...

Trying to Build a Main Menu form with Command Buttons - microsoft ...
create switchboard button that will close program entirely ... Trying to Build a Main Menu form with Command Buttons - microsoft ... create switchboard button that will ...

Macro to close a program - microsoft.public.access
create switchboard button that will close program entirely ... Creating a macro to search for a wildcard entry - microsoft.public ... create switchboard button that will ...

OnClose Event and DoCmd.Close acForm - microsoft.public.access ...
create switchboard button that will close program entirely ... OnClose Event and DoCmd.Close acForm - microsoft.public.access ... create switchboard button that will close ...

Can I delete my switchboard and make a new one? - microsoft.public ...
create switchboard button that will close program entirely ... How do I make a link open in a program rather than a my browser ... create switchboard ... create a ...

Can't use SendKeys to close MSPAINT - microsoft.public.vb ...
create switchboard button that will close program entirely ... Can't use SendKeys to close MSPAINT - microsoft.public.vb ... create switchboard button that will close ...

Commands on a switchboard... - microsoft.public.access
create switchboard button that will close program entirely ... Dear Markitos: Open the switchboard form in design view. Select the command button.

create switchboard button that will close program entirely ...
I have a switchboard button that closes the database but leaves Access open. Is there a way I can have the button close the database and Access with o...

Linking Switchboard button to a .doc file - microsoft.public ...
create switchboard button that will close program entirely ... Linking Switchboard button to a .doc file - microsoft.public ... create switchboard button that will close ...

Create and use a switchboard - Access - Office.com
Repeat steps 2 through 3 for each secondary switchboard you want to create, and then click Close. ... Click the Microsoft Office Button; Click Access Options. Click ...

Microsoft Access Switchboard Form - creating a menu driven ...
There are several ways to create an Access Switchboard form and versions up to and ... The Exit button will simply close the database altogether. The other buttons will ...

MS Access: Create a switchboard item that closes down Access 2007
... open...it does not close down the Access application. Answer: There are a number of ways to create a Switchboard ... click on the Edit button. Then create a new Switchboard ...

7/22/2012 7:14:22 AM


Reply:
Privacy Policy | All Times Are GMT(UTC) | powered by