By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,164 Members | 969 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,164 IT Pros & Developers. It's quick & easy.

More getobject help, please

P: n/a
Thanks to some help yesterday, I am progressing with GetObject .. the
following code will open and print a report. But, how can i get it to
open, maximise WITHOUT printing by default? I need something like
..previewReport

Set AcObj = GetObject("c:\db1.mdb")

With AcObj.Application

.DoCmd.OpenReport "query1"

End With
AcObj.Visible = True
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On 10 Feb 2004 14:01:37 -0800, gw*********@aol.com (Martyn Gwynne)
wrote:

Check the help file on the OpenReport action. There are a couple more
optional arguments that will allow you to specify Preview.

Btw, terrible name for such a nice report.

-Tom.

Thanks to some help yesterday, I am progressing with GetObject .. the
following code will open and print a report. But, how can i get it to
open, maximise WITHOUT printing by default? I need something like
.previewReport

Set AcObj = GetObject("c:\db1.mdb")

With AcObj.Application

.DoCmd.OpenReport "query1"

End With
AcObj.Visible = True


Nov 12 '05 #2

P: n/a
Tom van Stiphout <to*****@no.spam.cox.net> wrote in message news:<pb********************************@4ax.com>. ..
On 10 Feb 2004 14:01:37 -0800, gw*********@aol.com (Martyn Gwynne)
wrote:

Check the help file on the OpenReport action. There are a couple more
optional arguments that will allow you to specify Preview.

Btw, terrible name for such a nice report.

-Tom.

Thanks to some help yesterday, I am progressing with GetObject .. the
following code will open and print a report. But, how can i get it to
open, maximise WITHOUT printing by default? I need something like
.previewReport

Set AcObj = GetObject("c:\db1.mdb")
Thanks, I see what you mean, but then I get an " expected =" error.
Should I use a report object variable to 'hold' the previewed report.
But then doCmd does not seem to work!

MartynWith AcObj.Application

.DoCmd.OpenReport "query1"

End With
AcObj.Visible = True

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.