Recent content by vicissitude

  1. V

    Query criteria based on combo box if combo box null

    I wonder if someone could help me with this one..... If i tie a query criteria in 'column1' to the value in a combo box like this.... Nz([forms]![FormName].[comboboxName],[column1]) ...then the query is filtered on the combo box or if the combo box is Null then the query gives all the results...
  2. V

    Passing a reference to a control on a subform to a function

    Nice one! Thats it! For some reason i had it in my head that you had to always do the whole reference thing from the main form down to the control no matter where you referenced it from. So you can just pass the control and nothing else, excellent. Thanks!
  3. V

    Passing a reference to a control on a subform to a function

    Yes i have a form and subform (datasheet style). Each row in the subform datasheet has a checkbox which is set yes by default. If this is clicked to 'unchecked' then the user is alerted to confirm choice via messagebox. So yes the code starts in the subform, and calls the function in the...
  4. V

    Passing a reference to a control on a subform to a function

    I was wondering if someone could give me a hand with this one.... I have referenced a control on a form from a function in a module using this: Forms(frm.Name).Controls(ctl.Name).Value The function looks like this: Function(frm as form, ctl as control) The function call looks like this: Call...
  5. V

    Conditional WHERE clause on form query

    O right IsNull is a Function...... didn't know that, Thanks
  6. V

    Conditional WHERE clause on form query

    Yea got it.... EndDate >=[forms]![Sessions].[txtWkBeginDate] Or [EndDate] Is Null Thats great, Thanks! For future reference what makes the difference between the IsNull and Is Null? Thanks
  7. V

    Conditional WHERE clause on form query

    the form has a 'week beginning date' and the records in the subform need to be filtered by that date, i.e. only records that should appear are ones that have a StartDate after the 'week beginning date' AND have a EndDate before ('week beginning date' +6) OR no EndDate at all. on the query...
  8. V

    Conditional WHERE clause on form query

    I wonder if someone could help me with this one, I have a from which has StartDate and EndDate fields. It also has a WeekBeginning unbound textbox. I want the form to filter on these dates so the form only displays the record if it is... a. after StartDate and before EndDate b. after...
  9. V

    Include name depending on start date and leave date

    I think i may have found the answer to my question... http://www.allenbrowne.com/ser-62.html
  10. V

    Include name depending on start date and leave date

    I wonder if someone could help me with this.... I have a table of names with start dates and leave dates, the leave dates may or may not exist depending on if they are still current. How would i go about writing a query to include names that have a start date before a specified date and have...
  11. V

    Access 2007 listbox column length

    What i mean is..... in an access 2003 listbox the column divider lines stop when the listbox list stops (makes sense / looks nice) But in access 2007 the column divider lines go all the way to the bottom of the listbox even if there is only one entry in the listbox (looks really messy) I...
  12. V

    Access 2007 listbox column length

    Is there any way to make the column lengths in an access 2007 listbox the same as in access 2003? Thanks.
  13. V

    Form record navigation slows down in Access 2003

    Thanks for the link! very interesting, Why is binding a recordset to a dummy table to keep the connection open different to having the one main form open all the time? Because my problem happens when the main form is constanly being used. Is it because it is not bound directly to the table?
  14. V

    Form record navigation slows down in Access 2003

    I have to get this thing to work in a satelite office where it is working down a vpn, the office has a 10meg broadband connection for 6 computers. That is good news (or maybe not) that it is the network that is the cause. I have had to completly redesign parts of it just to get it to work to any...
  15. V

    Form record navigation slows down in Access 2003

    Soz for the delay, not as normalised as i would like but best compromise i could come up with...
See more
Back
Top Bottom