Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. nim180

    Adding an attachment to an email.

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

    Emailing issue in Access

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

    Emailing issue in Access

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

    Emailing issue in Access

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

    Emailing issue in Access

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

    Email to Mulitiple email addresses through Access

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

    Email to Mulitiple email addresses through Access

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

    Email to Mulitiple email addresses through Access

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

    Email to Mulitiple email addresses through Access

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

    Email to Mulitiple email addresses through Access

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

    Error when opening any form or clicking on any button.

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

    Error when opening any form or clicking on any button.

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

    Error when opening any form or clicking on any button.

    ...expression On Timer you entered as the event property setting produced the following error: Object or class does not support the set of events. *The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure] *There may have been an error...
  14. nim180

    Closing internet explorer through a form

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

    Login from Query - Username to match timer minutes

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

    Login from Query - Username to match timer minutes

    Thanks Mate worked great. Regards, Nim
  17. nim180

    Login from Query - Username to match timer minutes

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

    Login from Query - Username to match timer minutes

    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"...
  19. nim180

    Login from Query - Username to match timer minutes

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

    Login from Query - Username to match timer minutes

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

Part and Inventory Search

Back
Top