A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Auto-unchecking check boxes...



 
 
Thread Tools Display Modes
  #1  
Old May 28th, 2004, 11:26 AM
DubboPete
external usenet poster
 
Posts: n/a
Default Auto-unchecking check boxes...

Hi all,

I need to change [un-check] the value of one check box, if another related
one is clicked instead...

The checkboxes (labels) are callled

drinkstopyn (YES)
drinkstopyn1 (NO)

The question that accompanies the checkboxes is:
"Do you wish to stop consuming alcohol?"

Now whilst the thought of that question is abhorrent to many on the group,
insert smiley, there is a professional reason for asking the question, and
I need the people on the end of the mouse to be allowed to dither, and
change their minds... "yes? no? hmm?.."

In order for them to do this, I need the alternative checkbox to become
unchecked when the drunken basta.. ermm, person clicks his other choice.
So If he/she clicks YES, and then changes his/her mind and clicks NO, then
YES needs to be unclicked.

There is a specific reason for two checkboxes, as I want further prompts to
appear (or disappear and be replaced with the other one) as they click the
checkbox... I just can't get the logic going in my mind, and that's
probably due to me being a drunken basta.... ermm, tired on Friday night!

TIA

DubboPete
ps, it's -1°C in Central West New South Wales Australia, and the 'real'
winter chill isn't due till JULY!


  #2  
Old May 28th, 2004, 12:19 PM
Nick Coe \(UK\)
external usenet poster
 
Posts: n/a
Default Auto-unchecking check boxes...

DubboPete,
I never would've guessed you're an Aussie... :-))

Now, to alternate those y/n boxes put code into the
AfterUpdate event of each box which sets the other box.

For drinkstopyn use something like -
***Air Code****

If Me!drinkstopyn = False Then
Me!drinkstopyn1 = True
Else
Me!drinkstopyn = False
End If

***Air Code****

Change the names around for drinkstopyn1

Air Code?? It's like Air Guitar with a bit less arm
waving... :-))
--
Nick Coe (UK)
www.alphacos.co.uk

"DubboPete" wrote in
message ...
Hi all,

I need to change [un-check] the value of one check box, if

another related
one is clicked instead...

The checkboxes (labels) are callled

drinkstopyn (YES)
drinkstopyn1 (NO)

The question that accompanies the checkboxes is:
"Do you wish to stop consuming alcohol?"

Now whilst the thought of that question is abhorrent to

many on the group,
insert smiley, there is a professional reason for asking

the question, and
I need the people on the end of the mouse to be allowed to

dither, and
change their minds... "yes? no? hmm?.."

In order for them to do this, I need the alternative

checkbox to become
unchecked when the drunken basta.. ermm, person clicks his

other choice.
So If he/she clicks YES, and then changes his/her mind and

clicks NO, then
YES needs to be unclicked.

There is a specific reason for two checkboxes, as I want

further prompts to
appear (or disappear and be replaced with the other one)

as they click the
checkbox... I just can't get the logic going in my mind,

and that's
probably due to me being a drunken basta.... ermm, tired

on Friday night!

TIA

DubboPete
ps, it's -1°C in Central West New South Wales Australia,

and the 'real'
winter chill isn't due till JULY!




  #3  
Old May 28th, 2004, 12:25 PM
DubboPete
external usenet poster
 
Posts: n/a
Default Auto-unchecking check boxes...

works fantastic Nick, thanks mate

DubboPete
ps, I understand snip ***AIR CODE*** /snip and it's meaning! :-))

"Nick Coe (UK)" wrote in message
...
DubboPete,
I never would've guessed you're an Aussie... :-))

Now, to alternate those y/n boxes put code into the
AfterUpdate event of each box which sets the other box.

For drinkstopyn use something like -
***Air Code****

If Me!drinkstopyn = False Then
Me!drinkstopyn1 = True
Else
Me!drinkstopyn = False
End If

***Air Code****

Change the names around for drinkstopyn1

Air Code?? It's like Air Guitar with a bit less arm
waving... :-))
--
Nick Coe (UK)
www.alphacos.co.uk

"DubboPete" wrote in
message ...
Hi all,

I need to change [un-check] the value of one check box, if

another related
one is clicked instead...

The checkboxes (labels) are callled

drinkstopyn (YES)
drinkstopyn1 (NO)

The question that accompanies the checkboxes is:
"Do you wish to stop consuming alcohol?"

Now whilst the thought of that question is abhorrent to

many on the group,
insert smiley, there is a professional reason for asking

the question, and
I need the people on the end of the mouse to be allowed to

dither, and
change their minds... "yes? no? hmm?.."

In order for them to do this, I need the alternative

checkbox to become
unchecked when the drunken basta.. ermm, person clicks his

other choice.
So If he/she clicks YES, and then changes his/her mind and

clicks NO, then
YES needs to be unclicked.

There is a specific reason for two checkboxes, as I want

further prompts to
appear (or disappear and be replaced with the other one)

as they click the
checkbox... I just can't get the logic going in my mind,

and that's
probably due to me being a drunken basta.... ermm, tired

on Friday night!

TIA

DubboPete
ps, it's -1°C in Central West New South Wales Australia,

and the 'real'
winter chill isn't due till JULY!






 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:57 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.