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!

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

Recent content by hvns

  1. hvns

    Allow, Deny Warning when sending emails

    Here is a link ot the application that I use... works great and is free: http://www.snapfiles.com/get/clickyes.html
  2. hvns

    Callig a field from a sub form into an email in access

    That is a line I was trying to see if it would work. The line that should work starts here and it is called out below towards the middle to populate the email sa Notes Notes = usrNotes '-- ACEMAN this is the line that should work 'NoteDate = [frmQuote_Notes].Form![Date_reviewed] '---...
  3. hvns

    Callig a field from a sub form into an email in access

    I get the same message that it will not allow it for 2k or 2002-2003 versions.
  4. hvns

    Callig a field from a sub form into an email in access

    TheAceMan1, I tried to save it to 2k ( I am in 2007) but it will not allow me to save a copy. I used the code above and I no longer receive the error but no notes are pulling into the email. Maybe a problem with how I am trying to pull the notes in - it is towards the middle of the code Here...
  5. hvns

    Emailing a report with multiple addresses / 1 email per address

    Ok, Here is the code I hace so far but I am missing something as a copy of the entire report is being sent the all suppliers instead of each supplier only getting their piece: Private Sub Command50_Click() Dim db As DAO.Database Dim rs As DAO.Recordset Set db = CurrentDb Set rs =...
  6. hvns

    Callig a field from a sub form into an email in access

    I know - I checked several times and was still stumped, I am attaching a screen shot showing their names:http://img218.imageshack.us/img218/8397/frmview.png
  7. hvns

    Callig a field from a sub form into an email in access

    First of all - Thank you for assisting... I have edited the code to pull the actual names / fields but I am getting a message: "Microsoft Accesscan't find the field 'frmQuote_Notes' referred to in your expression CODE: Public Function usrNotes() As String Dim sfrm As Form, rst As...
  8. hvns

    Emailing a report with multiple addresses / 1 email per address

    Hello, I have a report that is generated based on supplier back orders. For example there is 10 different suppliers that have current back orders in our system. I am needing to send each supplier a report of their current back orders. So for every supplier there would be a seperate email sent...
  9. hvns

    Callig a field from a sub form into an email in access

    Hello, I am sending an email based on the field data displayed in the current form window. A problem I am running into is that there is a subform within the current form and I am wanting to pull the information from that form into the email as well. The subform data = 2 fields (DateCreated)...
  10. hvns

    Calculation in Form Field

    tyvm - just what i needed, could you recommend some links or sites to help me further study up on using the event procedures / vb
  11. hvns

    Calculation in Form Field

    I have a form where the form field "Date Due to Customer" is populated - and I would like it to feed the next field "Date Due to Contracts" minus 1 day). Both fields are in the same table and are of the short date property. any help is greatly appreciated
  12. hvns

    Changing USER ID on Purchase Order

    Is it possible to change the USER ID of who created the PO to another user?
  13. hvns

    MAS90 local machine CPU usage

    Hello, We have been running some tests on teh performance of MAS90 on both the server and local machine after noticing a lack of performance after upgrading to version 4.10.1.16. The server seems to be fine, but the local machine is hitting at 25% and not increasing - even if there is no other...

Part and Inventory Search

Back
Top