I want to send a report to the currently selected student in my database. I have everything working fine, except pulling the e-mail address from the form. Rather than reading what I am writing as code, it literally puts [Forms]![frmStu_Assn1]![Stu_Email] into the TO: of the message. Stu_Email is a field on the form where the e-mail address of the current student is displayed. Thanks! -
Private Sub cmdSendEmail_Click()
-
On Error GoTo Err_cmdSendEmail_Click
-
-
Dim stDocName As String
-
-
DoCmd.SendObject acSendReport, "rptStudent_Referral", , "[Forms]![frmStu_Assn1]![Stu_Email]", , , "Your Federal Work Study Assignment", "Attached is your work study assignment. If you have any problems opening the PDF form, please contact the Financial Aid Office."
-
'DoCmd.OpenQuery "qryActive_DC_ID", acViewNormal
-
DoCmd.OpenReport "rptProfile_Report", acViewNormal
-
DoCmd.RunMacro "Send_Rpt_Student"
-
-
-
-
Exit_cmdSendEmail_Click:
-
Exit Sub
-
-
Err_cmdSendEmail_Click:
-
MsgBox Err.Description
-
Resume Exit_cmdSendEmail_Click
-
-
End Sub
-
1  1666 
Figured this one out just after posting. My mistake... you cannot put " " around the code line [Forms]![frmStu_Assn1]![Stu_Email],
DOH!
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Tom Brown |
last post by:
Hi,
I have what seems to be a simple problem. But I can not for the life of me
find a way to send an integer over a socket. The send method will only accept
strings. Here is what I am trying to do:
testmessage = 'test message'
msglen = len(testmessage)
sock.send(msglen)
sock.send(testmessage)
|
by: Etienne Charland |
last post by:
Hi, there is an application running on a remote desktop (under Citrix ICA,
but the same problem applies for RDC or PC Anywhere). Now, I want to send
keys to the remote application from a local app. I tried sending keys in VB
with SendKeys, as well as using keybd_event API, but I'm not able to send
any keys. It works very well for any local applications, but I can't pass
the keys remotely. Is there any way to do it?
Thanks!
Etienne
|
by: Fatih BOY |
last post by:
Hi,
I want to send a report from a windows application to a web page like
'report.asp'
Currently i can send it via post method with a context like
local=En&Username=fatih&UserId=45&Firm=none
But the problem occures when i want to send a data with & sign (i.e:
Firm=F&B). I try to solve this problem with using boundary, but i failed.
Any idea!?
|
by: Kitchen Bin |
last post by:
Hi.
I am trying to use Sockets to do multiple Send and Receives via HTTP
(not simultaneously). A first pair of Send/Receives works fine and
sure enough I receive HTML back, but the next Send/Receive pair (even
if identically the same as the first pair) returns no data.
eg. The following simplified code will receive some bytes:
s.Send(ByteGet, ByteGet.Length, SocketFlags.None);
bytes = s.Receive(RecvBytes, RecvBytes.Length, 0); //...
|
by: zhimin |
last post by:
Hi,
I'm writing a program to send large file(100m) through dotnet using
TCPListener & TCPClient, I'm sending the file with a ask and response loop:
1. Client send a flag 1 to server indicate it has data send to server.
2. Client send the buffer block size.
3. Client send the actual buffer to the server.
4. Server send a flag 1 to client indicating that the buffer has been
successfully receeived.
5. The next loop until all data of the...
| | |
by: Amadej |
last post by:
Hello everyone,
I'm having some odd problems with a little program I wrote for
sending/receiving bytes across the network.
I am using synchronous sockets, and it seems that when I send byte
after byte too fast, the packet gets lots somewhere (as odd as that
sounds).
Here's the sending code:
|
by: GrantS |
last post by:
I need to use a sendkeys key combination to automate the "accept
files" that a remote user wants to send to me via Windows messenger. I
am using automation to work with Windows Messenger client in a
Winforms C# application.
I have tried a number of code segment combinations for ALT T
combination without success. The combinations might be correct but it
might be failing for some other reason.
My Attempts:
|
by: Sara |
last post by:
HI,
I want to code a program to detect GSM mobile (any kind) which connected
through serial port to computer and then be able to send SMS through
this mobile phone to other mobile phones, could anyone help me and guide
me, I wrote a program which could open COM port but still couldn't
detect mobile phone and send SMS through it. I searched internet and I
didn't find right answer to my question.
please if anyone could guide me.
the...
|
by: ultr |
last post by:
Hello,
I have read that send() may not send whole message and returns the
nuber of bytes sent, so that we can handle the rest of the message. Is
it true, because i have tested sending even 1MB long message by the
Internet connection and it was sent in one message - send() returned
length of whole message?
And the second question: If we really need to send the rest of the
message, what should i do if client disconnects while sending...
|
by: Xionbox |
last post by:
Hello everybody,
The error I have seems very easy to solve, but for some odd reason I can't seem to solve it. Anyways, here's my "setup".
I created a server running on localhost:1200 (telnet localhost 1200 proves that it is up and running) and I coded a client which is supposed to connect to that server and send it data.
The odd part is that the client connects to the server (via connect()) without any problem, but three lines later, it...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
| | |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
