Access/VB muliple checkbox issue

G

Guest

Dear All,

I have two tables participating in a many to many relationship. In resolving
this, I have brought in a composite table - Visit_Enquiry.
Analogically put, a Visit by a Student can be for many Enquiries.

Table student - pkRegNo
Table Visit - pkVisitid, Visitdate, fkRegNo
Table Enquiries - fkEnquiryID, Description, Un/Click(checkbox)
1 Coursework,
2 Daypass,
3 ResourceCard,
4 Letter/Transcripts,
5 BannerWeb,
6 Finance etc (about 25 Enquiries in all)
Table Visit_Enquiries - pkVisit_EnqID, fkVisitid, fkEnquiryID.

I now seem to have some design issues here to do with user-friendliness.
Implementing checkboxes would be neater but difficult for me to code as I am
rusty using VB.
If I used a list box which might not be very user-friendly, would I still
need to do a lot of VB coding as well.


On the other hand, I would appreciate if you could write out some VB codes
on at least one or two checkboxes and makiing sure that the values of those
checkboxes selected are also entered into the Visit_Enquiries table on a
student's visit, and cleared for the next entry
I have search on the web for this and books, could not get one.

Many thanks in advance
dotcommillionaire
 
G

Guest

It would be helpful if you would describe what data the check boxes relate to
and what they mean. Also, how is your form layed out.
 
G

Guest

Klatuu said:
It would be helpful if you would describe what data the check boxes relate to
and what they mean. Also, how is your form layed out.
Click to expand...



My check boxes are all in the Enquiries table, for example coursework,
daypass, resourcecard etc has all got checkboxes next to them. These has been
implemented at table level creation.

On my form, I should have 4 forms, the student masters form takes in a
student RegNo. This now links to a child form Visit which enters into the
databse whenn this student came for a visit. The next form Enquiries contains
all the values with checkboxes next them. The last form(Vsiit_Enquiries)
which is a child form to both Visit and Enquiries should record how many
enquiries from the Enquiries table this Visit by this Student came in for.

Remember, wherever checkboxes are ticked on the Enquiries from, the
Visit_Enquiries child form should reflect before clicking on save.

I hope this is a lot clearer.

I can send you the database if it would be useful, so you can have a look at
the ERD

Many thanks
dotcommillionaire
 
G

Guest

Coding for a List box will be more difficult than for a check box.
My apologies, but I still don't quite understand what you want to do when
the check box in clicked.
 
G

Guest

Hi Klatuu,

There are going to be about 25 checkboxes for each enquiry in the "ENQUIRY"
table.
As many checkboxes can be click as possible. I want those enquiries clicked
to be stored in the table VISIT_ENQUIRY table. Then those checkboxes become
free again for next use after clicking on the save button.

Tables VISIT AND ENQUIRY are parent tables to VISIT_ENQUIRY, The ENQUIRY
table only holds a list of values each to which a checkbox is attached (some
examples of enquiries are resoure card, coursework, daypass, fees, loans etc).

Many thanks
 
Top