467,927 Members | 1,954 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,927 developers. It's quick & easy.

Opening report in design mode

I have a need to open a report in design mode immediately before opening it
in preview, to change the Minimum and Maximum scale on an axis on a chart.

This results in a flash of the report in design mode just before it is
opened in preview mode.

Is there any way to open it in design mode hidden?

Jeff
Nov 12 '05 #1
  • viewed: 5064
Share:
4 Replies
Try:
DoCmd.OpenReport "MyReport", acViewDesign, WindowMode:=acDialog
Setting its Visible property should make it show up later.

Turning Echo off would be the other alternative.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Jeff" <je************@asken.com.au> wrote in message
news:Rv******************@news.optus.net.au...
I have a need to open a report in design mode immediately before opening it in preview, to change the Minimum and Maximum scale on an axis on a chart.

This results in a flash of the report in design mode just before it is
opened in preview mode.

Is there any way to open it in design mode hidden?

Jeff

Nov 12 '05 #2
Thank Allen

The WindowMode didn't work, but the Echo works beautifully.

Jeff

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:40***********************@freenews.iinet.net. au...
Try:
DoCmd.OpenReport "MyReport", acViewDesign, WindowMode:=acDialog
Setting its Visible property should make it show up later.

Turning Echo off would be the other alternative.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Jeff" <je************@asken.com.au> wrote in message
news:Rv******************@news.optus.net.au...
I have a need to open a report in design mode immediately before opening

it
in preview, to change the Minimum and Maximum scale on an axis on a chart.
This results in a flash of the report in design mode just before it is
opened in preview mode.

Is there any way to open it in design mode hidden?

Jeff


Nov 12 '05 #3
Darn: should have been acHidden, of course.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Jeff" <je************@asken.com.au> wrote in message
news:sn******************@news.optus.net.au...
Thank Allen

The WindowMode didn't work, but the Echo works beautifully.

Jeff

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:40***********************@freenews.iinet.net. au...
Try:
DoCmd.OpenReport "MyReport", acViewDesign, WindowMode:=acDialog
Setting its Visible property should make it show up later.

Turning Echo off would be the other alternative.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Jeff" <je************@asken.com.au> wrote in message
news:Rv******************@news.optus.net.au...
I have a need to open a report in design mode immediately before
opening
it
in preview, to change the Minimum and Maximum scale on an axis on a

chart.
This results in a flash of the report in design mode just before it is
opened in preview mode.

Is there any way to open it in design mode hidden?

Jeff



Nov 12 '05 #4
That wasn't the problem. It said the named argument was incorrect. To my
knowledge there is no such argument to opening a report! Is there?

Jeff

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:40***********************@freenews.iinet.net. au...
Darn: should have been acHidden, of course.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Jeff" <je************@asken.com.au> wrote in message
news:sn******************@news.optus.net.au...
Thank Allen

The WindowMode didn't work, but the Echo works beautifully.

Jeff

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:40***********************@freenews.iinet.net. au...
Try:
DoCmd.OpenReport "MyReport", acViewDesign, WindowMode:=acDialog
Setting its Visible property should make it show up later.

Turning Echo off would be the other alternative.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Jeff" <je************@asken.com.au> wrote in message
news:Rv******************@news.optus.net.au...
> I have a need to open a report in design mode immediately before opening it
> in preview, to change the Minimum and Maximum scale on an axis on a

chart.
>
> This results in a flash of the report in design mode just before it is > opened in preview mode.
>
> Is there any way to open it in design mode hidden?
>
> Jeff



Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Debbiedo | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.