Search results

  1. A

    Dcount in field on form

    the between DateSerial worked like a charm! Thank You Arnel!!:D
  2. A

    Dcount in field on form

    i cant post links yet, so just added some spaces in between the https h t tps://od.lk/d/MzZfMTU3OTMwMjlf/TMPD_be.accdb
  3. A

    Dcount in field on form

    im starting to hate vb :mad: h t t p s ://od.lk/d/MzZfMTU3OTMwMjlf/TMPD_be.accdb
  4. A

    Dcount in field on form

    Thank You fro your reply. I have two options to use. 1. make a query, and get the results 2. run the vba from textbox and get the results the main problem with the query, (the included sql) is that the query counts all the NOT NULL records. I am not sure how to specify the results only to be...
  5. A

    Dcount in field on form

    Thx for the suggestion ArnelGp, but that open the Criteria error can of worms again, Data type mismatch error 3464. has to be something with the ""&'""''"" etc etc .
  6. A

    Dcount in field on form

    Hi guys, I am doing my bit to help local LEO's and designing a db for them. I am currently struggling with a small syntax issue, which is bringing me to a grinding halt. I have a textbox on a form which needs to give me a DCOUNT based on another textbox. I used a query, and got some results...
Top Bottom