Recent content by Zuzu

  1. Z

    parameter query for date range

    Awesome guys.... thanks very much for the help. That example you linked to Sneuberg is exactly what i want. Cheers!
  2. Z

    parameter query for date range

    Hello all I am trying to write a parameter query that shows me what equipment is booked during a specific time range. For example, the booking table is setup with the EquipmentID, FROMDATE and THRUDATE. EQIUPMENT..........FROMDATE......THRUDATE Equipment A..........1/2/17..........28/2/17...
  3. Z

    Problem with text box positioning

    G'day JHB Was wondering if you were going to have a look at this problem! Once again, very appreciative for the assistance, you are a fantastic forum user that has helped me countless times! I see what you did toi fix it, however don't understand why that fixed the problem??? Secondly, i...
  4. Z

    Problem with text box positioning

    Hello I have been playing around with a timeline report database i found which populates a report in a fashion similar to a gantt chart. I can get most of it to work, but am having a problem for the grow box to position itself correctly. If you look at the attached example, for Event 2, the...
  5. Z

    Need a VBA guru to help solve a problem

    JHB Once again... a big thank you! This is the first time i am using an unbound form, so it has been a big learning experience for me. You will have noticed some temporary text fields i placed on the right hand side of the form to see if i get could the data from the booking... and happy that...
  6. Z

    Need a VBA guru to help solve a problem

    Hello I am trying to make a small equipment booking form. The form is unbound, and has a fair bit of vba behind it. I have modified this from a working example that was posted to the public domain some time ago. My problem is this: The original form only had 10 rows in it for equipment. I...
  7. Z

    Form does not update correctly

    Champion..... Once again JHB, thank you very much!
  8. Z

    Form does not update correctly

    Sorry.... i am a moron! See that it is already working correctly......... been staring at the screen too long today. For my own learning however, can you explain / tell me what you changed to get it to work correctly? Thank you very much for the help! Cheers Zuzu
  9. Z

    Form does not update correctly

    Awesome JHB. Sorry to bother you again however.... but is there anyway to have it setup for non-americanised dates? using this format: dd/mm/yyyy
  10. Z

    Form does not update correctly

    User guide for the form attached....
  11. Z

    Form does not update correctly

    Hello Hoping someone with a lot more VBA knowledge than myself can help. I am building a small scheduling DB, and have been trawling this site to find some examples. Eventually stumbled upon a great concept form that is essentially a booking calendar. I have attached the database and the user...
  12. Z

    Search box to search from a subform query

    Static and Moke123 Thank you very much for the help...... really appreciated!!!
  13. Z

    Search box to search from a subform query

    Sorry... Still cannot get it to work. I have attached a copy of the Search form - hoping that someone can show me where i am going wrong. Cheers Zuzu
  14. Z

    Search box to search from a subform query

    Hello all I am having some trouble with getting a search box to work on a search form. Initially, the form was setup with the query on the main form, and the following code below returned the correct search results. Dim strsearch As String Dim Task As String 'Check if a keyword entered or...
  15. Z

    Checkbox Form Filter

    Awesome Exactly what i needed....... Thank you very much for your help!
Back
Top Bottom