WUGNET, the Windows User Group Network
Your Complete Resource Center for "The Best" in Shareware, Computing Tips and Support, Windows Industry News... and much more!
Home Forums Shareware Windows Tips Hot Offers FREE Newsletters Arcade Contact Us About Partners
Search WUGNET: RSS Feeds RSS Feeds Advertise with WUGNET    |    Shareware eBooks
HomeHome FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

email only one record in access 2003

 
   Home -> Office other -> Getting Started RSS
Next:  Edit button  
Author Message
Pepomarga

External


Since: Oct 08, 2008
Posts: 1



(Msg. 1) Posted: Wed Oct 08, 2008 7:25 am
Post subject: email only one record in access 2003
Archived from groups: microsoft>public>access>gettingstarted (more info?)

When I try to email a record it makes me a snapshot of all records and not
only the one I want.
Back to top
Login to vote
Benita Alston

External


Since: Oct 11, 2009
Posts: 1



(Msg. 2) Posted: Sun Oct 11, 2009 4:17 am
Post subject: how to e-mail only one record access 2003 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

How to e-mail only one record access 2003?



Pepomarg wrote:

email only one record in access 2003
08-Oct-08

When I try to email a record it makes me a snapshot of all records and not
only the one I want.

EggHeadCafe - Software Developer Portal of Choice
Dictionary Lookup ASP.NET ServerControl
http://www.eggheadcafe.com/tutorials/aspnet/8bce9387-0278-433b-b7e1-23...6e88d76
Back to top
Login to vote
Al Campagna

External


Since: Aug 23, 2007
Posts: 394



(Msg. 3) Posted: Sun Oct 11, 2009 11:35 am
Post subject: Re: how to e-mail only one record access 2003 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Benita,
Not a lot of detail to go on, but...

Create a report that is always filtered by some key value on the form
you are initiating the email from.
Example: A unique key field named CustID on form named MyForm

In the query behind the report, use that form value as a criteria to
filter
out all CustIDs except the one currently displayed on the active and open
form.
Example: = Forms!MyForm!CustID
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

<Benita Alston> wrote in message news:2009101171715bmw@nwnatural.com...
> How to e-mail only one record access 2003?
>
>
>
> Pepomarg wrote:
>
> email only one record in access 2003
> 08-Oct-08
>
> When I try to email a record it makes me a snapshot of all records and not
> only the one I want.
>
> EggHeadCafe - Software Developer Portal of Choice
> Dictionary Lookup ASP.NET ServerControl
> http://www.eggheadcafe.com/tutorials/aspnet/8bce9387-0278-433b-b7e1-23...6e88d76
Back to top
Login to vote
Display posts from previous:   
       Home -> Office other -> Getting Started All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Categories:
 Windows XP
 Windows Vista
 Windows Other
 Office
  Office Other
 Security
  • Home |
  • Shareware |
  • Windows Tips |
  • Hot Offers |
  • FREE Newsletters |
  • Arcade |
  • Forums |
  • eBooks |
  • About WUGNET |
  • Partners |
  • Contact

  • WUGNET Privacy Policy |
  • Link to WUGNET |
  • IT Support