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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by ChrisJF

  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)"?

    Thanks Bill, so simple and staring me in the face.
  3. ChrisJF

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

    Thanks Bill, solved the problem. Will this feature be applied to this database, or is it a setting on the local version of access? Reason being, this database will be accessible to users from a server, and I want a solution which applies only to the database, rather than getting everyone to...
  4. 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...
  5. ChrisJF

    Adding "ALL" to Combo Box

    Tony, I have tried that but for some reason it spits out a null result, however, if I select a chapter from the Combo box the resulting dynaset is correct. It just seems to struggle with interpreting a null result (ALL) from the IIF statement. Any suggestions? ChrisJF
  6. ChrisJF

    Adding "ALL" to Combo Box

    Tony, Following on from above, I am using the following as criteria for the query taking an input from the combo box, IIf([Forms]![AdminSearch]![frmAdmChapterNo].value="ALL",Like "*",[Forms]![AdminSearch]![frmAdmChapterNo]) where frmAdmChapterNo is the Combo box. I have...
  7. ChrisJF

    Adding "ALL" to Combo Box

    Tony, I have done as you said, but when I select the ALL in the Combo box, and run the query which takes that value, I get no result. I suppose I have to use an IIF(...="all","*",....) type of solution. Any comments?
  8. ChrisJF

    Multiple Check Box Query Problem

    scriverb, Thanks for the code, but it only seems to work if all boxes are checked, returning a dynaset with only records where at least 1 box is checked in the table, or if none are selected, all table results are returned. When you select a combination of check boxes, the query still returns...
  9. 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...
  10. ChrisJF

    Adding "ALL" to Combo Box

    Hi there, this looks promising, will this replace the default blank screen on a combo box when the form is opened? I am having problems interpreting and applying the above code to my application. I am trying to replace the Blank combo box with "ALL", without the need for ALL to exist...
  11. ChrisJF

    Export data in Access form to Excel ?

    MrPeds, Can you please post that code. This is something I am looking at, especially the use of VBA to manipulate the cells in Excel. Regards, ChrisJF
  12. ChrisJF

    Help: Combo Box handling Null values?

    judgehopkins, Thanks v much. I had a quick look and have used (Like "*" & [Forms]![7000_ManualSettle_Select_frm]![txtContractID] & "*") Or nz([Forms]![7000_ManualSettle_Select_frm]![txtContractID],"")="") as a solution. It seems to work at the moment...
  13. 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...
  14. ChrisJF

    Keeping a copy of the old record being edited

    Thanks for the comments, I have given all the above some serious thought. I believe the best way to go is to have an archive table which is appended with the original record pre update. My database uses a query to output results in a form. Whenever a record in that form is edited, I want to...
  15. 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...
See more

Part and Inventory Search

Back
Top