How to close Acess - Microsoft Access / VBA

RICHARD BROMBERG

I am writing a small application using Access 2000 and I am using a
Switchboard.
The last item in the switchboard is to be used to close the application..
I selected Exit Application from the dropdown list of functions and it does
close the application, but it leaves Access open.
What I want to do is exit the application and close Access.

I can do this (exit the application and close Access) by using a command
button. The code for this command button is :

Private Sub cmdQuit_Click()
DoCmd.Quit
End Sub

Can I set up the last item in the switchboard to work the same way?

Thanks

Jul 5 '06 #1

Subscribe Reply

3705

fredg

On Wed, 05 Jul 2006 17:31:33 GMT, RICHARD BROMBERG wrote:

I am writing a small application using Access 2000 and I am using a
Switchboard.
The last item in the switchboard is to be used to close the application..
I selected Exit Application from the dropdown list of functions and it does
close the application, but it leaves Access open.

What I want to do is exit the application and close Access.

I can do this (exit the application and close Access) by using a command
button. The code for this command button is :

Private Sub cmdQuit_Click()
DoCmd.Quit
End Sub

Can I set up the last item in the switchboard to work the same way?

Thanks

You're using the built-in Access switchboard?
One of the problems with it is that it's set up according to what the
switchboard manager designer thinks you should do, not according to
what it is you want to do.

Open the switchboard in design view.
Click on View + Code
Find the following 2 lines of code in the HandleButtonCli ck function:
Case conCmdExitAppli cation
CloseCurrentDat abase

Change it to:
Case conCmdExitAppli cation
DoCmd.Quit

Save and exit.

You might want to consider creating your own switchboard, using an
unbound form with command buttons.
You'll have more control over it's appearance and versatility.
Up-keep will be easier also.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Jul 5 '06 #2

gizmo

you could make a macro too i guess
fredg wrote:

On Wed, 05 Jul 2006 17:31:33 GMT, RICHARD BROMBERG wrote:

I am writing a small application using Access 2000 and I am using a
Switchboard.
The last item in the switchboard is to be used to close the application..
I selected Exit Application from the dropdown list of functions and it does
close the application, but it leaves Access open.

What I want to do is exit the application and close Access.

I can do this (exit the application and close Access) by using a command
button. The code for this command button is :

Private Sub cmdQuit_Click()
DoCmd.Quit
End Sub

Can I set up the last item in the switchboard to work the same way?

Thanks

You're using the built-in Access switchboard?
One of the problems with it is that it's set up according to what the
switchboard manager designer thinks you should do, not according to
what it is you want to do.

Open the switchboard in design view.
Click on View + Code
Find the following 2 lines of code in the HandleButtonCli ck function:
Case conCmdExitAppli cation
CloseCurrentDat abase

Change it to:
Case conCmdExitAppli cation
DoCmd.Quit

Save and exit.

You might want to consider creating your own switchboard, using an
unbound form with command buttons.
You'll have more control over it's appearance and versatility.
Up-keep will be easier also.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Jul 5 '06 #3

David W. Fenton

"gizmo" <gi*****@linkli ne.comwrote in
news:11******** **************@ v61g2000cwv.goo glegroups.com:

you could make a macro too i guess

Er, um, why?

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Jul 5 '06 #4

pedro8ae

Fred, you are a genious !!!!!!!!

fredg wrote:

On Wed, 05 Jul 2006 17:31:33 GMT, RICHARD BROMBERG wrote:

I am writing a small application using Access 2000 and I am using a
Switchboard.
The last item in the switchboard is to be used to close the application..
I selected Exit Application from the dropdown list of functions and it does
close the application, but it leaves Access open.

What I want to do is exit the application and close Access.

I can do this (exit the application and close Access) by using a command
button. The code for this command button is :

Private Sub cmdQuit_Click()
DoCmd.Quit
End Sub

Can I set up the last item in the switchboard to work the same way?

