Access 2000 creation question

[Guest]

I am trying to build a special data base to track attendence in study groups.
?Sometimes people attend different groups than what they've commmitted to,
but still deserve credit for all groups attended. I have created a form
which identifies who should be in that group with check boxes and a list of
all the other possible attendees with checkboxes. I need to be able to click
a button after checking off the attendees which will record the names of all
those who attended, where and when the group occurred onto a new spreadsheet
from which I can later create a variety of reports. I have no idea how to
make this happen. Can anyone help me?

 

[Guest]

I am going to assume your database is normalised.

What I do in this situation is create a query in which you will need a
number of filters to determine the group and time information and a filter to
select those who actually attended.

To do the filtering you may want a form with unbound textboxes or combos to
fill in the info and then click the button. In the query criteria insert the
following:

[forms]![formname]![fieldname]

This line refers to the text boxes/combos in the form.

In the on-click event of the button insert the following code

DoCmd.TransferSpreadsheet acExport, _
acSpreadsheetTypeExcel9, "QUERYNAME", _
"EXPORT LOCATION", , "SHEETNAME"

Replace the capitalised words with the appropriate information. You can
repeat this code and transfer different information to different sheets
within the same workbook.

I hope this gives you a decent start.

 

[Guest]

Thank you for your attempt, unfortunately, I don't really know anything about
this program or visual basic so what you wrote still doesn't make sense to
me. I've been trying to decifer it for a while now. My intent is to have it
write to a table that is in the same database. The only thing that I think
made sense was that the command you wrote has it writing into excell. Did I
at least get that right? I don't even know what you mean by "your database
is normalized." Please, if you will, break it all down for me so that an
idiot could understand it. I know I am in way over my head!!!

I am going to assume your database is normalised.

What I do in this situation is create a query in which you will need a
number of filters to determine the group and time information and a filter to
select those who actually attended.

To do the filtering you may want a form with unbound textboxes or combos to
fill in the info and then click the button. In the query criteria insert the
following:

[forms]![formname]![fieldname]

This line refers to the text boxes/combos in the form.

In the on-click event of the button insert the following code

DoCmd.TransferSpreadsheet acExport, _
acSpreadsheetTypeExcel9, "QUERYNAME", _
"EXPORT LOCATION", , "SHEETNAME"

Replace the capitalised words with the appropriate information. You can
repeat this code and transfer different information to different sheets
within the same workbook.

I hope this gives you a decent start.

I am trying to build a special data base to track attendence in study groups.
?Sometimes people attend different groups than what they've commmitted to,
but still deserve credit for all groups attended. I have created a form
which identifies who should be in that group with check boxes and a list of
all the other possible attendees with checkboxes. I need to be able to click
a button after checking off the attendees which will record the names of all
those who attended, where and when the group occurred onto a new spreadsheet
from which I can later create a variety of reports. I have no idea how to
make this happen. Can anyone help me?