Search results

  1. C

    Solved Incorrect Date formats

    Is there a way to include (wrap around) each of these functions for format date? Would that work? I've added this code in the AddDays and also the GetDays function. But doesn't solve problem. AddDays = Day(dtdate) & "/" & Month(dtdate) & "/" & Year(dtdate)
  2. C

    Solved Incorrect Date formats

    Hello, There are other functions (AddDays, GetDays) that look at dates to see what dates are working days, weekends, holidays. Adds or minus a day depending.
  3. C

    Solved Incorrect Date formats

    Set to Australia
  4. C

    Solved Incorrect Date formats

    Hello, Having some random issues with dates. I have removed any date formatting in the actual table for dates. I have set the form properties to show Med Date format. Where I am we use DD/MM/YYYY as opposed to the American format. Some dates are coming thru correct as per sample below: (Look at...
  5. C

    multiple checks before an action

    yes, bugga.. ok getting message box now, thank you.. but not getting any action on the complete now equals true if txthinge is not 0 Have I written this correctly? with the else then the other ifs, with another else? Doesn't look right or clean, especially as I will be adding more checks. thanks
  6. C

    multiple checks before an action

    Stepping thru, txtmessage is saying 0 instead of the message then skips over the check complete value at the end. if hingedrill is complete, the function stops working all together.
  7. C

    multiple checks before an action

    Hello, I have some code which works perfectly for what I want. (This is it below) Private Sub LblPShop_Complete_Click() If ChkPShop_Complete = True Then Dim iResponse As String 'Ask if they are sure they want to change it and store their response in iResponse...
  8. C

    Solved Item cannot be found in the collection corresponding to the request.....

    Morning everyone. Believe it not I found the issue. It was a simple naming convention that didn't match the table. :( Didn't change anything with the dates, its putting dates in now.. thank you for all your input, appreciate it.
  9. C

    Solved Item cannot be found in the collection corresponding to the request.....

    Ok, Thank you. Ill see if i can work that out. Ill keep you in the loop.
  10. C

    Solved Item cannot be found in the collection corresponding to the request.....

  11. C

    Solved Item cannot be found in the collection corresponding to the request.....

    Morning Men, I have made some progress, managed to get the lead Date populating now. However still getting a "Run-time error '3061': Too fe parameters, Expected 1. Not sure what this means. When I debug print it looks like I am getting the dates. (Shown below) UPDATE JobInfoT SET IFA_Due =...
  12. C

    Solved Item cannot be found in the collection corresponding to the request.....

    Ok, I'm on it. Ill be back, Thanks Men
  13. C

    Solved Item cannot be found in the collection corresponding to the request.....

    '------------------------------------------------------------ 'Job Type Lead Times *****(Working on)****** ' '------------------------------------------------------------ Private Sub CboJobTypeID_Click() Dim db As Database Dim sql As String Dim con As Object Dim rs As...
  14. C

    Solved Item cannot be found in the collection corresponding to the request.....

    "look at the second line of your 2nd sql, you have a SET there:" Hmm Yes I saw that too and have removed it. Ok, Ill try and start again. I have had this work in another db, but I have changed things around in this one. Here is the form with the due dates that need populating Here is the...
  15. C

    Solved Item cannot be found in the collection corresponding to the request.....

    G'Day, The highlighted section returns sql = "SELECT Lead_Date FROM JobTypesT WHERE JobTypesID = 2" Which is correct. The next section dValue = rs(0) I belive this should be a number like 3 In the JobInfoT the fields such as Lead_Date or IFA_Due these are date fields. In the JobTypesT the...
  16. C

    Solved Item cannot be found in the collection corresponding to the request.....

    Thank you, Yes same form.
  17. C

    Solved Item cannot be found in the collection corresponding to the request.....

    G'Day, Thank you for the reply, I tried changing that. Still same error.
  18. C

    Solved Item cannot be found in the collection corresponding to the request.....

    Hello, I have a Table "JobTypesT" and another Table "JobInfoT" JobInfoT holds all the information of the Job. JobTypesT holds a certain amount of days depending on the job type and then the process type. I am trying to achieve, look at one date then get the days from JobTypesT where they...
  19. C

    Surely there is an easier way, Lots of Check Boxes and with same code

    Hello, Looking for an easier and cleaner way to put in some code. If there's not, never mind ill keep copy and pasting. :-( I have a form, multiple check boxes. when ticked puts in date in text box. when unticked asks if your sure then removes date and tick. I have sooooooo many Checkboxes...
  20. C

    Solved Option Group, Sorting Form based on selection

    Actually I think it does it on its own. thanks mate.
Back
Top Bottom