A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

printing one form



 
 
Thread Tools Display Modes
  #1  
Old July 14th, 2004, 08:22 PM
Pam
external usenet poster
 
Posts: n/a
Default printing one form

How can I send a form through Outlook? When I try to send
it, it sends all 50,000. I only want to send the form
showing on the screen. If I choose edit, select record
and then send, it sends it but in a table setup. I want
the form to show so it can be printed this way. Help.
  #2  
Old July 14th, 2004, 09:00 PM
frank stone
external usenet poster
 
Posts: n/a
Default printing one form

I'm not sure you can do that. I tried to do the same thing
but fail. there is a send mail function in access but
sending the form wasn't an available format. i solved the
problem by creating a report the looked just like the form
and sent the report. i used this code attatch to a button
lable "send mail". It will ask for a id to identify the
record to be sent.

Private Sub cmdSendeMail_Click()
On Error GoTo Err_cmdSendeMail_Click

Dim stDocName As String

stDocName = "rptVMDForm"
DoCmd.SendObject acReport, stDocName, "RichTextFormat
(*.rtf)"

Exit_cmdSendeMail_Click:
Exit Sub

Err_cmdSendeMail_Click:
MsgBox Err.Description
Resume Exit_cmdSendeMail_Click

End Sub

-----Original Message-----
How can I send a form through Outlook? When I try to

send
it, it sends all 50,000. I only want to send the form
showing on the screen. If I choose edit, select record
and then send, it sends it but in a table setup. I want
the form to show so it can be printed this way. Help.
.

 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Searching Records Melissa Lambino New Users 6 July 20th, 2004 04:51 AM
repost: Printing out form + subform Edm Using Forms 3 July 7th, 2004 04:33 AM
surely a form with a ListBox can be used in a query? 1.156 Running & Setting Up Queries 14 June 2nd, 2004 04:54 PM
Limit Printing a Form on a Worksheet Danny Worksheet Functions 2 December 18th, 2003 12:12 AM
printing form or a database like jv Worksheet Functions 2 November 2nd, 2003 03:33 PM


All times are GMT +1. The time now is 04:19 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.