Search results

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 ?

Thanks for responding ! ! ! . . . Is a there a command to convert Now() to a character string ?

Can someone tell me why I'm getting the below error message. "Data type mismatch in criteria expression" I'm trying to pass a variable (via VBA) from a form to another form that retrieves a associated records to the form called. The form criteria is to match a variable that has the value of...

Mmmmmm . . . I was told in past that SQL Server could provide access to a MS Access database application on the internet. It seems that SQL Server no longer (or never was) an option. Would someone provide me with the best option for a simple MS Access database application that only ask a...

I have a MS Access database that has a form that collects data (i e. survey). I want to make this form available for use on the internet. The form creates an entry in a table, then the entry is appended to a summary table. How will MS Access work when this form is activated (on the internet) at...

Do you have a table of Survey Takers? A SurveyTakerID as a primary key ? No, Each Survey Takers will be will a new Survey Takers. Their name (first, middle, and last), address, location . . . etc. will be stored in a record for the Survey Takers. Also, the Survey Takers will only be allowed to...

cheekybuddha, Thank you for your patience ! ! ! . . . You're absolutely correct. I'm am confused, but I'm determined to find the best and easiest solution to my problem. As see, I've been searching the internet for a solution. Currently, I'm trying to retrieve one record associated with...

Oh man, I been working with the wrong piece of code. I've been foucused on the quotes and forgot about the "Where" statement. Initially, I had a "Where statement in my example (with a hard coded name). My example worked in a MS Access query. If can just get the below code to work with the...

I thought that the "Where" statement was working, it's not. What is wrong ?. Compile error. Sub or Function not defined strSQL = "INSERT INTO Individual_Spiritual_Gift_Totals (Survey_Taker_First_Name, Survey_Taker_Middle_Name, Survey_Taker_Last_Name, Survey_Taker_Telephone_Number) " & _ "...