Recent content by jamaarneen

Hi. My laptop was connected wireless to a network at my work, I was able to connect to internet, and to another pc and a printer which are connected to the same network. Now i have a wifi repeater. The repeater is connected to the network and my laptop is connected to the repeater (all...

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