Nov 15, 2000 To resize it, if you could use thje Windows API function MoveWindow, using the hwnd property of your form. (or how to use them) Do you have any code which might enable me to access the Application Window. RE: Set the size of the application window. MoGryph (Programmer. You can find out a lot about different API calls from VB/VBA there. Welcome to the p2p.wrox.com Forums. You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free. Thank you John, Your solution works fine for forms and the database window. What I wanted was to get rid of the Access application window. Thanks to your sample solution I think I have found a solution to my problem. This is what I have done: ' Select the Access application window AppActivate ('Microsoft Access') '. And minimize it RunCommand acCmdAppMinimize ' Set focus back to the form I started from Me.SetFocus When I want to restore the application window I do this: ' Restore the Access application window AppActivate ('Microsoft Access') RunCommand acCmdAppRestore Me.SetFocus Best Regards, Hans Hansson. If you have ever desired to write a program in MS Access, a must for deploying to users is to hide the MS Access window for the database. Hiding the MS Access window will give the program you spent so much time on that ‘real’ feel when a user accesses it. In my opinion, this is almost a must in deploying MS Access programs and consider it part of my working toolkit. So the example I’ve provided below is a working copy (as always), but to be honest I had to scale this one down quite a bit. You can perform this operation 100 different ways, so take the time to understand how it works, and I’m quite confident if you have figured out how to write a program in MS Access, you can figure out how to tweak the below and attached. [download id=”8″ format=”1″] Hide the MS Access Window Ok, so this solution is put together from a couple of different components. You should be able to tailor this solution to your own after you get it implemented, it really isn’t too complicated once you get it added. In my example, it is comprised of 3 areas. [bullet_list icon=”check”] • The VBA function to hide the MS Access Window • The macros to be called to hide and restore the window • The form in which I will call the macros from [/bullet_list] VBA Function to Hide the MS Access Window Below is a set of three functions that work in conjunction, and is where all the magic takes place in the act of hiding and restoring the MS Access window. To note, in my example I am calling the function via macros, but you can just as easily call the fSetAccessWindow ( ) function directly from VBA. Or another option would be to write a sub routine that calls each of the available options in the function, the choice is all yours. Vba Resize ImageEnd Function Calling the Hide & Restore Procedures Ok, now that you have the functions in place you need to call them in order for them to work. In my example file, I am using them through a macro to hide and restore the MS Access window. 3m electronic article surveillance system manual. In order to hide the MS Access window within the macro, I’m just calling the function from within using the following: fSetAccessWindow ( 'Minimize', False, False ) Likewise, in order to restore the MS Access window after being hidden. Access Vba Resize Form WindowAccess Vba Resize Application Windows PhoneAgain, I’m just calling the function using the following: fSetAccessWindow ( 'Show', False, False ) In my example, these two macros are being called from within the form open and close properties. If you open the form, the MS Access window will hide, and when you close the form the MS Access window will restore. Important NOTE! I’d feel bad if I didn’t tell you this, so here we go. An important note that I always seem to forget myself is to RESTORE the window to a visible state before the user exits out the program. So with this said, make sure that you have good accountability for this within your MS Access program. Magix video easy 5 hd pl keygen for mac.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |