check boxes

  • Thread starter Thread starter ansongdk
  • Start date Start date
A

ansongdk

Hi All

I'm a novice users of access and i am trying to design and equipment booking
system for a college. The problem i have now is that I have 6 check boxes
on a form, i want to know how to write a criteria, that will enable me to
print out only the selected boxes onto a report. At the moment each of the
boxes are linked to a field using the 'control' source property
 
Are there some tables and fields that you would like to share? We don't know
if your tables are normalized or if you have a basic spreadsheet design.
 
at the moment i only have one table, and the fields are

Tutor Name (name of the tutor booking the equipment for any particular day)
Room Number (The room the Tutor will use whilst using the equipment for any
particular day)
Equipment ( The name of the equipment the tutor has requested)
Date (The day the tutor has booked the equipment. on my form i have created
up to 12 boxes where many different dates can be entered for each record)

**each date on a record can only have 1 start time and finish time

Start time (the start time for the class. each time can have many different
dates)
End time (the end time of the class. each end time can also have many dates)

If this is the wrong way to go about it,,advice on normalisation would be
grately appreciated,,,,,,Thanks,,





Duane said:
Are there some tables and fields that you would like to share? We don't know
if your tables are normalized or if you have a basic spreadsheet design.
Hi All
Click to expand...
[quoted text clipped - 6 lines]
the
boxes are linked to a field using the 'control' source property
Click to expand...
Click to expand...
 
I don't know if you are referring to unbound controls on a form or actual
fields in a table when you state "12 boxes where many different dates can be
entered for each record"

I have no idea how these fields relate to 6 check boxes from your first
post.

--
Duane Hookom
MS Access MVP

ansongdk via AccessMonster.com said:
at the moment i only have one table, and the fields are

Tutor Name (name of the tutor booking the equipment for any particular
day)
Room Number (The room the Tutor will use whilst using the equipment for
any
particular day)
Equipment ( The name of the equipment the tutor has requested)
Date (The day the tutor has booked the equipment. on my form i have
created
up to 12 boxes where many different dates can be entered for each record)

**each date on a record can only have 1 start time and finish time

Start time (the start time for the class. each time can have many
different
dates)
End time (the end time of the class. each end time can also have many
dates)

If this is the wrong way to go about it,,advice on normalisation would be
grately appreciated,,,,,,Thanks,,





Duane said:
Are there some tables and fields that you would like to share? We don't
know
if your tables are normalized or if you have a basic spreadsheet design.
Hi All
Click to expand...
[quoted text clipped - 6 lines]
the
boxes are linked to a field using the 'control' source property
Click to expand...
Click to expand...
Click to expand...
 
Back
Top