I'm new here and need some help about forms

[dbbjk]

Hello friends,i'm new in this forum and i've been studying about databases( i wanted to start with access 2007) for 4 months..I hope we will help eachother here

As i said in the topic i have some questions about forms;

• In the form design mode there is a check box.I use it for;for example i have country name(Turkey,US,England) and a check box in my form and i want my check box on if the name of the country is Turkey.I think check box can be used for this.My first question starts here;i want check box on if the 3rd letter of the country is "r"..How can i do that?

• My second question is;i think the option group and check box are similar.If they are,what is the difference between them?If not,what is option group used for?

• My third question;what is an unbound object frame?What does it mean?What is it used for?

You can ask any question about Access to me,i always want to answer them..By the way i wanna improve english but i can make some mistakes(some wrong words,grammar mistakes..) so i'm sorry for my english

From now on thanks everybody,I appreciate for the all answers..

 

[Scooterbug]

In the form design mode there is a check box.I use it for;for example i have country name(Turkey,US,England) and a check box in my form and i want my check box on if the name of the country is Turkey.I think check box can be used for this.My first question starts here;i want check box on if the 3rd letter of the country is "r"..How can i do that?

Generally, check boxes are used to denote a yes/no field. You can write code to set the value of the check box based on whatever criteria. I would shy away from checking for the 3rd letter...what happens if you have a country besides Turkey that has a "r" as the third letter?

My second question is;i think the option group and check box are similar.If they are,what is the difference between them?If not,what is option group used for?

With an options group, the Option Group value can only be one thing out of several choices. If you have 4 options, only one can be selected.

My third question;what is an unbound object frame?What does it mean?What is it used for?

Any control that is unbound, including an Object frame just means that the control is not tied to a field in a table.

 

[wazz]

In the form design mode there is a check box.I use it for;for example i have country name(Turkey,US,England) and a check box in my form and i want my check box on if the name of the country is Turkey...

you can stop right there. no need to add controls to tell you something that you can already find out. if "the country is x", then you can find out by checking the text box or combo box or whereever the info is.

My first question starts here;i want check box on if the 3rd letter of the country is "r"..How can i do that?

you can/should do that with a query.

My second question is;i think the option group and check box are similar.If they are,what is the difference between them?If not,what is option group used for?

use the check box to select one item. if you have several check boxes you can select any number of them. an option group can only have one item selected in the group.

My third question;what is an unbound object frame?What does it mean? What is it used for?

i'll leave that one for later or someone else.

 

[wazz]

sorry scooter, didn't see you had replied.

 

[Scooterbug]

sorry scooter, didn't see you had replied.

no biggie....no such thing as too much information (Most of the time )

 

[dbbjk]

Thanks for the interest;

i wanted to say as the third letter that;i want check box on if the 3rd letter of the country is "r"..Yes i know that doesn't mean anything but i want do this..Can we do that?

Ok i got it but can you give an example for the difference between options group and check box?

When i select unbound object frame,the name of the picture exists in the form.Why?

 

[Scooterbug]

i wanted to say as the third letter that;i want check box on if the 3rd letter of the country is "r"..Yes i know that doesn't mean anything but i want do this..Can we do that?

Honestly dont know why, but...

If right(left(CountryName,3),1) = "r" then
   'code to do what you want
end if

Ok i got it but can you give an example for the difference between options group and check box?

With an options group, you can ONLY choose one of the options. You cannot have multiple options selected. Generally used when you want the user to select one option from many.

When i select unbound object frame,the name of the picture exists in the form.Why?

What exactly are you trying to put into the object frame?

 

[dbbjk]

This is a visual basic code isn't it?If it is ok then,i want to learn visual basic code for access later.Thanks

I got the difference too..Thanks

I'm trying to put a photo and mp3..Both of them have names in the form..Neither the picture is shown nor the mp3 is being played..What does it mean,i dont know

 

[Scooterbug]

Yes, that was VBA.

As for the unbound object...never really needed to use them, so anything more than what I explained...I dont know. Sorry.

 

[dbbjk]

Thank you very much and for your interest

But i have just one more question

What is the difference between check box and option button?

 

[missinglinq]

"i wanted to say as the third letter that;i want check box on if the 3rd letter of the country is "r"..Yes i know that doesn't mean anything but i want do this..."

Doing things that don't make practical sense, for the sake of doing it, sounds an awful lot like a class exercise.

 

[dbbjk]

@missinglinq:I wanted to learn something,asked in a different way and had the answer from scooterbug..That's all i did and learnt what i wantedI am sorry if i did something wrong