I'd like to add a button to a form that will close the database that is currently open but leaves Access open. I can program a button to exit the application, close a specific form or the current form, but not one that will shut the database down while leaving the application open.
Thoughts?
James
Fri, 17 May 2002 03:00:00 GMT
fred #2 / 3
Button to close DB, but leave Access open....
In the Exit button's OnClick event:
Private Sub CmdExit_Click() CloseCurrentDatabase End Sub
Fred
Quote:
> I'd like to add a button to a form that will close the database that is > currently open but leaves Access open. I can program a button to exit the > application, close a specific form or the current form, but not one that > will shut the database down while leaving the application open.
> Thoughts?
> James
Fri, 17 May 2002 03:00:00 GMT
JNJ #3 / 3
Button to close DB, but leave Access open....
Duh -- thanks!
James
Quote:
> In the Exit button's OnClick event:
> Private Sub CmdExit_Click() > CloseCurrentDatabase > End Sub
> Fred
> > I'd like to add a button to a form that will close the database that is > > currently open but leaves Access open. I can program a button to exit the > > application, close a specific form or the current form, but not one that > > will shut the database down while leaving the application open.
Button to close DB, but leave Access open....