473,320 Members | 1,872 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Creating Option Buttons or check boxes with Access 2000 using VB

Ben
My current project requires me to create part of a form that is
created on the fly. The project consists a list of entries to an
event. The name and address and such is easy. The design is detup so
that the creater of the even can make their own event in the database.
When they do so a 2 tables are created. One for the entries such as
names and the other is for the parameters of each event.

The creator then goes in and makes each event giving it a name and
setting the parameters. This is all easy for me and works fine. When a
user goes into to start adding entries they put in the personal info
and using a series of check marks check what the events that person is
in.

How do I create a series of option boxes, or check boxes when I don't
the know names of the events or even the number of the events?
(Actually I may want to be using check boxes instead). Also an event
maybe added after entries are being started been taken.

I do know how to create select statements, change properties of form
elements and such. I also know the table name where the name of the
events occur. The user selects it so thats not a problem.

What has me stumped is creating form elements using VB in access 2000.

At this point I need a direction to look or even a simple example.

Thank you.

PS The actual design of the form and layout works wonderfully. We used
it this summer at a real event. The problem is that the tables and
queries were only for that event so we are building something that
anyone can use. In reality we only used the backend features of access
since myself and a friend were running it.
Nov 12 '05 #1
2 5248
I've never had occasion to be _required_ to create Forms/Controls on the
fly. It's usually a poor solution to some perceived problem that should be
addressed a different way. But then, I've only been in this business since
1957 and only used Access since January of 1993, so I might have missed a
few requirements here and there.

And, as for "when I don't the know names of the events or even the number of
the events?", I'm not sure what you are talking about. Are you talking about
creating event code to go with the controls you want to create?

In any case, if you'd detail what you have and what you really need to
accomplish, perhaps someone could suggest an approach that will do what is
needed.

Larry Linson
Microsoft Access MVP
"Ben" <be****@hotmail.com> wrote in message
news:bd**************************@posting.google.c om...
My current project requires me to create part of a form that is
created on the fly. The project consists a list of entries to an
event. The name and address and such is easy. The design is detup so
that the creater of the even can make their own event in the database.
When they do so a 2 tables are created. One for the entries such as
names and the other is for the parameters of each event.

The creator then goes in and makes each event giving it a name and
setting the parameters. This is all easy for me and works fine. When a
user goes into to start adding entries they put in the personal info
and using a series of check marks check what the events that person is
in.

How do I create a series of option boxes, or check boxes when I don't
the know names of the events or even the number of the events?
(Actually I may want to be using check boxes instead). Also an event
maybe added after entries are being started been taken.

I do know how to create select statements, change properties of form
elements and such. I also know the table name where the name of the
events occur. The user selects it so thats not a problem.

What has me stumped is creating form elements using VB in access 2000.

At this point I need a direction to look or even a simple example.

Thank you.

PS The actual design of the form and layout works wonderfully. We used
it this summer at a real event. The problem is that the tables and
queries were only for that event so we are building something that
anyone can use. In reality we only used the backend features of access
since myself and a friend were running it.

Nov 12 '05 #2
Ben
I probably should make this clearer than I did in my last post.

THe user opens the admin form. The first thing done is to create a
show and give it a name. "South Mountain"

This creates 2 tables. 1st table is the names and addresses of the
particpants. 2nd is the list of the events and the parameters of it,
how many divisions, time split and placings to be awarded.

Next the user creates the first event. This creates a yes/no field in
the personal table to be used to check wiether or not the person is in
that event. The number of events could be anywhere from 3 to 35 and
given any name.

When all the events are created the user goes into the entry form and
starts to fill in the info such as name and phone number then checks
off what events that person is going in. Of course I have no idea when
I create the form how many or what the name of the events are so I
would like to create the check boxes on the fly when the person enters
the form.

Also some times events can be removed or added to a show so the next
time the user enters data the changes must appear. We really like the
check boxes because it is very fast, and simple. As I said before when
we designed it before we went through many different ways of
displaying and using this part of the interface and concluded it to be
the best way.

Please note there is a very real possibility of dividing up the
peronal table into a more organized fashion. ie 1 table for the
personal info and and other table to keep track of the events they are
in.

I would also like to point out that only one person at a time would be
using it and that the number of records are very low.

The one solution I posted before is very ugly. For some reason though
I thought Access 2000 had a something to create a form object. Hope
this clears things up.

Thanks again.
Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Edward | last post by:
I have a data entry form that allows the user to navigate around entirely using the keyboard. However, it contains various option button controls which are in the tab order. Whenever they are...
1
by: Ben | last post by:
Due to problems reading the first thread I started I think I should respond with a new post. I have been only able to read up to the 2nd clarification that I posted. Thanks to all who responded....
2
by: Iain Miller | last post by:
Now this shouldn't be hard but I've been struggling on the best way as to how to do this one for a day or 3 so I thought I'd ask the assembled company..... I'm writing an application that tracks...
6
by: Robert | last post by:
Hello. I have been trying out the Lebans ToolTip Classes at http://www.lebans.com/tooltip.htm, to display "balloon" style help tips in a form. The classes I am using are located at...
0
by: Robert | last post by:
Stephen, I think I figured out the problem. I was able to get Check Boxes and Option Buttons to work on my form by TURNING OFF RECORD SELECTORS on the form. Not sure why this would make a...
1
by: James | last post by:
I am creating a system whereby equipment is inspected. Data is inputted into an inspection form. However, any equipment that is not satisfactory needs to have spare parts ordered for that piece of...
11
by: MLH | last post by:
Why is that? If I choose the tiny check boxes which are hard to hit with a mouse, it works fine. But option buttions, shich can be sized big enough for people with limited sight and dexterity...
2
by: NishSF | last post by:
Would anyone have any suggestions/javascript code so that if one clicks the Radio Button "Yes" below he has the option of selecting any of the six CheckBox below. If the user clicks on Radio Button...
2
beacon
by: beacon | last post by:
Hi everybody, I have a form that has a combo box that asks the user to select the program they work on. Once the user selects the program, a SQL statement populates the row source for 4 staff...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.