Radio buttond and combo boxes

18 May 2009 7:44 AM

Kevin

Hi Guys; I am a newbie to Visual basic 2008 but ok with access.

I have a form that I have a group box of radio buttons in. They are
"workstarted" "Work contractors" "Awaitingapproval" and "Workcompleted"
What I want to do is when one of the buttons is selected it writes something
to the jobnumbers table and then I can filter the selection for other
requirements, If another button is selected it deletes the original selection
and writes the new selection to the table.

Itâ€™s easy on access but I am struggling with VB.

The second item is a combobox that calls fields from a query and they are
"firstName" "lastname" "Address". And when the drop down occurs in the combo
box it only show one of the field, how do I make it show the 3 fields easily.

Sorry if the questions are a bit basic

many Thanks
Kevin

18 May 2009 1:37 PM

Mike

Kevin, unless I am misunderstanding the questions, you have similar
concepts in VB.NET in regards to click events in access and .NET.

So for each radio button, you assign a Click Event in the property
editor and then add your logic in the auto generated function it
creates - the same like in Access if I remember.

For the combobox, again if the question is understood, you can set a
display size that is visible in the pull down.

Hope this helps

--

Kevin wrote:

Show quoteHide quote

> Hi Guys; I am a newbie to Visual basic 2008 but ok with access.
>
> I have a form that I have a group box of radio buttons in. They are
> "workstarted" "Work contractors" "Awaitingapproval" and "Workcompleted"
> What I want to do is when one of the buttons is selected it writes something
> to the jobnumbers table and then I can filter the selection for other
> requirements, If another button is selected it deletes the original selection
> and writes the new selection to the table.
>
> Itâ€™s easy on access but I am struggling with VB.
>
> The second item is a combobox that calls fields from a query and they are
> "firstName" "lastname" "Address". And when the drop down occurs in the combo
> box it only show one of the field, how do I make it show the 3 fields easily.
>
> Sorry if the questions are a bit basic
>
> many Thanks
> Kevin
>

18 May 2009 2:19 PM

Cor Ligthert[MVP]

Kevin,

From your first I don't know where you have a problem with.
-    making the event?
-    using the event?
-    write to the job number tables?
-    filter the selection?
-    delete the original selection?

The second is more easy, simply go to the properties from the designer,
choose for items and set in that collection the items you want using a
return to separate them.

Then you click on the combobox and the item is selected.
In this case you can use the combobox1.Text

With the radiobutton it is a little bit more difficult (not much)

Cor

Show quoteHide quote

"Kevin" <Ke***@discussions.microsoft.com> wrote in message
news:70842BE7-5E91-481C-A81F-0968468921D2@microsoft.com...
> Hi Guys; I am a newbie to Visual basic 2008 but ok with access.
>
> I have a form that I have a group box of radio buttons in. They are
> "workstarted" "Work contractors" "Awaitingapproval" and "Workcompleted"
> What I want to do is when one of the buttons is selected it writes
> something
> to the jobnumbers table and then I can filter the selection for other
> requirements, If another button is selected it deletes the original
> selection
> and writes the new selection to the table.
>
> Itâ€™s easy on access but I am struggling with VB.
>
> The second item is a combobox that calls fields from a query and they are
> "firstName" "lastname" "Address". And when the drop down occurs in the
> combo
> box it only show one of the field, how do I make it show the 3 fields
> easily.
>
> Sorry if the questions are a bit basic
>
> many Thanks
> Kevin
>

18 May 2009 2:33 PM

Cor Ligthert[MVP]

I am thinking to much for other things.

About your first problem the radiobutton I don't know where you have a
problem with.
-    making the event?
-    using the event?
-    write to the job number tables?
-    filter the selection?
-    delete the original selection?

The second problem combobox is easier, simply go to the properties from
that in the designer,
choose for items and set in that collection the items you want using a
return to separate them.

Then you click on the combobox and the "Selected Index change" event is made
in the code part
In this case you can use the combobox1.Text in that event method as what is
selected

With the radiobutton it is a little bit more difficult (not much) therefore
try to explain the problem a little bit more to the point you have a problem
with.

Cor
Show quoteHide quote

>