Check Box Issues

[Daytona Steve]

I am working with expression web and have designed a form that feeds an
Access (2002) DB. There are several check boxes on the form. When they are
checked, it produces the word "True", Not checked = False.

As a point of reference, I know absolutely nothing about DB other than what
I need to display results on the web.

Instead of the word "True" I'd like it to say "OK" and with no checked box
I'd like it to be emply.

With slight modification, I found an answer here from 2007 except I have no
idea where to put this code.

If Me![CheckBoxName] = True then

[Me![OtherControlName] = "X"
Else
[Me![OtherControlName] = Null
End If

I assume checkboxname is the column name. I have no idea what the
otherControlName is.

Any help at the 3rd grade level would be appreciated. I did post this on
the EW forum, so far no joy.

 

[Arvin Meyer [MVP]]

The code would be in the AfterUpdate event. Open your form in Design View
select the checkbox and open the property sheet if it isn't already open.
Now in the Events tab, find the AfterUpdate event and click the down arrow,
choosing:

[Event Procedure]

then click the ellipses (...) at the end. You'll see the code window open
with:

Private Sub CheckBoxName_AfterUpdate()

End Sub

put the following in so that it looks like:

Private Sub CheckBoxName_AfterUpdate()
If Me.[CheckBoxName] = True Then
Me.[OtherControlName] = "OK"
Else
Me.[OtherControlName] = ""
End If
End Sub

Of course you'll need to substitute the correct control names.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

I am working with expression web and have designed a form that feeds an
Access (2002) DB. There are several check boxes on the form. When they
are
checked, it produces the word "True", Not checked = False.

As a point of reference, I know absolutely nothing about DB other than
what
I need to display results on the web.

Instead of the word "True" I'd like it to say "OK" and with no checked box
I'd like it to be emply.

With slight modification, I found an answer here from 2007 except I have
no
idea where to put this code.

If Me![CheckBoxName] = True then

[Me![OtherControlName] = "X"
Else
[Me![OtherControlName] = Null
End If

I assume checkboxname is the column name. I have no idea what the
otherControlName is.

Any help at the 3rd grade level would be appreciated. I did post this on
the EW forum, so far no joy.

 

[Daytona Steve]

I thought I did this right but no joy,

Private Sub CheckBoxName_AfterUpdate()
If Me.[Ctl1x] = True Then
Me.[Ctl1xread] = "OK"
Else
Me.[Ctl1xread] = ""
End If
End Sub

The code would be in the AfterUpdate event. Open your form in Design View
select the checkbox and open the property sheet if it isn't already open.
Now in the Events tab, find the AfterUpdate event and click the down arrow,
choosing:

[Event Procedure]

then click the ellipses (...) at the end. You'll see the code window open
with:

Private Sub CheckBoxName_AfterUpdate()

End Sub

put the following in so that it looks like:

Private Sub CheckBoxName_AfterUpdate()
If Me.[CheckBoxName] = True Then
Me.[OtherControlName] = "OK"
Else
Me.[OtherControlName] = ""
End If
End Sub

Of course you'll need to substitute the correct control names.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

I am working with expression web and have designed a form that feeds an
Access (2002) DB. There are several check boxes on the form. When they
are
checked, it produces the word "True", Not checked = False.

As a point of reference, I know absolutely nothing about DB other than
what
I need to display results on the web.

Instead of the word "True" I'd like it to say "OK" and with no checked box
I'd like it to be emply.

With slight modification, I found an answer here from 2007 except I have
no
idea where to put this code.

If Me![CheckBoxName] = True then

[Me![OtherControlName] = "X"
Else
[Me![OtherControlName] = Null
End If

I assume checkboxname is the column name. I have no idea what the
otherControlName is.

Any help at the 3rd grade level would be appreciated. I did post this on
the EW forum, so far no joy.

 

[Arvin Meyer [MVP]]

The first line should read:

Private Sub Ctl1x_AfterUpdate()

unlees the name of the checkbox is actually: CheckBoxName

Don't forget to compile and save.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

I thought I did this right but no joy,

Private Sub CheckBoxName_AfterUpdate()
If Me.[Ctl1x] = True Then
Me.[Ctl1xread] = "OK"
Else
Me.[Ctl1xread] = ""
End If
End Sub

The code would be in the AfterUpdate event. Open your form in Design View
select the checkbox and open the property sheet if it isn't already open.
Now in the Events tab, find the AfterUpdate event and click the down
arrow,
choosing:

[Event Procedure]

then click the ellipses (...) at the end. You'll see the code window open
with:

Private Sub CheckBoxName_AfterUpdate()

End Sub

put the following in so that it looks like:

Private Sub CheckBoxName_AfterUpdate()
If Me.[CheckBoxName] = True Then
Me.[OtherControlName] = "OK"
Else
Me.[OtherControlName] = ""
End If
End Sub

Of course you'll need to substitute the correct control names.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

I am working with expression web and have designed a form that feeds an
Access (2002) DB. There are several check boxes on the form. When
they
are
checked, it produces the word "True", Not checked = False.

As a point of reference, I know absolutely nothing about DB other than
what
I need to display results on the web.

Instead of the word "True" I'd like it to say "OK" and with no checked
box
I'd like it to be emply.

With slight modification, I found an answer here from 2007 except I
have
no
idea where to put this code.

If Me![CheckBoxName] = True then
[Me![OtherControlName] = "X"
Else
[Me![OtherControlName] = Null
End If

I assume checkboxname is the column name. I have no idea what the
otherControlName is.

Any help at the 3rd grade level would be appreciated. I did post this
on
the EW forum, so far no joy.

 

[Daytona Steve]

Thank you so much, this has solved part of the issue. When I work just in
Acess and input True into 1x, I get OK in the 1xread column.

The other half of the problem is that when inputing the data from the
Expressions web form, True does not produce the same result, its still blank.


The submit action in web doesn't produce the same effect the tab in the
actual Access form.

I'm looking for some sort of firing mechanism in Expression web not sure yet
what it would be but I really appreciate the help for a rookie.

The first line should read:

Private Sub Ctl1x_AfterUpdate()

unlees the name of the checkbox is actually: CheckBoxName

Don't forget to compile and save.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

I thought I did this right but no joy,

Private Sub CheckBoxName_AfterUpdate()
If Me.[Ctl1x] = True Then
Me.[Ctl1xread] = "OK"
Else
Me.[Ctl1xread] = ""
End If
End Sub

The code would be in the AfterUpdate event. Open your form in Design View
select the checkbox and open the property sheet if it isn't already open.
Now in the Events tab, find the AfterUpdate event and click the down
arrow,
choosing:

[Event Procedure]

then click the ellipses (...) at the end. You'll see the code window open
with:

Private Sub CheckBoxName_AfterUpdate()

End Sub

put the following in so that it looks like:

Private Sub CheckBoxName_AfterUpdate()
If Me.[CheckBoxName] = True Then
Me.[OtherControlName] = "OK"
Else
Me.[OtherControlName] = ""
End If
End Sub

Of course you'll need to substitute the correct control names.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


I am working with expression web and have designed a form that feeds an
Access (2002) DB. There are several check boxes on the form. When
they
are
checked, it produces the word "True", Not checked = False.

As a point of reference, I know absolutely nothing about DB other than
what
I need to display results on the web.

Instead of the word "True" I'd like it to say "OK" and with no checked
box
I'd like it to be emply.

With slight modification, I found an answer here from 2007 except I
have
no
idea where to put this code.

If Me![CheckBoxName] = True then
[Me![OtherControlName] = "X"
Else
[Me![OtherControlName] = Null
End If

I assume checkboxname is the column name. I have no idea what the
otherControlName is.

Any help at the 3rd grade level would be appreciated. I did post this
on
the EW forum, so far no joy.

 

[Arvin Meyer [MVP]]

Might be better to ask that in an Expressions newsgroup.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Thank you so much, this has solved part of the issue. When I work just in
Acess and input True into 1x, I get OK in the 1xread column.

The other half of the problem is that when inputing the data from the
Expressions web form, True does not produce the same result, its still
blank.


The submit action in web doesn't produce the same effect the tab in the
actual Access form.

I'm looking for some sort of firing mechanism in Expression web not sure
yet
what it would be but I really appreciate the help for a rookie.

The first line should read:

Private Sub Ctl1x_AfterUpdate()

unlees the name of the checkbox is actually: CheckBoxName

Don't forget to compile and save.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

I thought I did this right but no joy,

Private Sub CheckBoxName_AfterUpdate()
If Me.[Ctl1x] = True Then
Me.[Ctl1xread] = "OK"
Else
Me.[Ctl1xread] = ""
End If
End Sub


:

The code would be in the AfterUpdate event. Open your form in Design
View
select the checkbox and open the property sheet if it isn't already
open.
Now in the Events tab, find the AfterUpdate event and click the down
arrow,
choosing:

[Event Procedure]

then click the ellipses (...) at the end. You'll see the code window
open
with:

Private Sub CheckBoxName_AfterUpdate()

End Sub

put the following in so that it looks like:

Private Sub CheckBoxName_AfterUpdate()
If Me.[CheckBoxName] = True Then
Me.[OtherControlName] = "OK"
Else
Me.[OtherControlName] = ""
End If
End Sub

Of course you'll need to substitute the correct control names.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


message
I am working with expression web and have designed a form that feeds
an
Access (2002) DB. There are several check boxes on the form. When
they
are
checked, it produces the word "True", Not checked = False.

As a point of reference, I know absolutely nothing about DB other
than
what
I need to display results on the web.

Instead of the word "True" I'd like it to say "OK" and with no
checked
box
I'd like it to be emply.

With slight modification, I found an answer here from 2007 except I
have
no
idea where to put this code.

If Me![CheckBoxName] = True then
[Me![OtherControlName] = "X"
Else
[Me![OtherControlName] = Null
End If

I assume checkboxname is the column name. I have no idea what the
otherControlName is.

Any help at the 3rd grade level would be appreciated. I did post
this
on
the EW forum, so far no joy.

 

[Daytona Steve]

I agree, I did, and have a solution that utilizes Listview instead of
Dataview and the following code.

<td style="text-align:center; vertical-align:top" >
<asp:label id="column2Label" runat="server" Text='<%#
Eval("column2").ToString() == "True" ? "OK" : "" %>' />

Thanks again for all your help.

Might be better to ask that in an Expressions newsgroup.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Thank you so much, this has solved part of the issue. When I work just in
Acess and input True into 1x, I get OK in the 1xread column.

The other half of the problem is that when inputing the data from the
Expressions web form, True does not produce the same result, its still
blank.


The submit action in web doesn't produce the same effect the tab in the
actual Access form.

I'm looking for some sort of firing mechanism in Expression web not sure
yet
what it would be but I really appreciate the help for a rookie.

The first line should read:

Private Sub Ctl1x_AfterUpdate()

unlees the name of the checkbox is actually: CheckBoxName

Don't forget to compile and save.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


I thought I did this right but no joy,

Private Sub CheckBoxName_AfterUpdate()
If Me.[Ctl1x] = True Then
Me.[Ctl1xread] = "OK"
Else
Me.[Ctl1xread] = ""
End If
End Sub


:

The code would be in the AfterUpdate event. Open your form in Design
View
select the checkbox and open the property sheet if it isn't already
open.
Now in the Events tab, find the AfterUpdate event and click the down
arrow,
choosing:

[Event Procedure]

then click the ellipses (...) at the end. You'll see the code window
open
with:

Private Sub CheckBoxName_AfterUpdate()

End Sub

put the following in so that it looks like:

Private Sub CheckBoxName_AfterUpdate()
If Me.[CheckBoxName] = True Then
Me.[OtherControlName] = "OK"
Else
Me.[OtherControlName] = ""
End If
End Sub

Of course you'll need to substitute the correct control names.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


message
I am working with expression web and have designed a form that feeds
an
Access (2002) DB. There are several check boxes on the form. When
they
are
checked, it produces the word "True", Not checked = False.

As a point of reference, I know absolutely nothing about DB other
than
what
I need to display results on the web.

Instead of the word "True" I'd like it to say "OK" and with no
checked
box
I'd like it to be emply.

With slight modification, I found an answer here from 2007 except I
have
no
idea where to put this code.

If Me![CheckBoxName] = True then
[Me![OtherControlName] = "X"
Else
[Me![OtherControlName] = Null
End If

I assume checkboxname is the column name. I have no idea what the
otherControlName is.

Any help at the 3rd grade level would be appreciated. I did post
this
on
the EW forum, so far no joy.