I recently posted a thread about creating a custom ribbon bar, and thanks to everyone who helped me there, and since that
idea didn't work out 100% for me I now have a different idea on how to acomplish what I want, but still have questions on a
few issues with it.
The end resuly i'm trying to acomplish is to make my access DB "appear" as if its a standalone application. My previous
posts' idea was to create a custom "navigation" ribbon bar where each button would open a specific form (each form set to Pop
Up). I would then shrink the Access window to just display the ribbon. But I soon figured that when the Access window is
shrunken smaller than a certain size, the ribbon (and office button) "hides" to display more of the forms or whatever else is
open. I concluded that this problem was unavoidable.
My two other ideas are to create a navigational form (containing the buttons that would be on the custom ribbon). I would
then do one of two things. Regardless of which I choose they both present the same problem...
I can use the fSetAccessWindow function to "hide" or "minimize"the access window.
Set that navigational forms popup to "no" (all others still set to yes), maximize it inside the access window and resize the
access window to the same size as that form (the form is small enough where it would "hide" the ribbon and access button like
stated above when resizing the window) making it appear as if the access window is not present.
Now on to my question/problem...
I have an issue when opening reports with either of these ideas. I only have about 5 or so reports that will ever be opened,
and half are set to report view and the other half are set to preview view. If the report is preview, the report window is
opened in a super small size (about a 1 inch square), and if its opened in report view, the width is correct, but the height
is less than an inch high. I can rezise these manually to display correctly, but will have to do so each time they are
reopened. I am assuming that this has something to do with the size of the Access window being so small or minimized, because
if the Access window is regular the report size is regualr, and each report window shrinks as the Access window shrinks.
i tried some of the following with no avail...
docmd.movesize ,,,7200 (or whatever height) did nothing
Popup, Auto Center, Auto Resize, Fit to Page all set to "Yes"
Basically in short, is there anyway to set the window size to a specific value when opening the report? From what I
researched, movesize is what to use but I cant get it working. Any suggestions.
Another quick question...
In Access 02 there was an option for each form to have its own Task bar "button" I upgraded to 2007 and cannot find that same
option. Is it possible in 07? If so, how?