Search results

Thanks Adam, I sort of understand what you are saying but have tried placing the Dim olkapps As Outlook.Application 'set the application elsewhere in the code but it dfosen't seem to work. Could you tell me wher to place it? Cheers, BillyMac

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

The database is used to book students on training courses, I send out a list of dates available for particular courses, students select which dates they are available to attend (tbleDatesAvailalbe) - one student many dates. When we have enough students available on a particular day to warrant...

Thanks for that Gemma - I never heard of a cartesian cross product table - I will look at redesigning the table and promise to learn all I can about cartesian cross product table - got to go now but will search this Forum for it on Monday. Cheers

OK - sorry if I didn't explain in proper detail - Table 1 holds personal details, table 2 holds dates available, relationship table 1 one-to-many to table 2, Table 3 holds dates already booked, relationship table 1 one-to-many to table 3

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

Dave, You're a star. I''l check this out when I get back to work. Cheers, Billy

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

Dave, Ignore my last message - I forgot about the bring forward send back function on the format menu. Billy

Dave, Tried that but the label is visible when there is an image. I don't have any images embedded in the form they are linked via an image path to a folder on the harddrive. Is there something I have missed Billy

Wayne, Thanks for that. I will give it a try. Billy

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

Thanks for that Adam. I checked my email addresses and found nothing wrong with them except that the code I used to create them was including the ; (semi colon) in the address. When I removed this all worked well.

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

DBL abd Pat, Thanks for the excellent advice. I have now populated all of the e-mail address fields and new additions are working a treat also. Thanks again

It's a continuous form

Thanks for that DBL. I thought it would work and so simple I don't know why I didn't think of it. Unfortunately it now only updates the record that has the focus on the form and not all of them. Do I need to run the query each time with a different record in focus in order to create the...