Ad:

VB.NET Discussion Thread
Unsolved
Views: 3213

Oct 8th, 2007

Checkbox on database

Expand Post »

Hi there

I'm now using Microsoft Access and i have a column called VT. I stored it into a variable called vibrotactile.

vibrotactile = ds.Tables("maskingSimulator").Rows(s).Item("VT")

The problem is the column contains checkboxes. If my VT column is not checked, it will carry out Case 1. Else, if my VT column is checked, it will carry out Case 2. How do i put it into codes? I tried to put 'if vibrotactile = false' and 'if vibrotactile = true'. But it doesn't seem to work. How do i go about it?

VB.NET Syntax (Toggle Plain Text)
 
                If vibrotactile = False Then
                'Case 1
                acTestEarThreshold = acTestEarThreshold
                End If
 
                If vibrotactile = True Then
                'Case 2
                        If acTestEarThreshold <= 20 Then
                        acTestEarThreshold = acTestEarThreshold
 
                        ElseIf acTestEarThreshold > 20 Then
                        acTestEarThreshold = 20
                        End If
                End If
      
                If vibrotactile = False Then
                'Case 1
                acTestEarThreshold = acTestEarThreshold
                End If

                If vibrotactile = True Then
                'Case 2
                        If acTestEarThreshold <= 20 Then
                        acTestEarThreshold = acTestEarThreshold

                        ElseIf acTestEarThreshold > 20 Then
                        acTestEarThreshold = 20
                        End If
                End If

Similar Threads

inserting multiple selection from checkbox in to one column in JSP
Custom Database Admin Tool. in PHP
urgent... in VB.NET
submiting info into a database for retrieval! in PHP
passing checkbox value to next page in PHP

mustoora

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

23 posts
since Jul 2007

Permalink

Oct 9th, 2007

Re: Checkbox on database

Click to Expand / Collapse Quote originally posted by mustoora ...

Hi there

I'm now using Microsoft Access and i have a column called VT. I stored it into a variable called vibrotactile.

vibrotactile = ds.Tables("maskingSimulator").Rows(s).Item("VT")

The problem is the column contains checkboxes. If my VT column is not checked, it will carry out Case 1. Else, if my VT column is checked, it will carry out Case 2. How do i put it into codes? I tried to put 'if vibrotactile = false' and 'if vibrotactile = true'. But it doesn't seem to work. How do i go about it?
VB.NET Syntax (Toggle Plain Text)
 
                If vibrotactile = False Then
                'Case 1
                acTestEarThreshold = acTestEarThreshold
                End If
 
                If vibrotactile = True Then
                'Case 2
                        If acTestEarThreshold <= 20 Then
                        acTestEarThreshold = acTestEarThreshold
 
                        ElseIf acTestEarThreshold > 20 Then
                        acTestEarThreshold = 20
                        End If
                End If
If vibrotactile = False Then 'Case 1 acTestEarThreshold = acTestEarThreshold End If If vibrotactile = True Then 'Case 2 If acTestEarThreshold <= 20 Then acTestEarThreshold = acTestEarThreshold ElseIf acTestEarThreshold > 20 Then acTestEarThreshold = 20 End If End If

You haven't mentioned or used the checkbox any where in your code. Any ways, Your check box may got some other ID but Im using here yourCheckBox as an ID.

So Now,

If vibrotactile.yourCheckBox.checked = False Then
'Case 1
acTestEarThreshold = acTestEarThreshold
End If

If vibrotactile.yourCheckBox.checked = True Then
'Case 2
If acTestEarThreshold <= 20 Then
acTestEarThreshold = acTestEarThreshold

ElseIf acTestEarThreshold > 20 Then
acTestEarThreshold = 20
End If
End If

I Hope it'll work.

shikeb

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

26 posts
since Jul 2007

Permalink

Oct 9th, 2007

Re: Checkbox on database

Hi

What is the type of column "VT"; if it is not of type "bit" probably the FALSE - TRUE statements won't work. Otherwise it should work.

I make the same evaluation but i use a dataview instead and it works fine, but I don't see any reason it would not work with the table directly.

williamrojas78

Reputation Points: 23

Solved Threads: 10

Junior Poster

Offline

111 posts
since Jun 2005

Permalink

Oct 10th, 2007

Re: Checkbox on database

Hi

thanks for replying. I tried putting the checkbox ID but it doesn't work. Wriggly lines appeared. It says 'VT is not a member of string'. I declared 'vibrotactile' as String. Is it correct?

I checked the properties of my 'VT' column. The data type states that 'Yes/No'.

mustoora

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

23 posts
since Jul 2007

Permalink

Oct 10th, 2007

Re: Checkbox on database

Hi,

have ya tried to convert it to boolean ... because the True false property of CheckBox only works in that condition.

shikeb

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

26 posts
since Jul 2007

Permalink

Oct 10th, 2007

Re: Checkbox on database

Hi again,
fortunately I managed to run it ... but i did it in C#, its like this,

VB.NET Syntax (Toggle Plain Text)
 if (vibrotactile.myCheckBox.Checked == false)
      {
             acTestEarThreshold = acTestEarThreshold;
       }
else 
      {
        If (acTestEarThreshold <= 20)
                       {
                         acTestEarThreshold = acTestEarThreshold;
                        }  
       else
                        {                   
                         acTestEarThreshold = 20;
                         }
 
       }
 if (vibrotactile.myCheckBox.Checked == false)
      {
             acTestEarThreshold = acTestEarThreshold;
       }
else 
      {
        If (acTestEarThreshold <= 20)
                       {
                         acTestEarThreshold = acTestEarThreshold;
                        }  
       else
                        {                   
                         acTestEarThreshold = 20;
                         }

       }

It was working fine.
I Hope you'll get something out from it and that it'll work for you.

shikeb

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

26 posts
since Jul 2007

Permalink

Oct 18th, 2007

Re: Checkbox on database

Hi

thanks for the help. Really appreciate it. I've managed to get it out. Here's what i did to it

VB.NET Syntax (Toggle Plain Text)
         If vibrotactile Then
             'Case 2
              If acTestEarThreshold <= 20 Then
                  acTestEarThreshold = acTestEarThreshold
 
               ElseIf acTestEarThreshold > 20 Then
                        acTestEarThreshold = 20
               End If
 
         Else
              'Case 1
               acTestEarThreshold = acTestEarThreshold
               End If
 
         End If
         If vibrotactile Then
             'Case 2
              If acTestEarThreshold <= 20 Then
                  acTestEarThreshold = acTestEarThreshold

               ElseIf acTestEarThreshold > 20 Then
                        acTestEarThreshold = 20
               End If
   
         Else
              'Case 1
               acTestEarThreshold = acTestEarThreshold
               End If

         End If

mustoora

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

23 posts
since Jul 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in VB.NET Forum Timeline: Crystal report setconnection and parameter problem

Next Thread in VB.NET Forum Timeline: Audio file

DaniWeb Message

Cancel Changes

User Name
Password