Recent content by Talismanic

Thanks Rich, that did it.

Rich, I modified it like you said and now I am getting a Compile Error - Method or Data Member not Found and it highlights this .JobName My table and field names are correct so I am pretty sure its not that. I am opening the recordset correctly? This is how the code looks with the...

You can use the SendObject to do it like this: DoCmd.SendObject acReport, "ReportName", "RichTextFormat(*.rtf)", "YourEmail", , , _ "OptionalSubject", "OptionalText", True Let me know if this won't work for you or if you absolutely have to use a transfer in place of the SendObject. I might...

I don't think that you can fill the to: and cc: that way but if you modify the SendMail command by adding a false to it like this: DoCmd.SendObject , , , strEmail, , , "Subject", "Message Text", False It will send it to all without prompting you. If you need to edit the message or subject...

I think this will work for you: Topic: Emailing System Help Let me know if you need more help with it.

I am still learning to use recordsets out side of ASP and still having problems with it. I want to update the "Jobs" table with (for now) static data. Here is what I have so far: Dim rsCOD As DAO.Recordset Dim strJobName, strJobNumb, strLocation As String strJobName = "Talismanic" strJobNumb =...

Yes it is possible and the script to do it can be found here: Topic: Data Entry via Internet All you would need to do is to modify it something like this: Set Mailer = Server.CreateObject("JMail.SMTPMail") Mailer.Sender= "Access Mail Bot" Mailer.SenderName = "Database Creater's Name"...

I think you could make this work for you: API: Find out if an application is currently running

Mike, I think this will answer your question. Topic: re-enable db window

If I understand you correctly you could probably use a DCount. The syntax is the same as a Dlookup and I use them to check for job numbers in a table before I open reports based on the job number. This is an example: Dim strMsg As String, strTitle As String Dim intStyle As Integer, cancel As...

Glad to hear that it worked out for you, you can also use Net Send to send messages to groups, for instance the Administrators group. Have you built the error trapping into it yet? If so, and you wouldn't mind, I would like to take a peek at your code.

Chris, if the database and the computer that needs to get the message are NT you could use the net send command. I threw this together real quick so that you could have an example of what I am talking about. Dim strCompName as String Dim strMessage as String Dim strNetSend as String...

axa and bayman, It works fine on Win2K, I just tried it out. bayman, you can do a quick test with this: Dim strUserName As String Dim strCompName As String strUserName = GetWinUserName() strCompName = GetWinComputerName() MsgBox ("User name is " & GetWinUserName & ". " & " The computer name...

siplon, Similar questions were posted earlier this week. Here are a couple of links to those posts. I think you will find your answer there. Start here - MY First asp page Then go here - My asp page works now ! but..... That should get you started, if you have more questions post back to...

I started Loopy, you straightened me out. I have been working through the code and I think I (some what) understand what is going on. Thanks for all the help!!!