Search results for query: *

That still doesn't work, something I had not thought though. Cheers

I tried that but it didn't work either. I am using the listboxes as eachg one needs to be sourced form different queries and the textboxes don't seem to handle this so well. Cheers

Cheers I will sort it out in a few minutes - just getting rid of security etc etc. Cheers

Perhaps I am going about this the wrong way. I have a form that has 2 subforms, each subform has an options box. When an option is selected in either of the subforms a query reruns and returns a value (being the sum of all items selected) in a list box in the main form. 1 list box for each...

Sorry that was a typo, meant to be if it does not equal 0. I have tried your code both with =0 and <>0 but same thing occurs i.e. if the code is set to =0 and the result in the lstbox is 0 I get the message box (this is correct), so I then select another record in the sunform which causes the...

I have checked properties from the query which are definately values, I can't find any such propertires for the listbox but I have also tried it with different examples and changing the code to = to (say) 47.15 and then also as text &quot;47.15&quot; with no change to the results. I have also...

I keep getting the same true or false result when using if statement with listbox. I have a form, on the form are 3 listbox controls. 1st 2 return result from a query initiated on subforms. The 3rd is to be used for validation. I run a query over the results of Lstcont1 & Lstcont2 to get the...

I now have that sorted, trouble is it seems to think that it is fine and the code is simple enough. It appears that the code is running fie but it does not seem to assess the value in the control as part of the argument. You can see that I am asking to return a message box and then cancel any...

Access 2000 I have not had a lot of experience with VBA which is why I was using the Macros, but I have had to use some code already as I am fast learning the limitations of the macros. Cheers

I don't seem to have that functionality, I will look to install it if possible. Cheers

Hi I am having trouble with validation on exit of a form. I have a form that has 3 controls involved somehow in the validation. Cont1 is and amount being calculated depending on the users selection (using a query) Cont2 is the same as above but over another table Cont3 has a query over it...

I have it all sorted, thanks to your help! Thanks you VERY much Paddyo!!! Cheers

cOOL i HAVE IT ALMOST WORKING NOW oNLY PROBLEM i HAVE IS THAT WHEN i HIT THE 2ND OPTIONS BOX the 1st one stays selected the update does however, update the with the correct flag. If I leave the form it then updates the the checked box (i.e. have both options checked at this stage) to...

I went into the code builder through the mousedown event in the properties page, and them typed in the code but I have only used the field name (with no other reference to form or control or table) the group options box is bound to the field QQRNCLD. I can understand the 1st 2 events but I...

Cool, thanks I have got it sorted. Thanks for all your help. Cheers Brad

I have initialised the code but I get an error: expression on mousedown event....error: problem occurred while MS Accesswas communicating with OLE server or ActiveX control. * the expression may not result in use of macro or user defined function or [event procedure] * there may have been an...

I currently have an option group with 2 choices values update the field on the underlying table with 1 or 2. I have setup a query to calculate the value of all records populated with 1. I want this query to run each time an option has been chosen. I have the requery working fine but the...

I have the following working - provided you have both main and subforms to allow fliters in their properties and you don't use the macros. I had the same problem and found that you cannot action the requery from the subform using macros. you have to go to the action property then use the...

I have a requery function on a listbox. This runs fine when the listbox and the action (to tell when to requery) are in the main form. However if I base the action in the subform I get the error 'You can't use the ApplyFilter on this window' I have checked the properties on the main and...

I have the query sorted fine, it is just the auto requery I am having difficulty with. The way it is supposed to work is to auto requery after the user selects an option on the option group. (i.e. after the option group has updated the table) The problem I am having is actually getting the...