Difference from .mdb to mde?

[Stubble]

When I wrote up a module to display the Windows Print Dialog box (to
allow the user to select a specific printer on the network) instead of
the DoCmd.OpenReport the function worked fine. I packaged it up in a
*.mde file to send to the client and suddenly an error popped up when
I ran the function: "The command or action 'Print" isn't available
now."

My code is as follows:
<snip>
Function PrntDlg(ReportName As String)
'This function allow user to select printer with _
standard windows dialog box

'Selects report without actually opening in preview mode first
DoCmd.SelectObject acReport, ReportName, True
'Call dialog box
DoCmd.RunCommand acCmdPrint

End Function

</snip>

I think that the problem might be that I can't select any object from
the database window in a *.mde.

A) Does it make sense that this is the problem?

B) What could I do to get around the issue?

Thanks,
Yoda

[Trevor Best]

On 29 Sep 2003 18:43:58 -0700 in comp.databases.ms-access,
ys*******@hotmail.com (Stubble) wrote:

When I wrote up a module to display the Windows Print Dialog box (to
allow the user to select a specific printer on the network) instead of
the DoCmd.OpenReport the function worked fine. I packaged it up in a
*.mde file to send to the client and suddenly an error popped up when
I ran the function: "The command or action 'Print" isn't available
now."

My code is as follows:
<snip>
Function PrntDlg(ReportName As String)
'This function allow user to select printer with _
standard windows dialog box

'Selects report without actually opening in preview mode first
DoCmd.SelectObject acReport, ReportName, True
'Call dialog box
DoCmd.RunCommand acCmdPrint

End Function

</snip>

I think that the problem might be that I can't select any object from
the database window in a *.mde.

A) Does it make sense that this is the problem?

B) What could I do to get around the issue?

Thanks,
Yoda

Another method you need. Using the .OpenReport method I see for you.

--
A)bort, R)etry, I)nfluence with large hammer.

[Wayne Morgan]

I suspect you may be right about the problem with your current method. It is possible to
print the report using the DoCmd.OpenReport method without previewing the report. The
acNormal view mode should send the report straight to the printer.

--
Wayne Morgan
"Stubble" <ys*******@hotmail.com> wrote in message
news:37**************************@posting.google.c om...

When I wrote up a module to display the Windows Print Dialog box (to
allow the user to select a specific printer on the network) instead of
the DoCmd.OpenReport the function worked fine. I packaged it up in a
*.mde file to send to the client and suddenly an error popped up when
I ran the function: "The command or action 'Print" isn't available
now."

My code is as follows:
<snip>
Function PrntDlg(ReportName As String)
'This function allow user to select printer with _
standard windows dialog box

'Selects report without actually opening in preview mode first
DoCmd.SelectObject acReport, ReportName, True
'Call dialog box
DoCmd.RunCommand acCmdPrint

End Function

</snip>

I think that the problem might be that I can't select any object from
the database window in a *.mde.

A) Does it make sense that this is the problem?

B) What could I do to get around the issue?

Thanks,
Yoda

[Stubble]

Wayne,

The problem is that the client wants to be able to select which
printer to send the report to. So I am trying to use the Windows Print
Dialogue.

Thanks,
Yoda

"Wayne Morgan" <co***************************@hotmail.com> wrote in message news:<9S******************@newssvr31.news.prodigy. com>...

I suspect you may be right about the problem with your current method. It is possible to
print the report using the DoCmd.OpenReport method without previewing the report. The
acNormal view mode should send the report straight to the printer.

--
Wayne Morgan

[Wayne Morgan]

See if either of these provide more information for you. The link at the bottom of the
second one will take you to a very good resource.

http://www.mvps.org/access/reports/rpt0009.htm
http://support.microsoft.com/default...roduct=acc2000

--
Wayne Morgan
"Stubble" <ys*******@hotmail.com> wrote in message
news:37**************************@posting.google.c om...

Wayne,

The problem is that the client wants to be able to select which
printer to send the report to. So I am trying to use the Windows Print
Dialogue.