Search results

I have no problems receiving or sending emails. So, how can I correct this ?

I also have the below reference box checked in "Tools" . . . References . . . Microsoft Outlook 16.0 Object Library

Here ya

What does the below error mean and do I fix it ? Runtime Error 2147467259 (80004005) It fails on ==> Set M = O.CreateItem(olMailItem) ' Remember to add REFERENCE to Microsoft Outlook Object Library Dim Msg As String ' Msg = "Dear " & Firstname & ",<P> & _ ' "Your statement balance as...

I have a macro that's giving me a 3211 error. How can I find out which form, table, or query in the macro is open ?

I want to automatically advance to the next textbox after entering a numeric value.

What is needed to move to the next textbox automatically without tabbing ? Current settings are as follows for all textboxes. Tab Index is 12 Tab Index is 13 Tab Index is 14 Tab Index is 15 Tab Index is 16 Tab Index is 17 Tab Index is 18 Tab Index is 19 Tab Index is 20 Tab Stop Yes Auto Tab...

Update . . . My e-mail finally arrived (hours later). It appears that when sending the MS Access e-mail with an attachment, the attachment has a filename of "#1.PDF", but when the reaches it's designation, it has my specified filename. Weird . . . Have heard of this before ? Now, I have...

I misread your question. The report name is not "1". I'll try the code tomorrow and get back to you. Thanks ! ! !

I'm going to pass it from the form.

Yes

I'm sending a report. Below is the code. DoCmd.SendObject acSendReport, sRep, acFormatPDF, sAddr, , , sSubj, "Thank you for taking this survey. Attached is your copy of " & "'Survey Report'."

Is there any way to change the .PDF file name from the number "1" to a name that I will give with the DoCmd.SendObject method (Access) acFormatPDF parameter ? Right now the attached file is named '1.PDF'.

Is there a way for MS Access to create a report that shows the flow on how Forms, Reports, Tables, Macros, and Queries are associated ?

Thanks ! ! !

I'm expecting the sent MS Access e-mail to arrive at the destination within minutes, rather than hours or day(s). I'm using the standard e-mail services for a typical user. The sent MS Access e-mail never shows up in my Comcast.net or Gmail.com 'Outgoing' or 'Sent' folders, while watching for a...

Can someone tell why my e-mails are arriving anywhere from eight (8) hours to an entire day later to recipients when using the DoCmd.SendObject method (MS Access) ? The e-mail providers are Comcast and gmail (i.e. Comcast.net and Gmail.com).

Thank you ! ! !

I'm trying to combine the date and time together into a variable and pass the variable to a MS Access form.

Thanks ! ! ! . . . How can I convert Now() to a string character in MS Access VBA ?