Resizing report windows

[buratti]

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.
or
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?

 

[buratti]

Nobody? I added a lot more information than I needed in that post. The question can be summarized as: How can I set the window size of a report in VBA when opened in report or preview view?

 

[ghudson]

Have you tried something like this in the reports on open event...

    MsgBox "InsideHeight = " & InsideHeight & vbCrLf & vbLf & "InsideWidth = " & InsideWidth
    InsideHeight = 3855
    InsideWidth = 7695

I use that to force the size of my forms.

 

[buratti]

Just tried that and I dont think it works for reports. The message boxs' inside values came out null and the actual setting of them did nothing. When trying to write that code for reports, the Insideheight and Insidewidth options are not available in the "autocomplete" when typing of the code. It gave no errors however when ran, just no results.