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

Difference from .mdb to mde?

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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.
Nov 12 '05 #2

P: n/a
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

Nov 12 '05 #3

P: n/a
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

Nov 12 '05 #4

P: n/a
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.

Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.