Charlotte Foust
cfoust at infostatsystems.com
Wed Aug 4 11:00:26 CDT 2004
It's perfectly possible to turn off those features unless a command-line argument is passed when the database is open. I've done that on projects in order to leave myself a backdoor but remove any way for the user to get into the guts of the mdb. Charlotte Foust -----Original Message----- From: Paul Rodgers [mailto:Paul.Rogers at SummitMedia.co.uk] Sent: Tuesday, August 03, 2004 11:38 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Programmatically Hide the DATABASE Window Hi Charlotte It would be ideal if upon opening their Access database there was just a form that offered all the Users could need. I'd like them not to be going to tables and queries - and nor to be able to find how to get there. When you offered that neat piece of coding before, you reminded me of what I see as ideal. Of course one can make adjustmentments on Startup. But they quickly learn the Window/Unhide entrance. All the best paul -----Original Message----- From: Charlotte Foust [mailto:cfoust at infostatsystems.com] Sent: Tuesday, August 03, 2004 5:04 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Programmatically Hide the DATABASE Window Sorry, but I don't see how the user could use an app where they saw a form and nothing else. It is possible to float a form by shrinking and hiding the *main* Access window behind it, but it frankly isn't worth the trouble IMO. Charlotte Foust -----Original Message----- From: Paul Rodgers [mailto:Paul.Rogers at SummitMedia.co.uk] Sent: Tuesday, August 03, 2004 7:51 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Programmatically Hide the DATABASE Window Hi Charlotte I'm using your code and it works well, thank you. But, yes, I am trying to achieve something else, as you say. I want to give the user a form and nothing else - but I need to be able to go in and out myself to make adjustments et al. Is this something you could advise on please? Cheers paul -----Original Message----- From: Charlotte Foust [mailto:cfoust at infostatsystems.com] Sent: Tuesday, August 03, 2004 4:36 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Programmatically Hide the DATABASE Window I don't quite understand what you're trying to do. The database window is only visible from within the application, so you put the code into public functions and create an autokey to trigger it, if that's what you're trying to accomplish. If you're talking about hiding something else, like the main window, that's an entirely different thing. Charlotte Foust -----Original Message----- From: Paul Rodgers [mailto:Paul.Rogers at SummitMedia.co.uk] Sent: Monday, August 02, 2004 11:56 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Programmatically Hide the DATABASE Window Darren That is good ... but how can I hide Window/Unhide? I suppose I could put Charlotte's public function in another db and trigger from there? Sorry, so many questions to begin (or end) your day. Hope the winter's ok there. Cheers paul -----Original Message----- From: Darren DICK [mailto:d.dick at uws.edu.au] Sent: Monday, August 02, 2004 11:12 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Programmatically Hide the DATABASE Window Hi Paul In Charlotte's code below replace DoCmd.RunCommand acCmdWindowhide with DoCmd.RunCommand acCmdWindowUnhide ----- Original Message ----- From: "Paul Rodgers" <Paul.Rogers at summitmedia.co.uk> To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Sent: Monday, August 02, 2004 5:51 PM Subject: RE: [AccessD] Programmatically Hide the DATABASE Window > Interesting, Charlotte, but what happens when you want to Unhide so > you can > work on the database? > > I always use the StartUp checkboxes myself - but then I am usually > always around when the databases are being used. > > I can see it there are many times when it would be useful to have only > the required form showing, and Unhide unavailable too. So I will await > keenly for an answer. All the best > > paul > > -----Original Message----- > From: Charlotte Foust [mailto:cfoust at infostatsystems.com] > Sent: Friday, July 30, 2004 7:09 PM > To: Access Developers discussion and problem solving > Subject: RE: [AccessD] Programmatically Hide the DATABASE Window > > > Try this: > > Public Function HideDBWindow() > On Error GoTo HideDBWindow_err > ' select a tab in the Database Window > DoCmd.SelectObject acTable, , True > ' Hide the database window > DoCmd.RunCommand acCmdWindowHide > HideDBWindow_exit: > Exit Function > HideDBWindow_err: > MsgBox Err.Description & " (#" & Err & ")" > Resume HideDBWindow_exit > End Function > > Charlotte Foust > > > -----Original Message----- > From: Greg Smith [mailto:GregSmith at starband.net] > Sent: Friday, July 30, 2004 9:46 AM > To: accessd at databaseadvisors.com > Subject: [AccessD] Programmatically Hide the DATABASE Window > > > Hello everyone, again. It's FRIDAY! > > Pretty much got the menu bar working (one issue with the "menu Bar"'s > control box not showing up after being disabled then enabled...but > that's not the point here). > > I want to hide the main database window (the one with the queries, > tables, forms, etc., to be exact) on startup, but not using the > Startup's checkbox, but through vb. The DBA Archives dance around the > issue, but I can't find where it's addressed. Is there a way to do > this through code or am I stuck with using the checkbox in the Startup > menu? I'm using Access97 in this app. > > Thanks! > > Greg Smith > gregsmith at starband.net > > > -- > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com