By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,255 Members | 2,717 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,255 IT Pros & Developers. It's quick & easy.

how can I call a check box which is on a frame

P: 47
how can I call a check box which is on a frame on access visual basic form?
this code doesnot work:

if check1.value=true then........

that code only works when the check box doesnot on a frame
but when it is on a frame this massage appears:

you entered an expression that has no value
Oct 10 '07 #1
Share this Question
Share on Google+
13 Replies


P: 47
How can I call a check box which is on a frame on access visual basic form?
This code does not work:

If check1.Value = True Then........

That code only works when the check box is not on a frame.
But when it is on a frame this message appears:

You entered an expression that has no value
Oct 10 '07 #2

jrtox
P: 89
how can I call a check box which is on a frame on access visual basic form?
this code doesnot work:

if check1.value=true then........

that code only works when the check box doesnot on a frame
but when it is on a frame this massage appears:

you entered an expression that has no value

Hello,
Download my attachment and let see if its helping you.

Extract it on your desktop.


tell if its not.

Regards
Phils. Ervin
Attached Files
File Type: zip New WinRAR ZIP archive.zip (11.0 KB, 149 views)
Oct 10 '07 #3

missinglinq
Expert 2.5K+
P: 3,532
You don't! If the checkbox is part of an Option Group, which I assume it is, since you speak of its frame, you refer to the value of the frame.

When you set up the Option Group, by default it sets a value for each checkbox, normally

Check1 Value = 1
Check2 Value = 2
Check3 Value = 3

and so forth.
So instead of the statement

if check1.value=true then...

you would use

If Me.NameOfFrame.Value = 1 Then...

Welcome to TheScripts!

Linq ;0)>
Oct 10 '07 #4

jamesd0142
100+
P: 469
If CheckBox1.Checked = True Then
'--- do something
else
'do something
end if
Oct 10 '07 #5

jrtox
P: 89
If CheckBox1.Checked = True Then
'--- do something
else
'do something
end if

Did you daownload the attachment?
Oct 10 '07 #6

P: 47
Hello,
Download my attachment and let see if its helping you.

Extract it on your desktop.


tell if its not.

Regards
Phils. Ervin
Thank you for your interest.
But I use Visual Basic embedded in Access (access form).
There is no problem with VB6.
If you have a solution please help me.
Again thank you for your interest.
Oct 10 '07 #7

jrtox
P: 89
thank you for your interest
but i use visual basic impedded in access (access form)
there is no problem with VB6
if you have a solution please help me
again thank you for your interest

hello, be specific with your problem
i thought, the problem its in VB6

regards
Phil Ervin
Oct 10 '07 #8

Expert 5K+
P: 8,434
I'm going to move this thread to the Access forum, where you should find a better response.
Oct 10 '07 #9

missinglinq
Expert 2.5K+
P: 3,532
I have merged these two threads for the obvious reason!

ahmed222too, in the future, please refrain from posting the same question/problem on more than one TSDN forum!

From FAQs


Do Not Double Post Your Questions

Double posting is where you start a thread on a topic and then for some reason start another thread on exactly the same topic in the same forum. Please do not do this because

1. It makes it very hard for people to answer you especially if there are answers happening in all the threads you have started because they have to read 2 or more threads in order to see what has already been said.
2. It swamps the forum with your problem resulting in less attention for the other threads.

If you feel for some reason that you post has been overlooked (for instance it hasn't had any replies) please do not repost the question. Post a message to the thread you started, this will bump it back to the top of the thread list for the forum.

Thank you for your attention in this matter.

Linq ;0)>
Oct 11 '07 #10

P: 47
You don't! If the checkbox is part of an Option Group, which I assume it is, since you speak of its frame, you refer to the value of the frame.

When you set up the Option Group, by default it sets a value for each checkbox, normally

Check1 Value = 1
Check2 Value = 2
Check3 Value = 3

and so forth.
So instead of the statement

if check1.value=true then...

you would use

If Me.NameOfFrame.Value = 1 Then...

Welcome to TheScripts!

Linq ;0)>


Thank you very much
the problem is solved thanks for your help

again thank you very much
ahmed
Oct 11 '07 #11

P: 47
Did you daownload the attachment?
yes, i downloaded it and understood your intention
thank you very much
ahmed
Oct 11 '07 #12

P: 47
I have merged these two threads for the obvious reason!

ahmed222too, in the future, please refrain from posting the same question/problem on more than one TSDN forum!

From FAQs


Do Not Double Post Your Questions

Double posting is where you start a thread on a topic and then for some reason start another thread on exactly the same topic in the same forum. Please do not do this because

1. It makes it very hard for people to answer you especially if there are answers happening in all the threads you have started because they have to read 2 or more threads in order to see what has already been said.
2. It swamps the forum with your problem resulting in less attention for the other threads.

If you feel for some reason that you post has been overlooked (for instance it hasn't had any replies) please do not repost the question. Post a message to the thread you started, this will bump it back to the top of the thread list for the forum.

Thank you for your attention in this matter.

Linq ;0)>

iím very sorry
but really i was confused if the question is related to access forum or visual basic one so i send it to both of them
again iam very sorry
thank you for your patience with me
ahmed
Oct 11 '07 #13

missinglinq
Expert 2.5K+
P: 3,532
I'm glad we could resolve your problem, Ahmed, and that you now understand about not double posting! The question about Visual Basic/Visual Basic for Applications is confusing! Just to clarify things, the code used in Access databases is VBA (Visual Basic for Appplications) and while it is derived from standard Visual Basic (as in VB6) it does vary in sometimes significant ways. Consequently, questions about Access/VBA should always be posted in the Access Forum.

Linq ;0)>
Oct 11 '07 #14

Post your reply

Sign in to post your reply or Sign up for a free account.