Search results

  1. K

    QueryDefs and Openquery

    Hi everyone, I am writing a VBA code to try and modify my query criterion and I'm using QueryDefs and Parameters for that. Unfortunately, I have run into 2 problems: 1) I need to use a conditional criterion, e.g. >date( )-7 and I don't know how to use Parameters for a criterion that is neither...
  2. K

    Dynamic update of report

    Hello, I have report with a query as record source. The problem is that if I edit the query, for example remove a field, the report does not update itself and only shows the previous query. Is there a way to make the report update itself without having me to go through the wizard every time...
  3. K

    Open subform in a new window

    Hi, I have browsed around and I have seen this question pop up quite often, but I can't seem to find a working solution for me. I would like to have a button that opens a subform in a new window, while keeping all the child/master relations. I have seen this example from one of the entries on...
  4. K

    Multiple Combo boxes and selections not repeated

    Hi, I have 2 combo boxes in my form that are related to the same query. This means that they have the same selections in the drop down. Is it possible to have the drop down for the second combo box to update itself such that the selection made in combo box 1 does not appear? Thanks a lot for...
Back
Top Bottom