Solved

Email Current Record Access 2007 VB Issue

Posted on 2013-01-11
3
420 Views
Last Modified: 2013-01-11
Hi,

I would like to know if it is possible to e-mail fields from the current record only.

I'm writing a holiday calendar.  Once the user enters the start and end date, I want to e-mail this to their manager to authorise.  I don't want to attach a report, just use the dates the user has just entered.

The below is garbage I've written...sorry I know I'm bad...

Dim strMsgBody As String

strMsgBody = " Please Authorise the holiday dates," & [Table].[StartDate] & "to " & [Table].[EndDate]

DoCmd.SendObject acSendNoObject, , , , , , , strMsgBody


Thanks,

Rich
0
Comment
Question by:squidlings
  • 2
3 Comments
 
LVL 61

Accepted Solution

by:
mbizup earned 500 total points
ID: 38766777
<< I would like to know if it is possible to e-mail fields from the current record only. >>

Do you mean start and end dates as displayed in the record the user is currently seeing on a form?


strMsgBody = " Please Authorise the holiday date: " & Me.[StartDate] & " to " & Me.[EndDate]

' Youll have to fill in more of this line... email addresses, etc
DoCmd.SendObject acSendNoObject, , , , , , , strMsgBody

Open in new window

0
 

Author Comment

by:squidlings
ID: 38766823
Perfecto!!!  Easy as that... Massive thanks.

Rich
0
 
LVL 61

Expert Comment

by:mbizup
ID: 38766827
You're welcome :)
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now