|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 16th, 2006, 03:46 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
Report Views...
When you open a form, how do you set it to automatically bring up a report
centered in a full page, with 150% Zoom? I use Access 2000. Thanks! 
|
|
#2
August 16th, 2006, 06:14 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Report Views...
I can't say for sure on 2000, but on 2003 there's an option "startup" under
the "tools" menu that let's you spedify what to open on startup. CW "Heidelberg" wrote: When you open a form, how do you set it to automatically bring up a report centered in a full page, with 150% Zoom? I use Access 2000. Thanks!
|
|
#3
August 16th, 2006, 06:15 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Report Views...
Ignore my previous post as the babblings of a complete idiot.
"Cheese_whiz" wrote: I can't say for sure on 2000, but on 2003 there's an option "startup" under the "tools" menu that let's you spedify what to open on startup. CW "Heidelberg" wrote: When you open a form, how do you set it to automatically bring up a report centered in a full page, with 150% Zoom? I use Access 2000. Thanks!
|
|
#4
August 16th, 2006, 08:06 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Report Views...
Heidelberg,
You can use a VBA procedure on the Open event of your form. I imagine it might look something loke this... DoCmd.OpenReport "NameOfYourReport" DoCmd.Maximize DoCmd.RunCommand acCmdZoom150 -- Steve Schapel, Microsoft Access MVP Heidelberg wrote: When you open a form, how do you set it to automatically bring up a report centered in a full page, with 150% Zoom? I use Access 2000. Thanks!
|
|
#5
August 17th, 2006, 03:37 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Report Views...
Hi Steve!
I used the following VBA: Option Compare Database Private Sub Report_Open(Cancel As Integer) DoCmd.OpenReport "rptAllAssessmentsParameterBySchool" DoCmd.Maximize DoCmd.RunCommand acCmdZoom150 End Sub However, I get a Run-time error 2585 This action can't be carried out while processing a form or report event. What am I doing wrong? Thanks for your help! "Steve Schapel" wrote: Heidelberg, You can use a VBA procedure on the Open event of your form. I imagine it might look something loke this... DoCmd.OpenReport "NameOfYourReport" DoCmd.Maximize DoCmd.RunCommand acCmdZoom150 -- Steve Schapel, Microsoft Access MVP Heidelberg wrote: When you open a form, how do you set it to automatically bring up a report centered in a full page, with 150% Zoom? I use Access 2000. Thanks!
|
|
#6
August 18th, 2006, 08:33 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Report Views...
Hi Cheese whiz,
Thanks for thinking about me. I've seen the good work you did in other messages. Do you know why I get an error message when I followed Steve's suggestion? "Cheese_whiz" wrote: Ignore my previous post as the babblings of a complete idiot. "Cheese_whiz" wrote: I can't say for sure on 2000, but on 2003 there's an option "startup" under the "tools" menu that let's you spedify what to open on startup. CW "Heidelberg" wrote: When you open a form, how do you set it to automatically bring up a report centered in a full page, with 150% Zoom? I use Access 2000. Thanks!
|
|
#7
August 19th, 2006, 10:04 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Report Views...
Any more ideas on this?
I tried the code at "on open" in the report. It maximized, but I get a message that says "The command or action Zoom 150% isn't available now." Funny, hehe. A little tip. Maximize on open and minimize on close on all my reports has taken away most of my frustration regarding max/min with reports. "Heidelberg" skrev: Hi Steve! I used the following VBA: Option Compare Database Private Sub Report_Open(Cancel As Integer) DoCmd.OpenReport "rptAllAssessmentsParameterBySchool" DoCmd.Maximize DoCmd.RunCommand acCmdZoom150 End Sub However, I get a Run-time error 2585 This action can't be carried out while processing a form or report event. What am I doing wrong? Thanks for your help! "Steve Schapel" wrote: Heidelberg, You can use a VBA procedure on the Open event of your form. I imagine it might look something loke this... DoCmd.OpenReport "NameOfYourReport" DoCmd.Maximize DoCmd.RunCommand acCmdZoom150 -- Steve Schapel, Microsoft Access MVP Heidelberg wrote: When you open a form, how do you set it to automatically bring up a report centered in a full page, with 150% Zoom? I use Access 2000. Thanks!
|
|
#8
August 20th, 2006, 02:27 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Report Views...
Thanks for the tip...
It can get frustrating at times. Did you get a Error Run-time 2585? "Claes D" wrote: Any more ideas on this? I tried the code at "on open" in the report. It maximized, but I get a message that says "The command or action Zoom 150% isn't available now." Funny, hehe. A little tip. Maximize on open and minimize on close on all my reports has taken away most of my frustration regarding max/min with reports. "Heidelberg" skrev: Hi Steve! I used the following VBA: Option Compare Database Private Sub Report_Open(Cancel As Integer) DoCmd.OpenReport "rptAllAssessmentsParameterBySchool" DoCmd.Maximize DoCmd.RunCommand acCmdZoom150 End Sub However, I get a Run-time error 2585 This action can't be carried out while processing a form or report event. What am I doing wrong? Thanks for your help! "Steve Schapel" wrote: Heidelberg, You can use a VBA procedure on the Open event of your form. I imagine it might look something loke this... DoCmd.OpenReport "NameOfYourReport" DoCmd.Maximize DoCmd.RunCommand acCmdZoom150 -- Steve Schapel, Microsoft Access MVP Heidelberg wrote: When you open a form, how do you set it to automatically bring up a report centered in a full page, with 150% Zoom? I use Access 2000. Thanks!
|
|
#9
August 20th, 2006, 03:01 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Report Views...
I get 2046.
/Claes "Heidelberg" skrev: Thanks for the tip... It can get frustrating at times. Did you get a Error Run-time 2585? "Claes D" wrote: Any more ideas on this? I tried the code at "on open" in the report. It maximized, but I get a message that says "The command or action Zoom 150% isn't available now." Funny, hehe. A little tip. Maximize on open and minimize on close on all my reports has taken away most of my frustration regarding max/min with reports. "Heidelberg" skrev: Hi Steve! I used the following VBA: Option Compare Database Private Sub Report_Open(Cancel As Integer) DoCmd.OpenReport "rptAllAssessmentsParameterBySchool" DoCmd.Maximize DoCmd.RunCommand acCmdZoom150 End Sub However, I get a Run-time error 2585 This action can't be carried out while processing a form or report event. What am I doing wrong? Thanks for your help! "Steve Schapel" wrote: Heidelberg, You can use a VBA procedure on the Open event of your form. I imagine it might look something loke this... DoCmd.OpenReport "NameOfYourReport" DoCmd.Maximize DoCmd.RunCommand acCmdZoom150 -- Steve Schapel, Microsoft Access MVP Heidelberg wrote: When you open a form, how do you set it to automatically bring up a report centered in a full page, with 150% Zoom? I use Access 2000. Thanks!
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
