Search results

It's not really your question, but "modal" is not really needed for acCmdAppMinimize method :) (but it IS needed for the API). Edited: BUT... I just noticed, that if you DO set it also to Modal, users can't right click the Taskbar icon of the app to restore the hidden Access! They can't close...

I've actually tried it with both. Surprisingly, Autoexec runs a bit faster, but either way I see Access for a second before it's minimized (I would like to NOT see Access :) I prefer not to have an Autoexec macro, it just seems cheesy with all the code I write :D Is there such a thing as an...

I wonder if the following might be the solution for the notorious "how do I view reports while Access is minimized" problem? http://support.microsoft.com/kb/209938 maybe someone has the time to test it? Thanks!

Thanks, I'm already learning it (and want to move up to getting a job in .Net development, but that'll take time). Thing is, for this project I really can't change venue, it has to be Access 2000. And I am so close :) I really don't see how it's not possible, I'm sure it's a simple feature that...

I already have this working by means of: doCmd.RunCommand acCmdAppMinimize in Form_Load (or Form_Open) events. This works great to hide Access and only display the main form (like a standalone app). But I have 2 issues: 1. The PopUp form (main or "switchboard" if you like) opens, then Access...

I have a similar problem, even without multiples. I just have 1 app which opens a main form and hides Access (acCmdAppMinimize). It always opens with the form not in focus, so if there are other programs running, the app opens in the background and user has to Alt-Tab or taskbar to it.

Ok, thanks for providing those icons. They helped me to realize that it's not the code, it's my icon! Your icons work in my app (proper icons) and my bitmap with extension changed to ".ico" does not :) I'll have to design a proper icon in Photoshop and save it as such. Thanks for your help. It...

Well, considering I tried MS code in its unchanged state and it didn't work either, I don't really think it's "user error" :) Such a simple, obvious feature and they couldn't think of adding it until what, 2002? 2003? No wonder people are "surprised" by the housing market crash etc. :D Maybe...

Hi. I tried this code, as well as some other similar methods, one of which provided by Microsoft. Somehow it doesn't work for me. No error messages, but the icon doesn't change. BTW, I like your statement of making the icon path "portable" so that one doesn't have to change path during...

I found answer to my question through further tinkering. I wrote a Public Funtion fnMaximize() with only 1 line: "docmd.maximize" in a separate (not behind-form) module (I have it where I also have the fnCloseReport function). Then, if I use this function in the On_Open event of each report...

Ok, I finally have it working the way I like. It's really slick - the main form (set to "PopUP" and with docmd.runcommand accmdappminimize line in the On_Open event) opens with customized icon (in titlebar and in windows taskbar) and behaves like a standalone program (you only see Access the...

Thanks, Bob. It sure looks slick, though. I guess our answer is: we should use VB.NET or some real environment and not Access :) Or maybe Microsfot could redesign Access to allow final apps to become stand-alone (or "almost" stand-alone). no end to wishing... :D

Hi. I tried your method and it works, of course, BUT :) 1. while the report is open, users have access to the Access window. I know, I can disable many features, but isn't there a way around that, maybe somehow showing the report maximized or really even adding a PopUp property as someone...

This works great, actually, much better for my purposes than the API method. Access is hidden and the form can still be minimized/restored from the taskbar and switched to from other apps via the Taskbar. I also have a Show/Hide access toggle button on my form, for which I have a Select Case...

No, i mean the Access container window, they are 2 different things. Thanks.

but how do you keep the form on screen. when i tried this, it minimized everything, including the form (which is set to modal/popup). my code works to hide/unhide Access window, but not with you MINIMIZE suggestion. Am I leaving something out?

Hey, thanks! It works, even if I put the docmd.RunCommand acCmdAppMinimize line into my main form's OnOpen event (you see Access for a sec, then it's minimized). And I don't even have to close my main form when a dialog box opens (a custom form opened via acDialog argument of the open form...

painful, but... no API! Could you please provide sample code? I like the fact that Access could still show up in Taskbar. changing window's modality could be handled from code, could it not? Thx!

we need to distinguish between the Database window (that shows your tables, forms, etc. This DB window is inside the Access window). The Access Window, is the main container form (like that of Word or Excel which contains the documents). This window has the toolbars and menus, etc. it's...

No, you can also actually hide the Access window, you have to search for apiShowWindow function. I'm not going to describe it, it's available on MSDN and on the Access Web. For the method to work the calling form must be in both MODAL and POPUP mode. The only drawback: once hidden, none of the...