Search results

  1. C

    DCount Expression, 2 criteria on a report

    Hello, I have searched forum and google and tried a few suggestions, however I am not getting the correct results. This is my Report (Preview View) I am getting some figures which are correct but I think where I need to have 2 x criteria's I am not getting the results. Some appear correct...
  2. C

    Looking for best practices, Locking dates so they are not changed by code.

    Yes I am most likely controlling way too much on this form. But it is old and had things added to the program over the years. I need time to clean it all up. Thank you
  3. C

    Looking for best practices, Locking dates so they are not changed by code.

    Thanks Doc
  4. C

    Looking for best practices, Locking dates so they are not changed by code.

    G'Day Pat, My Form is bound to the main table But there is a lot of information being done when this form opens and it is very slow on the server. (something I do need to improve!) With the Private Sub BtnUpdate_Click() Should I add an If statement to control what dates get updated and what...
  5. C

    Looking for best practices, Locking dates so they are not changed by code.

    Thank you
  6. C

    Looking for best practices, Locking dates so they are not changed by code.

    Hello, Step 1 Create function to hide or show buttons dependent on date field enabled true/false. These buttons will overlay each other accordingly. By Default the Date Fields are Enabled = False ! - Lots of buttons to code ? - Can I clean this up to be not so repetitive? This...
  7. C

    Look at Employee ID, look up email address from table, send email yes/no

    Happy New Year.... Just updated code that you did for me, thanks again. Seems to be working, exception the project manager when "Hello (Should be PM first name) is saying "Hello 6" which is obviously the Employee ID.
  8. C

    Look at Employee ID, look up email address from table, send email yes/no

    Awesome Mate! Thanks legend, I’ll make changes and report back. Thanks so much.
  9. C

    Look at Employee ID, look up email address from table, send email yes/no

    Thank you! I think nearly there, the .To = is this where I call the getemail function? If so I dont know how. thanks.
  10. C

    Look at Employee ID, look up email address from table, send email yes/no

    I think i have fixed one of the errors, getting error on this now. Updated Code... ' Ask if to send email to Project Manager, Yes: Look up PM and get email. ' Check for email first, if empty open PM contact record to enter email. Public Function PmEmail(form_name As String) Dim...
  11. C

    Look at Employee ID, look up email address from table, send email yes/no

    getting error here Code so far with your help :) ' Ask if to send email to Project Manager, Yes: Look up PM and get email. ' Check for email first, if empty open PM contact record to enter email. Public Function PmEmail(form_name As String) Dim txtmessage As String Dim Msg As String...
  12. C

    Look at Employee ID, look up email address from table, send email yes/no

    ProjectManager coming from the jobInfoT.
  13. C

    Look at Employee ID, look up email address from table, send email yes/no

    I am calling this from the forms Private Sub TxtCustomerPreferredDate_Change() Call BtnUpdate_Click Call PmEmail("JobDetailF") End Sub or shall i just put the code in the form?
  14. C

    Look at Employee ID, look up email address from table, send email yes/no

    sure, what ever you need :)
  15. C

    Look at Employee ID, look up email address from table, send email yes/no

    Yes that is correct. the dlookup part ("YourEmailField", ....... What does this refer to please?
  16. C

    Look at Employee ID, look up email address from table, send email yes/no

    Yes that is correct, I have a few places where I am drawing on the values of the record.
  17. C

    Look at Employee ID, look up email address from table, send email yes/no

    Thank you, Yes one single email based on who the project manager is where their email is listed in the EmployeeT
  18. C

    Look at Employee ID, look up email address from table, send email yes/no

    Ok, der... got rid of iresponse and changed to txtmessage... now getting errors. For selecting the Set rs = CurrentDb.OpenRecordset("Select * from EmployeeT_EmailWork")
  19. C

    Look at Employee ID, look up email address from table, send email yes/no

    When I select no, it still moves to vbYes, which has a number "6" wierd. then down to Case vbNo which has "7"
  20. C

    Look at Employee ID, look up email address from table, send email yes/no

    When I step thru, it skips everything after I click on Yes and goes straight to vbNo., End Select End Function.
Top Bottom