Search results

  1. D

    Closing a form that isn't open :|

    I have a form that is open, and needs to be closed at certain point in certain macros. However, sometimes the form is already closed when the macro calls for it to be closed. Can I just do something to ignore the error message saying the form can't be found, or is there a way of putting a...
  2. D

    Code to select second column from Combo box

    I have a combo box with data source as a query. I want to select another field in the query from the record which is currently selected to use. Is there an easy way to do this? Thanks, Paul
  3. D

    Simple query question: setting a field to a set value

    Putting this in the field box in a query: read or write: "r" should create a field called read or write with a value of r in each record in the query, shouldn't it? Why doesn't it, and how can I make it work? Cheers, Paul
  4. D

    Using IIF function in query?

    I have a field in a query that I want to select the value from a field, but if the value is null, then to select the value from the same named field in a different table. Basically the whole point is to use the given description unless one doesnt exist, where the default one will be inserted...
  5. D

    Append Query help

    Hi guys, I'm modifying a database slightly, trying to edit without really understanding the entire functionality of the system. Basically I have an append query where a set of default data is added to a table containing modified values. So if you had created A and C entries in the table...
Top Bottom