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 Mike Lewis 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: *

  • Users: hvns
  • Order by date
  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...
  14. hvns

    Automated Email via Access

    Hello, I have read some of the threads already with this similar topic but it does not seem to fit my needs. I am wanting to do somewhat of a mass email(s). Here is what I basically want to do: Send an email to a contact from a table that contains their information, with the list of back...
  15. hvns

    Help adding a page break to report in Crystal Reports for MAS90/200

    Well first let me say thank you for assisting but I am not having any luck... Kruken were you able to get this to work for you? I tried to do what you were saying but check the attached screen shot showing that it is printing in the body of the order...
  16. hvns

    Rounding to the nearest .25 of an hour

    problem is that I am reading time from a linked table that is read only.. other issue never done functions so I was hoping to do it right in the query... I have seen the following expressions used on the net but for some reason it does not work for me: RoundedTime...
  17. hvns

    Rounding to the nearest .25 of an hour

    Hello all, I am trying to round for the first time in a query... and would like to have the query round to the nearest quarter hour... Example date: Hours 1.16 2.73 6.40 Desired results: 1.25 2.75 6.50 to have the hours worked rounded to the nearest quarter hour. Up or Down... Thanks in...
  18. hvns

    Help adding a page break to report in Crystal Reports for MAS90/200

    Dawn... I tried doing the same with mine but for some reason that would not work ... any ideas? It kept pasting it in the body of the report For some reason the page footer is before the report footer - does not seem right and cannot move it.

Part and Inventory Search

Back
Top