Recent content by ChrisJF

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...

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

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...

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...

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

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...

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?

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...

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...

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...

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

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...

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...

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...

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...