Good Afternoon,
Is there a way to add an additional parameter to the SendObject method of the acSendReport parameter? Kind of like the DoCmd.OpenReport object you can specify a Report parameter when it opens.
Could look something like this... -
DoCmd.SendObject acSendReport, _
-
"Report Name" & Parameter, _
-
acFormatPDF, _
-
.Fields(0), , , _
-
"Subj", _
-
"Message", _
-
False, False
-
1  2976 
pwag,
Not that I know of. However, you should be able to set the record source of the Report by basing the query off the record(s) you specify on your Form. For example, if you have a form that lists records and you only want to print the current record, then have the report's record source be a query that uses the record ID in its criteria. You can also do this using global variables or the TempVars variables. There are several options, it just depends on how you want to build it.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Jay Bienvenu |
last post by:
I am trying to execute a DoCmd.SendObject command to produce an email
message from Access 2000. The command produces the email message, but
the To:, CC: and BCC: fields are blank. The subject field...
|
by: Alfred |
last post by:
Hi
I am using access 2002
1.0 I want to email a word or html file using the docmd.sendobject The
document must be send as a attachment.
2.0 Second I would like to tell the Docmd.Sendobject to...
|
by: Tom Louchbaum |
last post by:
When I preview my Access 2000 Report it looks fine. When I Email the
report using
DoCmd.SendObject acSendReport, "Report", acFormatRTF, "To Address", , ,
"Subject", , False
the resulting...
|
by: Lauren Quantrell |
last post by:
This works in my Access2000 MDB but not in the MDE created from the
same file (on the same workstation):
DoCmd.SendObject acSendReport, "myReportName", acFormatRTF,
"someone@somewhere.com", , ,...
|
by: Tom Louchbaum |
last post by:
When I preview my Access 2000 Report it looks fine. When I Email
the report using
DoCmd.SendObject acSendReport, "Report", acFormatRTF, "To
Address", , , "Subject", , False
the resulting...
|
by: dszmauz |
last post by:
I'd like to send a report to a distribution of email addresses. The distribution list is stored in Email.. How do I use the DoCmd.SendObject to send to a list? The command below isn't working:...
|
by: Filips Benoit |
last post by:
Dear All,
DoCmd.SendObject acSendReport, "RPT_ITEM", acFormatTXT,
Me.CNT_EMAIL, , , "testEmail", "test", False
The report is converted to RPT_ITEM.txt before sending as attachment.
Is the...
|
by: RobH |
last post by:
i currently send a report to a reciepient using the Docmd.Sendobject acSendReport which works really well - now my customer wants two reports sent in the same email..
Any thoughts???
|
by: neosam |
last post by:
Hey all,
I am not able to integrate these 2 actions in one command. What i am doing is...
A button which sends a report with only specific data to a particular person (via outlook). I am able to...
|
by: austinboston |
last post by:
I've gone down the road of using docmd.sendobject for sending out reports from an access database because I don't have to save the attachment to media that way, I can just create and send. My problem...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |
