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...
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...
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 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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.