Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ChrisJF
  • Content: Threads
  • Order by date
  1. ChrisJF

    Handling nz() in an IIF statement?

    Hi there, this problem is driving me crazy! Background: I have a combo box which is bound to one field in a table. It is used to select a value as an input for criteria of a query. When the combo box on the form was blank, I used the following criteria in the query to produce all results...
  2. ChrisJF

    Combo Box handling of Text string"(c)"?

    Hi there, help is required. I have a combo box which uses an underlying field in a table which has clause numbers ..e.g. 2.3(a) etc..., the problem is that if the value selected has "(c)" in it, it turns this into a copyright symbol. The result is that the value selected in the combo...
  3. ChrisJF

    Multiple Check Box Query Problem

    Hi all, I have a problem which I can't get my head around. I have a form which has 5 check boxes on it. cbxNetwork cbxSystemOperation cbxCommercial cbxEngineering cbxBusinessResources The check boxes are not currently bound to the underlying table/query. I have a table with other fields but...
  4. ChrisJF

    Help: Combo Box handling Null values?

    Hi, I am using a series of combo boxes on a form as selection criteria for a query. e.g Query criteria in QBE grid (like "*" & [Forms]![Scenario]![group] &"*") I am using GroupBy on the SQL queries for each combo box so they does not display duplicates. Problem seems to...
  5. ChrisJF

    Keeping a copy of the old record being edited

    Hi there, there may be a simple answer out there, but I want to keep an original copy of the record being edited/changed. I believe that any code would have to be done against the beforeupdate event of the form involved. I need this for audit trail purposes. Is it possible by using a macro...
  6. ChrisJF

    Clicking in a Subform to launch another linked Form

    Hi there, I have a subform which lists data. I want to be able to click on the subform record to launch another form with more detailed information relating to that record. Is there an elegant solution out there? Thanks

Part and Inventory Search

Back
Top