Search results for query: *

Good Afternoon, Please let me know what my options are for securing a query/form that prompts the user for a parameter. Thank you.

While testing my batch email job, I notice that the email is arriving in my Outlook 2003 SP1 with the text wrapped. Is there any way for me to control this in the VB module of Access or in Outlook? Thank you.

I am sending an email along with an attachment utilizing the "do command" method. How can I adjust the width of my email message? When I open the email in Outlook, it is all the way to the right and not extending as far as I would like to the left. Help!

How do I add more than one attachment to the code below? Thank you. Public Sub Command0_Click() Dim otk As Outlook.Application Dim eml As Outlook.MailItem Dim rs As Recordset ' Open your table and build your distribution list Set rs = New ADODB.Recordset With rs...

Robert, Thank you very much. I sent you a star... Can I add an id number that is already in the table in the subject line of the email? ie. Test Message - id 1

Glen - When I use your code, I get a compile error. Sub or function not defined. It seems to be the "set rs = OpenRecordset" line. I apologize for any confusion. I did not mean a distribution list. I need to be able to send the same email body and attachment to many email addresses. I only...

Robert, Please excuse me, I am a newbie. The table name is Table1 and the field name is EmailAddress. How do I implement your changes? Thank you.

Can I use the code below to send to a list of e-mail addresses? How do I augment what I already have? Thank you. Public Sub Command0_Click() Dim otk As Outlook.Application Dim eml As Outlook.MailItem Set otk = CreateObject("Outlook.Application") Set eml =...

Where would I find the Recordset Clone property? Thank you.

How can I get this code to send the attachment to all of the email addresses in the Table 1 field strEmail? Right now, it stops after the first address. Thank you. Public Sub Command0_Click() Dim otk As Outlook.Application Dim eml As Outlook.MailItem Set otk =...

Robert, This code used to work when I had a report to send along with the email body. Now, all I need is to send the email body, and it is not working. Thank you.

Please see below. How do augment the code? I need to send emails without reports. Thank you. Private Sub cmdSend_Click() Dim db As DAO.Database Dim rs As DAO.Recordset Dim txtTO, txtCC, txtBCC, txtSubject, txtMessage As String txtTO = "" txtCC = "" txtBCC = "&quot...

Is there any way to stop placing the report name on top of each email? Here is the code. DoCmd.SendObject acSendReport, "Report Test", acFormatRTF, txtTO, txtCC, txtBCC, txtSubject & " " & " - " & rs![OrgKey], txtMessage, False rs.MoveNext Every time I send an...

Kyle, Please see below. Thank you. Private Sub cmdSend_Click() Dim db As DAO.Database Dim rs As DAO.Recordset Dim txtTO, txtCC, txtBCC, txtSubject, txtMessage As String txtTO = "" txtCC = "" txtBCC = "" txtSubject = "Request Now!" txtMessage =...

I have automated the sending of email to many customers, and I need to put an id field in the subject line of each email. The id field is in the table and query I am running the function from. Please help. Thank you.

John, Would you please explain the best way to normalize the table/relationship structure. I would like to make this process as easy as possible. What is the impact to the input form? Thank you.

Hi John, The data is all in one table. The field names are Course Name, Q6, Q7, Q8, Q9, Q10, Q11, Q12, Q13, Q14, Q15, Q16, Q17, and Q18. Obviously, the records consist of different classes with responses between 1 and 5 for questions 6-18. Please let me know what I can do. Thank you.

I need to build a report that will dcount values in fields grouped by a unique id. How many 1's, 2's, 3's, 4's, and 5's are present in questions 6-18 for records grouped by a course name. The report has to state the question and the totals for 1, 2, 3, 4, and 5. Please let me know if this is...

Rick, I am creating the security for the db from the beginning using the security wizard. How do you successfully logon as the admin if when you start the wizard it defaults with my network id? The wizard does not start up with the "admin" id. The report has my netword id and password...

Rick, The security wizard in Access 2002 is defaulting with my network user id as the "admin" user id. If you type over it and enter "admin" as the user id and leave the password blank the database does not open. This is the reason why I am confused about the Security FAQ...