Recent content by DrDance

Ken, Thanks for your help thus far. I have this in my code: Private Sub List672_AfterUpdate() Dim ctl As Control Dim itm As Variant Set ctl = List672 txtList = "" For Each itm In ctl.ItemsSelected txtList = txtList & ",'" & ctl.ItemData(itm) & "'" Next itm txtList = Mid(txtList, 2) End...

Ken, This is still unsolved if you can still help me. Thanks.

Ken, I'm a complete newbie to coding, so I only pasted what was given, that must be why I get the error. I get runtime error 438 - Object does not support this property or method.

Thanks for the reply Ken, I'm getting and error message though which is coming from this part of the code: for each itm in lstBox My query is in design view as a code builder, but I have the multiselect query as SQL, as per a tutorial I found on another site.

Hi guys, I have a form which has two command buttons. One command button runs a query which displays the corresponding results in datasheet view. The other command button runs another query which displays another form displaying calculations. Both queries get their data from text boxes...

Golom, You certainly pointed me in the right direction - thanks very much. Although I couldn't get your code to work, here is the adapted solution which may not be perfect, but seems to work very well: WHERE (((tblFIELD.SEX) Like IIf([Forms]![SEARCH]![Check428]="0" And...

Golom, Thankyou so much for your hekp and explanation, this is exactly what I was looking for. I have a problem with SQL though, not sure where to put this. When I put it into the SQL view, it said "syntax error (missing operator) in query expression..." Could you tell me what I should do...

O.K. I found the SQL part, but it seems a little mixed up anyway... =IIf([Forms]![SEARCH]![Check428]="0" And [Forms]![SEARCH]![Check430]="0" And [Forms]![SEARCH]![Check432]="0" And [Forms]![SEARCH]![Check434]="0" And [Forms]![SEARCH]![Check436]="0","*")) AND ((tblFIELD.TRAINER) Like...

Have a real problem with checkboxes in a query. I have all the query fine for when all or one or even some of the checkboxes are ticked. The problem occurs if no checkboxes are ticked, for some reason it won't show all records. EXAMPLE: "TRYING TO SHOW ALL RECORDS IF ALL BOXES ARE NOT...

Got a very weird bug with installation of Office XP. Here's the scenario: I had Win98 installed and Office XP. Uninstalled Office XP. Upgraded to Windows XP and trying to re-install Office XP. The setup wizard will not go any further when I hit the next button and the browse button is...

Hi all, I have a table with a column for SEX of horses denoted as g (for gelding), c (for colt), f (for filly) etc etc. I have a combo box linked to a query and this is what I have as my query syntax. Like...

SOLUTION FOR ANYONE SEARCHING LATER.... Substitute was right with his formula between Nz([Forms]![SEARCH]![TABMin],0) and Nz([Forms]![SEARCH]![TABMax],999999) BUT - my problem was that not all records were populated by a TAB value, therefore it only showed those records where a value lay...

Thanks for the reply substitute, You are right it is an integer. I tried your suggestion but it's not returning any records for some reason. I should add that only certain records contain a value for TABMin or TABMax eg. Number RES TAB 1 1 3 2 2 3 3 4...

Hi guys, I've searched everywhere for this one, so any help appreciated. I have a form with minimum and maximum parameters for a query and if EITHER of the minimum or maximum fields or both of them are left blank, then it should return all records. Here is my criteria: Between...