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...

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 =...

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 =...

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...

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.

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...

Can someone please explain how to remove the default "admin" user permissions to the database. I am only trying to make myself the Admins, and have users data enter into a form. Thanks!

What would be the best way to insert the same 10 records for ID's already input into a table? ID 1 - 1 ID 1 - 2 ID 1 - 3 ID 1 - 4 ID 1 - 5 ID 1 - 6 ID 1 - 7 ID 1 - 8 ID 1 - 9 ID 1 - 10 ID 2 - 1 ID 2 - 2 ID 2 - 3 ID 2 - 4 ID 2 - 5 ID 2 - 6 ID 2 - 7 ID 2 - 8 ID 2 - 9 ID 2 - 10 etc.

Can someone help me sum one column based on another column's values? Thanks!

How can I send email using the DoCommand.SendObject method without having to confirm each email? After installing Microsoft's service releases, new security features will not allow me to mass email a customer base. It states "An application is automatically trying to send email. Do you...

Is there a way to turn off the confirmation dialogue box that opens up with the DoCommand.SendObject action? ie. "A program is trying to send email on your behalf"

Can I change where it places the attachment? In Outlook, the actual attachment is at the bottom, but it places a .RTF file description before the body of the e-mail. ie. <<Request Form.rtf>> Help!!!

How do I write: Select Number field where number = &quot;1&quot;

How do I write the code in-order to see a particular value in one field? ie. Select Number Field where number is &quot;1&quot;,

How do I write an expression for a text box in a form that will allow a conditional statement based on another field. ie. If Field 1 = &quot;Primary&quot;, then this text box = [Field 2] & &quot; &quot; & [Field 3] Thanks!

How do I write an expression for a text box in a form that will allow a conditional statement based on another field. ie. If Field 1 = &quot;Primary&quot;, then this text box = [Field 2] & &quot; &quot; & [Field 3] Thanks!