Search results

  1. C

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

    Hey, yes I do. But I know the code is all wrong, I don’t know how to look up fields, tables etc to get the data I need. Also the if statement to check if the email field is empty. I know I am asking a lot, it’s my last few hours at work and my brain is fried. I understand if you and everyone...
  2. C

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

    I know the txtmessage msgbox works. That’s all lol
  3. C

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

    Hello, Firstly I know this doesn't work as I have taken bits of code from here, there, and everywhere. :D I was hoping to get the code cleaned up and working for me :) It needs to look at the form and specific fields to be able to gather the required information and insert into an email. '...
  4. C

    Solved Get existing value, Add value from another textbox for total

    Thank you so much! ' Check TxtAddMins is > 0 ' Take figure (mins) from TxtAddMins and add to TxtActualMins, TxtActualMins updates with total Private Sub BtnAddMins_Click() Dim addmins As Integer addmins = Nz(InputBox("How Many Minutes are you adding?", "Add Minutes", 0)) If addmins >...
  5. C

    Call a public function, Compile error: Argument not optional

    Thank you for the suggestions and knowledge, I think I am out of my depth with this one. I have added the function to the form, and I'll need to repeat for all of my date checks. Thanks again, appreciate it.
  6. C

    Call a public function, Compile error: Argument not optional

    Thank you.
  7. C

    Call a public function, Compile error: Argument not optional

    Thank you, Learning everyday.
  8. C

    Call a public function, Compile error: Argument not optional

    Hello, I wish to call on a Public Function from my Module_General This is the Function I wish to use: ' Check all dates on form to ensure they are not less than the delivery date (TxtCustomerPreferredDate). Public Function DateCheck(form_name As String) Dim txtmessage As String txtmessage = ""...
  9. C

    Solved Get existing value, Add value from another textbox for total

    Hello, I have been playing around with inputbox. I am not sure how to add the figure to the bound box. ' Check TxtAddMins is > 0 ' Take figure (mins) from TxtAddMins and add to TxtActualMins, TxtActualMins updates with total ' Clear TxtAddMins Private Sub BtnAddMins_Click() Dim txtmessage As...
  10. C

    Solved Get existing value, Add value from another textbox for total

    No Problem, Thank you.
  11. C

    Solved Get existing value, Add value from another textbox for total

    Hey mate, Just acknowledging, that’s all. Now I am working on suggestions 😁 I always put up the results and mark as solved. Stand by 👍🏽
  12. C

    Solved Get existing value, Add value from another textbox for total

    Hello, Nearly Xmas, hope everyone enjoys their holidays. :) I have a continuous form where I would like to enter a value in one box (not bound), click button and add that to the value of another textbox (Bound). This is what I have so far, not sure how to indicated where the value/Total is...
  13. C

    exporting to excel template

    Here is a sample DB I have also included the excel template workbook. I think It would be good to bring in the data on worksheet Ops_AssSchedFCastQ, deleting old data and replacing with new. Then The Results sheet stays in place and calculates off the Data sheet. What do you think?
  14. C

    exporting to excel template

    G'Day arnelgp, Am I able to ask you to elaborate on this for me please? This is my current code that just exports straight out into excel. (On vbYes) But I want to advance on this to open in an excel template where I will have formulas to calculate imported data. (If Possible) Private Sub...
  15. C

    sum, count, query in a report

    Not getting the figures mate. This is what I have put. SELECT JobInfoT.Scheduled, JobInfoT.JobTypeID, Sum(JobInfoT.Schedule_Mins) AS SumOfSchedule_Mins, Sum(JobInfoT.MachineShop_Mins) AS SumOfMachineShop_Mins, Sum(JobInfoT.AssemblyMins_Actual) AS SumOfAssemblyMins_Actual...
  16. C

    sum, count, query in a report

    and Would you say this is correct? SELECT Sum(JobInfoT.CC_Sheets) AS SumOfCC_Sheets, Sum(JobInfoT.CC_Sqm) AS SumOfCC_Sqm, Sum(JobInfoT.PFB_Sheets) AS SumOfPFB_Sheets, Sum(JobInfoT.PFB_Sqm) AS SumOfPFB_Sqm, Sum(JobInfoT.WhiteSatin_Sheets) AS SumOfWhiteSatin_Sheets, Sum(JobInfoT.WhiteSatin_Sqm)...
  17. C

    sum, count, query in a report

    Hmmm One more, this one is to count a specific ID being 7 "Shortage" and 8 "Rework" SELECT JobInfoT.Scheduled, JobInfoT.JobTypeID, Sum(JobInfoT.Schedule_Mins) AS SumOfSchedule_Mins, Sum(JobInfoT.MachineShop_Mins) AS SumOfMachineShop_Mins, Sum(JobInfoT.AssemblyMins_Actual) AS...
  18. C

    sum, count, query in a report

    SNAP!!! Thanks Legend... That's perfect :)
  19. C

    sum, count, query in a report

    Thanks Mate
  20. C

    sum, count, query in a report

    hello, Trying to sum up details of records between 2 dates. Most of it i think is working. I am trying to calculate how many [Assembly_Complete] (checkbox) are true and how many are false. Query is such: SQL: SELECT Sum(JobInfoT.AssemblyMins_Estimated) AS SumOfAssemblyMins_Estimated...
Back
Top Bottom