If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access 2000 creation question
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? |
#2
|
|||
|
|||
Access 2000 creation question
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. "TRE" wrote: 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? |
#3
|
|||
|
|||
Access 2000 creation question
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!!! "scubadiver" wrote: 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. "TRE" wrote: 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? |
Thread Tools | |
Display Modes | |
|
|