PC Review


Reply
Thread Tools Rate Thread

Adding a query object in my VB code

 
 
mahadevan.swamy@gmail.com
Guest
Posts: n/a
 
      18th Apr 2007
In this VB code,

Option Compare Database


'------------------------------------------------------------
' mcrEmailClosure
'
'------------------------------------------------------------
Function mcrEmailClosure()
On Error GoTo mcrEmailClosure_Err


' Email as SNP closure report
DoCmd.SendObject acReport, "rptCloseOut",
"SnapshotFormat(*.snp)",
"", "", "", "Closure Report - Concern Number", "Please see attached
closure report", True, ""


mcrEmailClosure_Exit:
Exit Function


mcrEmailClosure_Err:
MsgBox Error$
Resume mcrEmailClosure_Exit


End Function
---------------------------------------------------------------------------*-----------------------


I want to add a query object called Report # in the subject or
filename. This query object is just a number for a particular report
so that I dont have to type it again and again when i want to send it
to someone else. Any ideas?


Thanks

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel crashes when adding code using vbproject object? =?Utf-8?B?bWlrZWI=?= Microsoft Excel Programming 5 8th May 2006 11:57 PM
Adding a COM object from code-behind into a web form John Microsoft ASP .NET 0 30th Nov 2005 05:24 PM
Adding Object Library to VBA Code aaron Microsoft Access VBA Modules 1 24th May 2004 10:34 PM
No icon when adding embedded OLE object with code? Philip Kime Microsoft Access Form Coding 0 7th May 2004 10:40 AM
Adding a property to a query object SuperScooper Microsoft Access Form Coding 1 4th Feb 2004 12:38 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:13 AM.