473,322 Members | 1,719 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

EMAILING A REPORT AS ATTACHMENT LINKED TO A SPECIFIC RECORD IN A QUERY

I have a report with it's source from a query. The query calls data
from 3 related tables. The report is a meeting agenda and I only want
to attach a snapshot report to my email based on the specific record
on a form. I tried using stLinkCriteria but it always captures all
the records on my query as one snapshot attachment with all the
records. The only way I can filter the record I wanted was to add a
field to my table that users manually set to "Yes" and the query
criteria set to "Yes". After sending the email, my users have to
uncheck the Yes box. I would like to not use this option. Help
please!

Fred Crisostomo

May 20 '07 #1
2 1714
you can base your report on the criteria in your form

<cr************@gmail.comwrote in message
news:11**********************@a26g2000pre.googlegr oups.com...
>I have a report with it's source from a query. The query calls data
from 3 related tables. The report is a meeting agenda and I only want
to attach a snapshot report to my email based on the specific record
on a form. I tried using stLinkCriteria but it always captures all
the records on my query as one snapshot attachment with all the
records. The only way I can filter the record I wanted was to add a
field to my table that users manually set to "Yes" and the query
criteria set to "Yes". After sending the email, my users have to
uncheck the Yes box. I would like to not use this option. Help
please!

Fred Crisostomo

May 20 '07 #2
On May 20, 6:55 pm, "Scott" <a@awrote:
you can base your report on the criteria in your form

<crisostomof...@gmail.comwrote in message

news:11**********************@a26g2000pre.googlegr oups.com...
I have a report with it's source from a query. The query calls data
from 3 related tables. The report is a meeting agenda and I only want
to attach a snapshot report to my email based on the specific record
on a form. I tried using stLinkCriteria but it always captures all
the records on my query as one snapshot attachment with all the
records. The only way I can filter the record I wanted was to add a
field to my table that users manually set to "Yes" and the query
criteria set to "Yes". After sending the email, my users have to
uncheck the Yes box. I would like to not use this option. Help
please!
Fred Crisostomo- Hide quoted text -

- Show quoted text -
Thanks Scott. I solved the problem by applying an expression to my
report query.

May 21 '07 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Bob-O | last post by:
Need your help in sending an email message with an attachment in my VB.Net program. Sending a body message is no problem. I don't know how to use the attachment property in an emai Following is...
6
by: B Love | last post by:
I am wondering if I can have a dynamically generated report based upon the results of a query (in Access2000). Any ideas? Related to that (if that cannot be done) can the output of a query...
1
by: Pommy_g | last post by:
Hi, i have done some searching on the newsgroups for this problem but have had no luck. Basically i have a query, and what i need is a button that when clicked on sends an email to whoever,...
4
by: Sami | last post by:
I hope someone will tell me how to do this without having to do any VB as I know nothing in that area. I am a rank beginner in using Access. I have created a database consisting of student...
2
by: modfreq | last post by:
Hi, I am fairly new to Access and VBA. I have found a few threads relating to my problem, but none have led to a solution, so if I hope that I am not restating an old question... I am writing...
4
by: Jana | last post by:
Hi! I have an Access 97 report based on tables linked to an SQL back end. The report has 5 subreports in it (unfortunately unavoidable due to the nature of the report) and performance is quite...
1
by: crisostomofred | last post by:
I have a report with it's source from a query. The query calls data from 3 related tables. The report is a meeting agenda and I only want to attach a snapshot report to my email based on the...
11
by: radink | last post by:
Hey All, I have a report that I would like to show a word on based on if a field is checked in a form. For example. The form has a check box called Fee. If that is checked, I want the word Paid...
1
by: didacticone | last post by:
i have a database where i am trying to email a report as an attachment, it works fine but since it is an .rtf file the conversion is messy... i was wondering if i can do it as a pdf or some other...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.