Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by jamaarneen

  1. jamaarneen

    Wifi repeater can connect to internet but not to the printer

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

    surpress error -‏21473525‏

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

    surpress error -‏21473525‏

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

    sum of a few boolean fields in a query

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

    sum of a few boolean fields in a query

    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(...
  6. jamaarneen

    using calculation as control source

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

    using calculation as control source

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

    Controls are not reacting to events

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

    Controls are not reacting to events

    Sorry to ask, but do i enable VBA?
  10. jamaarneen

    Controls are not reacting to events

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

    Conditional Formatting to Make Visible?

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

    how to preserve a value after closing the database

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

    how to preserve a value after closing the database

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

    DLookup function is swaping dates

    Thanks - both - for the explanation.
  15. jamaarneen

    DLookup function is swaping dates

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

Part and Inventory Search

Back
Top