Search results

Hi Guys, Hope you can help. I am using Access 2003. I have modified the attached code which was originally created to loop through a table and create a individual report based on a query and use the DoCmd.SendObject to send this report to a list of individual email addresses with the...

Hope someone can help with this one - I have searched the Forum and cannot find any reference to this problem. I have a form which was originally based on a query linking 2 tables - data entry into the form worked fine. I then needed to add another field to the form from another table so I...

I can send an email using an event but I want it to go out with voting buttons on it. Can anyone help. I have searched the forum for this and found nothing Cheers, Bill

I have a form with buttons that scroll to Next and Previous record. When you get to the last record and click the next button an Access message appears stating " You can't go to the specified record" I want to do one of to things. Either change the message that Access displays to "There are...

I have looked through 18 pages of forums and have not found an example of what I want to do. The help I have received from this forum has been tremendous so far. I have a form with a subform that displays an image and everything works fine. The problem I have is that not all of the records on...

I have a form with images linked by using a text box which holds the path to the image on the hard drive. When I add a new image I have to type the path in. Is there some code I could add to the double click event of the text box that would allow me to browse to the image and pick up the path...

Can anyone help. I have used code from this forum shown below: On Error GoTo Err_Command68_Click Dim cn As ADODB.Connection Dim rs As ADODB.Recordset Dim strEmail As String Set cn = CurrentProject.Connection Set rs = New ADODB.Recordset rs.Open "EmailListTable", cn...

Hi Guys I have the following code on a button on a form that I want to e-mail a report with. The code below works fine when i want to e-mail all records but I only want the report to e-mail the current record. DoCmd.SendObject acReport, "Report", "RichTextFormat(*.rtf)"...

Update Query Can anyone help with this one. I want to create an e-mail address from the details I collect on my form and achieve this with the following expression as the control source in a text box on my form =[Forename] & "." & [Surname] & "@thee-mailaddress.com;" This works fine, but I...

With reference to this post I have tried the the code in your Imagesample2000 on my form to solve the problem of an image remaining from the previous record. The code I used is: Private Sub Form_Current() If Not IsNull([ImagePath]) Then...