DWUTKA at marlow.com
DWUTKA at marlow.com
Fri Jan 2 17:26:38 CST 2004
He's not talking splash screen. Paul, just an FYI, don't be surprised with the replies to your post. It's a common confusion with Access developers. Many people hide the db window, which can be done from the tools menu, however, to hide the Access window itself requires the ShowWindow API. It's not very difficult to do, because Application.hWndAccessWindow (I think) is the method to retrieve the hWnd of the Access Application window....very handy, let's you do all sorts of things to the Access Window if you want. However, the reason for the confusion is that a lot of developers (and this is NOT meant to be deragotory), develop specifically for Access, so there is no need to remove the Access window, since it is the tool in which the .mdb's are written for. Ironically, hiding the Access window was the first VBA code I ever messed with, because when I started in Access (back in 99), I was using all macros, and procedures. Worked great for what I needed. But I was creating a db for completely computer illiterate personnel, so I wanted as few things on the screen as possible, and there just was no way to hide the Access Window through non-VBA methods. (I even tried our companies help desk, who immediately gave me instructions to hide the db window......That night I figured out how to get the code on the Access Web to work, and when I let the help desk know how to solve that particular issue, I was told to never call them again...go figure...) Drew -----Original Message----- From: Arthur Fuller [mailto:artful at rogers.com] Sent: Thursday, January 01, 2004 4:06 AM To: 'Access Developers discussion and problem solving' Subject: RE: AW: [AccessD] Hiding Main Access Window One way to do this is to create an image file having the same name as your application MDB but with a different extension and place it in the same directory as the MDB. Access will load this image instead of its native logo. I have never tried to create a one-pixel image file but I'm guessing that it would work too. Arthur -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of paul.hartland at fsmail.net Sent: Wednesday, December 31, 2003 1:45 AM To: Access Developers discussion and problem solving Subject: Re: AW: [AccessD] Hiding Main Access Window Sorry but I don't think I have explained correctly, when you first open Access that's the screen I want to hide I know I can hide database windows etc from Tools/StartUp. Lets say we go to START/PROGRAMS and click on Microsoft Access and you get the blank access screen from which you can creat a new database, open existing etc. That's the screen I want to hide, the actual Access screen. Sorry for any confusion. Paul Hartland Message date : Dec 31 2003, 09:39 AM >From : Helmut Kotsch To : Access Developers discussion and problem solving Copy to : Subject : AW: [AccessD] Hiding Main Access Window Paul, that's easy, even I can answer this one. Tools => Start..=> uncheck the "Show Database Window" Checkbox. I took this info from my installed German version of Access 2000, hope I translated the fieldnames alright. Regards and have a nice day. Helmut Kotsch -----Ursprüngliche Nachricht----- Von: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]Im Auftrag von paul.hartland at fsmail.net Gesendet: Mittwoch, 31. Dezember 2003 10:17 An: accessd Betreff: [AccessD] Hiding Main Access Window To all, I'm sure I have seen this somewhere but can't for the life of me remember where, I have an Access 2000 application that a few people have a shortcut to on their machines, which when opened opens the main Access window (as usual) and a switchboard. Is there anyway I can hide the main Access window so that the application looks similar to a Visual Basic application ? Thanks in advance for all your help. Paul Hartland Freeserve AnyTime - HALF PRICE for the first 3 months - Save £7.50 a month www.freeserve.com/anytime _______________________________________________ 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 Freeserve AnyTime - HALF PRICE for the first 3 months - Save £7.50 a month www.freeserve.com/anytime _______________________________________________ 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