Recent content by nim180

Hi Everyone, I'm trying to email through access but I'm not sure how to make an attachment. The code to generate an email works fine but i have been requested to have the ability to add an attachment. This is my code: Private Sub Command23_Click() On Error Resume Next Dim strToWhom As...

Thanks PHV, found what I was looking for :-) nim

Hey PHV, I still get the same problem where a pop box appears and you have to keep pressing allow for each instance of the email. Is there anyway of when the user clicks the email button that it sends each email automatically without having to press "Allow" or "Send for each email? Thanks, Nim

Thanks Randy700, that worked but how do i send the email automatically. Now when i use your code it opens a seperate email for each person but i have to press send on each one. Is there a way it will just automatically send each email? nim

Hey everyone, I have 2 questions about emailing if someone can help me. 1. I have a continuous form with a dropdown box in the header. If the user clicks on, for example "foreman", it brings up all the information of all the foreman, name, address, phone number and email address. The code...

Sorry PHV, I had the Error Handler commented out for some reason. Thanks for your help :) nim

Thanks PHV, that worked well. I noticed that if i do not want to send the email and close the instances of outlook I get a run-time error 2501, "The sendObject action was cancelled". Is there anyway of preventing this from poping up. Thanks, nim

Sorry PHV, I should have posted that in my previous comment. I was following the FAQ faq702-4509. My code is as follows. Private Sub BtnEmail_Click() On Error Resume Next Dim strToWhom As String Dim strMsgBody As String Dim strTitle As String...

Hey PHV, Yes, I've tried the DoCmd.SendObject method but it only takes the email address from the first field! Any Suggestions on how I could retrieve all the email addresses. Thanks, Nim

Hey Everyone, I have a continuous form with a combobox called 'Groups' in the header. It has a number of text boxes on the detail section of the form. From the combobox the user can choose from 'Foreman', 'Worker', Ex-Worker' and 'Client. Depending on what is chosen in the combobox, the...

Thanks mate, that worked perfectly! Have a star :-D nim

Hey all, Yes Axworthy, Office 2007 has been recently installed on my computer but 2003 is also installed. I am using the 2003 version at the moment. Do you think I should uninstall 2007? I have code set in the On-Timer, but it is not just the On-Timer that is effected, every event procedure on...

Hi All, I have several database's which i have created and were all working fine a few months back. I went to open the database's today and i got the following error The expression On Timer you entered as the event property setting produced the following error: Object or class does not...

Hey Everyone, I just want to follow up on a previous thread i had which 'Remou' gave me code to check if an instance of internet explore was open. thread702-1566978 I have a timer form which counts down from 60 minutes. When its hits 0 i would like to check if any instance of IE is open and...

Also with regards to the code i pasted above, when the user tries to login and he enters a username that is not on the list i get a runtime error 94 "invalid use of null" and it points to this line lUserID = DLookup("[UsrID]", "tblRndUsr", "[Username]='" & Me.Name1 & "'") How can i prevent...