MSFN Forum: Check box in Tabular Form ? - MSFN Forum

Jump to content



Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Check box in Tabular Form ? Rate Topic: -----

#1 User is offline   neo 

  • Microsoft MVP - Windows Expert Consumer
  • PipPipPipPipPipPip
  • Group: Members
  • Posts: 1,251
  • Joined: 31-March 06
  • OS:Windows 7 x86
  • Country: Country Flag

  Posted 02 November 2007 - 12:51 PM

Hi friends.
I hav a little bit of confusion about Access Database. I have created a database contains a single table (consists of five fields)
A Tabular Form has been created using Form Wizard. The table having two "Yes/No" data type that can contain only n only 0 and 1. Now the form is in tabular form... I have coded some VB code for manipulation of data. I want to set Uncheck all check boxes at startup, I mean...What should I code in Form_Load() function.

I have tried this
S1.Value=0
S2.value=0

It unchecks upper first checkboxes only. Rest of grid having same state and doesn't change.
But I have also used this code to disable these checkboxes and whole grid of checkboxex can be disabled.

S1.Enabled=0
S2.Enabled=0

If Its not possible using VB code...Please give any UPDATE query that SET S1 and S2 to zero via calling some function name like UpdateCheckBox()

Help Me Please !!!

http://www.sendspace.com/file/rmf128
Here is the sample access database file


#2 User is offline   neo 

  • Microsoft MVP - Windows Expert Consumer
  • PipPipPipPipPipPip
  • Group: Members
  • Posts: 1,251
  • Joined: 31-March 06
  • OS:Windows 7 x86
  • Country: Country Flag

Posted 04 November 2007 - 12:05 PM

Help me please !!!

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users



All trademarks mentioned on this page are the property of their respective owners
Copyright © 2001 - 2011 msfn.org
Privacy Policy