Search results for query: *

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

Thanks Mate worked great. Regards, Nim

Hi JerryKlmns, Thanks for the response, the first part of the code works well but with the second part, what i need to do is once a user logs in to automatically lock that field. Thanks, Nim

This is the code behind my login page. I inserted a field called "Used" with a property of true/false, how would i implement this into my code to lock a username if it has been used before. Dim lUserID As Long If Len(Nz(Me.Name1, "")) = 0 Then MsgBox "Enter your User Name"...

Hey alvechurchdata, Yes my login form is already looking up the username from the table and retrieving the password. I have the minutes field already in the table with the assigned minutes to each username and password. How would i go about getting the minutes corresponding to each username to...

I have a login form, when the user enters a username/password it opens the main database form and a small timer form, the timer form has 1 textbox which counts down from a certain time. I would like to do the following: 1. The login form is linked to tblLogin. The table has the fields username...