Thanks

You're using the built-in Access switchboard?
One of the problems with it is that it's set up according to what the
switchboard manager designer thinks you should do, not according to
what it is you want to do.

Open the switchboard in design view.
Click on View + Code
Find the following 2 lines of code in the HandleButtonCli ck function:
Case conCmdExitAppli cation
CloseCurrentDat abase

Change it to:
Case conCmdExitAppli cation
DoCmd.Quit

Save and exit.

You might want to consider creating your own switchboard, using an
unbound form with command buttons.
You'll have more control over it's appearance and versatility.
Up-keep will be easier also.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Jul 13 '06 #5

Similar topics

4800

class name acess?

by: Sergio del Amo Caballero | last post by:

I want to access div elemnent and make them visible or invisible with a condition. They belong to a particular class or not. I was reading the newsgroup old posting about classname acess and some links and i arrived to the conclusion that i can not access class Name with Mozilla. With Explorer i can acesss with document.all.className but i want visualize my web site in Opera 7.2, Mozilla 1.4 and Explorer 6.0. My code will be something like...

Javascript

3030

C# Client to acess a WebService in Java

by: Suresh | last post by:

Hi, Iam trying to develop a client in C# on .NET, that would acess a webservice written in Java.I dont know anything about what kind of WSDL would be required, how to set the web references programtically , dynamically during execution to pick a specified webservice( VS.NET provides a way to add the web refernce by right clicking on refernces icon, but this way is static)Is it possible to do so? Pleas help.

C# / C Sharp

1209

Saving at a restrict acess directory

by: Fabiano | last post by:

Please, i created a webpage that let's user upload a file to server. At my codebehind i need to save this file into a directory of another server (webfarm). The olny problem is that only some users can acess this directory. How can i do to send my credentials, this way be able to save at the directory? Tks in adv.

ASP.NET

1315

MS Acess

by: Rodrigo Ferreira | last post by:

How can i interligate my app with a DB in MS Acess? I don't know how to do that! Greetings.

ASP.NET

1249

Problem with Insert in to IP to Microsoft Acess by ASP

by: minhadd | last post by:

Hello Would Anyone help me ?? I want insert into Microsoft Acess visitor's IP by ASP. But It is not working ---------------------------------------------------------------------------------------------------------- NOT WORK

ASP.NET

2382

Acess Dynamically Created Elements

by: bradb | last post by:

Hello, I have a textbox with an empty span element (place holder) next to it. When the user adds some text to the text box, I create a checkbox in the empty span element. When I create the checkbox I create a unique ID for the checkbox and associate an OnClick event with it. When I proceede to check that checkbox, I get a javascript error stating that the id is not defined. This is a dynamically created element, but shouldn't the ID of...

Javascript

2012

can not acess memory at address ox0

by: gogo | last post by:

my C program crashes due to segfault . And on using gdb it shows message "can not acess memory at address ox0" what could be the possible problem. Program is vary complecated so i can not simple debug using my own debug statments. and PC's value is 0x00000 which is no way helpful for backtracking the problem. Sp please guide me .

C / C++

1515

Upload the data into acess database from excel file

by: Pk | last post by:

Hi, I want to download and upload the data from acess database into excel file or from excel to database. So how can i use "Excel.Application" to do this type of job. So please help me soon. Thanks Pk

ASP / Active Server Pages

1507

how to select latest updation from Ms Acess

by: sonasiva | last post by:

hai Iam creating my own website using ASP and MS ACESS ,iam new to ASP and SQL Please help me to write a query to finish my project. i have datas as follows in my database sno name companyname shares percentage date 1 aaa kroft 5000 5 1/1/2007 2 aaa kroft 10000 10 1/9/2007 if i click "name" link the deatils should...

Microsoft Access / VBA

8788

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

9476

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

9263

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

6053

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4570

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4825

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3279

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

2745

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2193

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General