Needing Design Help

Hi,

I am new to your forum and am excited to have already found some answers to some questions in looking and searching.

I am in need of some help. I have volunteered to take on a project for our Girls Camp from church and what has started out as simple database/reports has progressively become more complicated. It has been over 10 years since I had a little bit of Access training and was actively using it! Right now, I have 4 young 'uns and manage a couple of personal data bases to keep track of our homeschool and procedures/weather stats, etc. in our small orchard. Basically, I enjoy designing and doing this, but I am really out of practice and with all of the kids running around and Mommy duties are high priority, I am having a hard time figuring out the best way to organize these tables and queries to get the desired end results needed for girls camp.

I'm working with Access 97. My first table includes registration information, the group the camper is assigned to(Group ID), and the list of her handicrafts classes she has been assigned to. The table in question has a relationship with the Registration Table at the Group ID Fields . There are about 9 activities that are occuring at 1 time. These activities repeat themselves on the hour 3 times daily, tuesday through friday. I have created a field for the activity with the day and time. Yes - there are A LOT of Fields! I am entering the number value 1 in the activities which the specified Group ID will be participating in across each row. Is this just as clear as mud?

Now, I create a query, because I want to see if this info is going to turn up just right. I want to see the camper's names who have been assigned to group 1A (criteria = "1A"). The query pulls up all of my records for group 1 A, and all of the activity fields are present, including the ones without a value (1) in the field. I don't want to see the activities with a null value here, so I try putting "1" into all of the fields and all of the records disappear in data view. So I think at this point, I really need some chocolate and some help! (I've already tried a couple of other possibilities but an exclamation point came up and said my query was too complicated).

Here is what I need in the end. I need to print an individual report for each girl that will tell her where in the camp she is supposed to be and what she is doing for the whole week of camp. The latest request is they would also really like to print miniature schedules as well, that will fit into a name badge. I know this is doable, I'm just really having a hard time organizing the data so I can get the information where I need it.

Can someone please help?

Sincerely,

Tanya (who is going to now go rummage for some chocolate)

OK first question is what's your timeline for having this done?<grin>

I'll send you a private message for more info.

Girls Camp is June 1st. I'm not sure I am private message-able - I don't usually select that option when I'm setting up a loggin with a forum. If it becomes too tedious to post thru the forum we can figure an exchange of email info at that point.

Chocolate was helpful. I had a feeling all along that I wasn't setting up the Activities database quite right. I think if I were to set up my fields to read:

Group ID
Tuesday Activity 1
Tuesday Activity 2
Tuesday Activity 3
Wednesday Activity 1
etc., for the remaining days

I would then be able to enter data into fields, something like this:
1A
Canoeing 1:00 pm - at the Lake
Archery 2:00 pm - at the Meadows
etc., for the remaining activity times and places for group 1A

This way I will have no empty fields and I don't have to try to figure out how to pull the data I want from the Master List of activities that I designed in the first place. (I originally had designed the fields to read Group ID, Tuesday Canoeing 1:00pm - at the lake, Tuesday Archery 2m - at the meadows.... for every last activity....!!!!...... - then I was entering a number value for the activity slot that Group 1A would be participating in).

I know the origianl way of thinking isn't too brilliant, but does this new way of thinking appear to be sound reasoning?

Now, when I relate the two tables by group ID, I should be able to format a report that will print the camper's personal information, + her age group's activities, right?

Tanya

I have put together this new activities table and am creating a form. Because I am working from the same activities list for all of these fields, I'm trying to create a list box for quick and accurate data entry. I'm wondering why I can not copy the list I have made in the List Wizard and Paste in the new List box (same list - just different data field). I have also tried to copy and paste the same List Box and can not find in the properties list where to change the data field that I want the click to send it to. Any ideas?

Thanks!

Tanya

OK there are a couple of options.

1. create an activities table that lists the set activities and use the table for the combo box.

2. use a value list (what you did) for the combo box.

the properties that your are looking for are:

ControlSource which is the field name that you want to populate. (i.e. Tuesday Activity 1; Tuesday Activity 2; etc)

RowSourceType which determines if you populating the list or combo box from a table/query or a Value List, or a Field List.

RowSource which works with the setting of the RowSourceType. For example:

You have created a ValueList combo/list box so the properties would be:
RowSourceType = ValueList
RowSource = "Canoeing - at the lake"; "Archery - at the medows"; "Swimming - at the pool"

If you want to use a table to keep track of the activities the properties would be:
RowSourceType = Table/Query
RowSource = tblActivities

Got it?