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!

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

Search results for query: *

  1. jamaarneen

    surpress error -‏21473525‏

    Thanks. It seems You did understand the problem, And got the right solution. It works!
  2. 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...
  3. jamaarneen

    sum of a few boolean fields in a query

    Great, PHV. As always. It gives -1 / 0, but it will do it Thanks
  4. 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(...
  5. 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...
  6. 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...
  7. 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!!!
  8. jamaarneen

    Controls are not reacting to events

    Sorry to ask, but do i enable VBA?
  9. 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...
  10. 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.
  11. 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
  12. 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...
  13. jamaarneen

    DLookup function is swaping dates

    Thanks - both - for the explanation.
  14. 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...
  15. jamaarneen

    DLookup function is swaping dates

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

    Generating a query - not based on a table

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

    Generating a query - not based on a table

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

    Using Count to return 0 when no records returned

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

    Generating a query - not based on a table

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

    Generating a query - not based on a table

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

Part and Inventory Search

Back
Top