Recent content by aftab1965

  1. A

    Help Required to calculate Hours and Minutes in a Query

    Bundle Of Thanks Sir, It works for me. Again Thanks
  2. A

    Help Required to calculate Hours and Minutes in a Query

    Thanks Sir, my requirement is as per "Second Case". I'm calculating individual time which can't be a negative value and will not exceed 1 day(23:59) but in summation it will exceed 1 day. for easy understanding I attached db herewith
  3. A

    Help Required to calculate Hours and Minutes in a Query

    Thanks for replying. As I mentioned in my post that I have tried 2 methods. ( Table 1 and Table 2) but required help is as per " Required Table". Thanks if you can help me
  4. A

    Help Required to calculate Hours and Minutes in a Query

    Dear Sir, I want to calculate time ( Based on Start Time and End Time) in a query (Sample db is attached) I tried couple of methods to achieve the required result. By setting up field to "Number" in Mehtod1 Table calculates as number but can't set as HH:NN. Method 2Table can't restrict input...
  5. A

    Restrict Duplicate Record

    Thanks all of you for a guidance.
  6. A

    Restrict Duplicate Record

    Thanks for your time, but same compile error again
  7. A

    Restrict Duplicate Record

    Thanks for an early reply. Its a compile error. Local_ID is Text field. If you have free time, Can you please share correct code
  8. A

    Restrict Duplicate Record

    If DCount("*", "[HistoryCM]", "[Local_ID] = '" & Me.Local_ID & "' AND [Noun] = '" & Me.Noun & "'") And Nz(Me.Status, 0) = 0 Or Nz(Me.Status, 0) <> "Open" > 0 Then MsgBox "The Corrective Maintenance of this Equipment is already Open. Open CM of An Equipment cannot be duplicated"...
  9. A

    Form Lock Before Status

    Thanks #Bob I always find you helpful.
  10. A

    Form Lock Before Status

    Sorry Brother! I'm not IT guy besides a Mechanical engineer and not used to be too much connected. I was trying to make a simple db in 2016 and till the time now I again tried Access after this much long period. I have never used Access since 2016. Moreover I know great heart people are here...
  11. A

    Form Lock Before Status

    Thanks for your reply. I'm new buddy to access and getting much from here. I acknowledge my weaknesses and trying to overcome. But it is urgently required if someone can help me.
  12. A

    Form Lock Before Status

    I need a help. (db Attached) Thanks for some friends especially “thedbguy” who shared codes to lock a form by a combobox. I disabled/ Locked a form by a combobox, it works but I want to check some fields, which should be populated before form lock as following; After selecting CLOSED from...
  13. A

    Solved Date Range Error

    I changed date formate in VBA, Form field and System to dd-mmm-yy and now is working. It may not allow if any of above setting is different. Thanks everyone and especially to Bob fitz
  14. A

    Solved Date Range Error

    Here is an interesting happening. I changed my system date format to mm/dd/yyyy. Now it work. But I'm using date format as DD. MM.YYYY in my region. SO, what should I do now with my db. Thanks for your time
  15. A

    Solved Date Range Error

    Dear Bob Fitz Thanks for your time and taking interest. I tried your attched db and added Date_Due to the form "Order By" Setting but unfortunately it does not work. Attached is the image of error.
Top Bottom