Search results for query: *

Thanks. It seems You did understand the problem, And got the right solution. It works!

Hi I'm updating a chekbox from a textbox-event My form is bound. continuous. There are 3 textbones (bounded), and a CheckBox (bound to a bool field). If ONE of the textboxes has a value > 0, then the checkbox should be true. else, false. This should be triggerd by the change_event of the...

Great, PHV. As always. It gives -1 / 0, but it will do it Thanks

Hi In my table I have some boolean fields. I would like to create a column in a query, that tells me if there is at least one of the booleans fields that are 'true'. I tried to write (in query design view) somthing like that: NewColumnName:= IIf ( ([blField_1]) = -1) Or [blField_2] = -1) Or(...

Yes, Duane, [Field 1] is the name of a field in the form's record source. And, no, the name of the control is not the name of any field. But I did something,and it is working (for now...) I actually have more then one field. so i was triyng different ways: for field 1 it was refering to the...

Hi There are some threads about this, but stil cannot get it: In the form-header of a bound form - continuous, I have a text box. I want it to give me the sum of a field. So I'm trying to put a Sum() function as the Control source, but I'm getting an #error. =Sum([Field 1]) Field 1 is the...

OK. I got it!!! I haven't notice this warning about disableing... we are getting used to SO many warnings.. Thanks anyway!!!

Sorry to ask, but do i enable VBA?

Hi For a long time I did'nt work with Access. Now I'm back (first time with 2007...) I'm working on a bound form. continous mode. I wrote some code to the events (click, BeforeUpdate...) of some controls (CheckBox, TextBox) but nothing happens. I even tried with breakpoints in the code, but it...

This is a challenging question. I don't think that there really is such a thing "no solution". So let's not give up. let's hope - and wait - for an interesting solution from one of the more experienced members in here.

Thanks Remou, this worked out (with a little home work of mine). But i still want to understand: I tried in the 'AfterUpdate' event OptionGroup, to change his 'DefaultValue' , so it should open next time with this value, and it DID NOT work. Why? Thanks ja

Hi Is there a possibility to preserve a value after closing the DB - other then storing it in a table? I have an 'option group' on a form, what hes value is been put to a global variable. I would like to keep the choice the user made , for the next time he is opening the database. how can this...

Thanks - both - for the explanation.

Thanks a lot Duane and PHV both suggestions are working perfectly (and all blank records - disappear too!) While I read in the link Duane mentioned that Access expects the "mm/dd/yyyy" format, I'm wondering Why PHV's suggestion works too? And one more: Allen Browne is recommending always to...

Hi I have a simple DLookup function to retrieve data from one field, based on a 'date' in another field. it's almost working fine, but there is a problem: the function is swapping two dates: for the date 9/5/2009 (which means 9 May), he returns the value for 5/9/2009 (= 5/Sep). In the table's...

kcmass, my specific problem is with Hebrew Months/weeks/..., but your your suggestion to work with an array, gives a nice idea. I'm trying something more in the direction of generating a query - PHV's suggestion - because this might give me more possibility to work with some more data out of...

OK. I'm glad I got the lesson The next step will be, how to combine this with some other functionality (there is a thread going on "Using Count to return 0 when no records returned". You can see there my reply) And the second - and important thing - how to work this out with some other value -...

Remou: one thing that I don't understand. you mean a table with 12 records only (Jan ... Dec) ? but what if Someone wants to get the above result for a period of 26 months? 5there is a thread I started going on, with a similar problem. you can respond there.) Thanks Ja

Thanks a lot PHV (for the first lesson... :-) ) a star.. 1) If I understand right, the 'units' and the 'Tens' are to create values until 99 (and so on is possible withe "C = Hundreds") sorry, in the begin i did'nt realised that the tblIntegre should have all single numerics) 2) i still don't...

You're right PHV, but I would very appreciate some explanation. It's always great to learn from experienced people