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 |
#11
|
|||
|
|||
Mutliply reports all at once
i got the unbound textboxes I know how to do that from another set up i have.
but what does the command button need to do just run report. btw when i have the frmprint open can i click one of the boxs and i get a beep error "Klatuu" wrote: Not to worry. More likely I will get it wrong and cause you extra work. On the main form, you will need text boxes for the dates and a command button to run the report. -- Dave Hargis, Microsoft Access MVP "The Uke" wrote: Thanks i understand this stuff but not great, Just so we are on the same page Want i need is to open a form have in that form two unbound feilds were the date will go so the report has something to limit its self then there is a list of the 6 users checking off each user will run the report and print it accroding to the date field and the user that is it just want to make sure so if we get 10 step is it and its totally wrong you dont get frustrated with me.. also i remade my frmcheckbox i added a check and make the controlsource the print field Ok so i made another form (frmprint) with frmcheckbox as the subform "Klatuu" wrote: Great. I forgot to say that the control in the form for the new field PrintReport should be a check box, sorry. But you need that. Once you have done that, create a main form and make this form a sub form it it. Post back when you get that done. (BTW, you are pretty fast) -- Dave Hargis, Microsoft Access MVP "The Uke" wrote: ok i made the form it looks just like the query did "Klatuu" wrote: Okay, now create a new form with the query as the record source of the form. You will want the default view to be datasheet. This is going to be the subform to your main form, but for now, we will work with it on it's own. -- Dave Hargis, Microsoft Access MVP "The Uke" wrote: got it "Klatuu" wrote: Okay, let's start there. Create a new query in design view select your userid table select the columns you want to show Now in an empty column in the design grid, enter the following in the Field: row PrintReport: 0 Now when you run the query, you will see a column with the name PrintReport and for each row the value will be 0. When you have that working, post back. -- Dave Hargis, Microsoft Access MVP "The Uke" wrote: Klatuu, I would like you for sending me a response, but when it comes to programing im not fully blessed in totally understanding it need, I normally break it down into its smallest parts and work from there. I guess i would like to start with is it possiable to make a list of self generating checkboxs based upon a query of of userID table. "Klatuu" wrote: A cleaner way to do this would be to use a datasheet subform for the USERID table, but instead of using the table, use a query based on the table and add a calculated column to the query for the user to select - Something like: PrintReport: False in the Field row of the query builder or 0 As Print Report If you write your own SQL. Then you would bind this field to the check box control (chkPrintReport in the example below) on the form. Now you can loop through the subform's recordset to see if you need to print a report for that user. I think, based on your post, you want to print a separate report for each user checked, so I wrote the After Update event that way: Private Sub cmdReports_Click() Dim frm As Form Set frm = Me.MySubform.Form With frm.RecordsetClone Do While Not .EOF If frm.chkPrintReport Then Docmd.OpenReport "rptUsers", , , "[USER] = " & frm.txtUser End If Loop End With Set frm = Nothing End Sub -- Dave Hargis, Microsoft Access MVP "The Uke" wrote: On i want to make this kinda automated here is what i want to do I want to be able to open a form and have the from look up and use check boxs for all the users from everyone listed in the USERID table. Then as you check off each check box and enter a date range and hit a button a report will print a copy for each USERID that has been checked for that date range Is this possiable, and does anyone else have more questions The date range i understand how to do Its more how to feed the report of each checked off name and make it print (I think its need a loop) and How to make an expandable check box list |
#12
|
|||
|
|||
Mutliply reports all at once
Is frmprint the name of the main form with the text boxes and command button?
I don't know what the beep is about, but for the command button, we will need to put code behind it to run the reports when we get to that point. Now do you have the subform in the main form (frmprint?) done? -- Dave Hargis, Microsoft Access MVP "The Uke" wrote: i got the unbound textboxes I know how to do that from another set up i have. but what does the command button need to do just run report. btw when i have the frmprint open can i click one of the boxs and i get a beep error "Klatuu" wrote: Not to worry. More likely I will get it wrong and cause you extra work. On the main form, you will need text boxes for the dates and a command button to run the report. -- Dave Hargis, Microsoft Access MVP "The Uke" wrote: Thanks i understand this stuff but not great, Just so we are on the same page Want i need is to open a form have in that form two unbound feilds were the date will go so the report has something to limit its self then there is a list of the 6 users checking off each user will run the report and print it accroding to the date field and the user that is it just want to make sure so if we get 10 step is it and its totally wrong you dont get frustrated with me.. also i remade my frmcheckbox i added a check and make the controlsource the print field Ok so i made another form (frmprint) with frmcheckbox as the subform "Klatuu" wrote: Great. I forgot to say that the control in the form for the new field PrintReport should be a check box, sorry. But you need that. Once you have done that, create a main form and make this form a sub form it it. Post back when you get that done. (BTW, you are pretty fast) -- Dave Hargis, Microsoft Access MVP "The Uke" wrote: ok i made the form it looks just like the query did "Klatuu" wrote: Okay, now create a new form with the query as the record source of the form. You will want the default view to be datasheet. This is going to be the subform to your main form, but for now, we will work with it on it's own. -- Dave Hargis, Microsoft Access MVP "The Uke" wrote: got it "Klatuu" wrote: Okay, let's start there. Create a new query in design view select your userid table select the columns you want to show Now in an empty column in the design grid, enter the following in the Field: row PrintReport: 0 Now when you run the query, you will see a column with the name PrintReport and for each row the value will be 0. When you have that working, post back. -- Dave Hargis, Microsoft Access MVP "The Uke" wrote: Klatuu, I would like you for sending me a response, but when it comes to programing im not fully blessed in totally understanding it need, I normally break it down into its smallest parts and work from there. I guess i would like to start with is it possiable to make a list of self generating checkboxs based upon a query of of userID table. "Klatuu" wrote: A cleaner way to do this would be to use a datasheet subform for the USERID table, but instead of using the table, use a query based on the table and add a calculated column to the query for the user to select - Something like: PrintReport: False in the Field row of the query builder or 0 As Print Report If you write your own SQL. Then you would bind this field to the check box control (chkPrintReport in the example below) on the form. Now you can loop through the subform's recordset to see if you need to print a report for that user. I think, based on your post, you want to print a separate report for each user checked, so I wrote the After Update event that way: Private Sub cmdReports_Click() Dim frm As Form Set frm = Me.MySubform.Form With frm.RecordsetClone Do While Not .EOF If frm.chkPrintReport Then Docmd.OpenReport "rptUsers", , , "[USER] = " & frm.txtUser End If Loop End With Set frm = Nothing End Sub -- Dave Hargis, Microsoft Access MVP "The Uke" wrote: On i want to make this kinda automated here is what i want to do I want to be able to open a form and have the from look up and use check boxs for all the users from everyone listed in the USERID table. Then as you check off each check box and enter a date range and hit a button a report will print a copy for each USERID that has been checked for that date range Is this possiable, and does anyone else have more questions The date range i understand how to do Its more how to feed the report of each checked off name and make it print (I think its need a loop) and How to make an expandable check box list |
#13
|
|||
|
|||
Mutliply reports all at once
frmprint is the name of the from that has the dateboxs and the button with
the subform of checkboxs (frmcheckbox) when it beeps im clicking on the check boxs but there is no check mark showing up that why i bring it up b/c i forsee this being a problem that no check mark is showing up "Klatuu" wrote: Is frmprint the name of the main form with the text boxes and command button? I don't know what the beep is about, but for the command button, we will need to put code behind it to run the reports when we get to that point. Now do you have the subform in the main form (frmprint?) done? -- Dave Hargis, Microsoft Access MVP "The Uke" wrote: i got the unbound textboxes I know how to do that from another set up i have. but what does the command button need to do just run report. btw when i have the frmprint open can i click one of the boxs and i get a beep error "Klatuu" wrote: Not to worry. More likely I will get it wrong and cause you extra work. On the main form, you will need text boxes for the dates and a command button to run the report. -- Dave Hargis, Microsoft Access MVP "The Uke" wrote: Thanks i understand this stuff but not great, Just so we are on the same page Want i need is to open a form have in that form two unbound feilds were the date will go so the report has something to limit its self then there is a list of the 6 users checking off each user will run the report and print it accroding to the date field and the user that is it just want to make sure so if we get 10 step is it and its totally wrong you dont get frustrated with me.. also i remade my frmcheckbox i added a check and make the controlsource the print field Ok so i made another form (frmprint) with frmcheckbox as the subform "Klatuu" wrote: Great. I forgot to say that the control in the form for the new field PrintReport should be a check box, sorry. But you need that. Once you have done that, create a main form and make this form a sub form it it. Post back when you get that done. (BTW, you are pretty fast) -- Dave Hargis, Microsoft Access MVP "The Uke" wrote: ok i made the form it looks just like the query did "Klatuu" wrote: Okay, now create a new form with the query as the record source of the form. You will want the default view to be datasheet. This is going to be the subform to your main form, but for now, we will work with it on it's own. -- Dave Hargis, Microsoft Access MVP "The Uke" wrote: got it "Klatuu" wrote: Okay, let's start there. Create a new query in design view select your userid table select the columns you want to show Now in an empty column in the design grid, enter the following in the Field: row PrintReport: 0 Now when you run the query, you will see a column with the name PrintReport and for each row the value will be 0. When you have that working, post back. -- Dave Hargis, Microsoft Access MVP "The Uke" wrote: Klatuu, I would like you for sending me a response, but when it comes to programing im not fully blessed in totally understanding it need, I normally break it down into its smallest parts and work from there. I guess i would like to start with is it possiable to make a list of self generating checkboxs based upon a query of of userID table. "Klatuu" wrote: A cleaner way to do this would be to use a datasheet subform for the USERID table, but instead of using the table, use a query based on the table and add a calculated column to the query for the user to select - Something like: PrintReport: False in the Field row of the query builder or 0 As Print Report If you write your own SQL. Then you would bind this field to the check box control (chkPrintReport in the example below) on the form. Now you can loop through the subform's recordset to see if you need to print a report for that user. I think, based on your post, you want to print a separate report for each user checked, so I wrote the After Update event that way: Private Sub cmdReports_Click() Dim frm As Form Set frm = Me.MySubform.Form With frm.RecordsetClone Do While Not .EOF If frm.chkPrintReport Then Docmd.OpenReport "rptUsers", , , "[USER] = " & frm.txtUser End If Loop End With Set frm = Nothing End Sub -- Dave Hargis, Microsoft Access MVP "The Uke" wrote: On i want to make this kinda automated here is what i want to do I want to be able to open a form and have the from look up and use check boxs for all the users from everyone listed in the USERID table. Then as you check off each check box and enter a date range and hit a button a report will print a copy for each USERID that has been checked for that date range Is this possiable, and does anyone else have more questions The date range i understand how to do Its more how to feed the report of each checked off name and make it print (I think its need a loop) and How to make an expandable check box list |
#14
|
|||
|
|||
Mutliply reports all at once
Uke, I am going to have to work on this a bit and get back to you.
-- Dave Hargis, Microsoft Access MVP "The Uke" wrote: frmprint is the name of the from that has the dateboxs and the button with the subform of checkboxs (frmcheckbox) when it beeps im clicking on the check boxs but there is no check mark showing up that why i bring it up b/c i forsee this being a problem that no check mark is showing up "Klatuu" wrote: Is frmprint the name of the main form with the text boxes and command button? I don't know what the beep is about, but for the command button, we will need to put code behind it to run the reports when we get to that point. Now do you have the subform in the main form (frmprint?) done? -- Dave Hargis, Microsoft Access MVP "The Uke" wrote: i got the unbound textboxes I know how to do that from another set up i have. but what does the command button need to do just run report. btw when i have the frmprint open can i click one of the boxs and i get a beep error "Klatuu" wrote: Not to worry. More likely I will get it wrong and cause you extra work. On the main form, you will need text boxes for the dates and a command button to run the report. -- Dave Hargis, Microsoft Access MVP "The Uke" wrote: Thanks i understand this stuff but not great, Just so we are on the same page Want i need is to open a form have in that form two unbound feilds were the date will go so the report has something to limit its self then there is a list of the 6 users checking off each user will run the report and print it accroding to the date field and the user that is it just want to make sure so if we get 10 step is it and its totally wrong you dont get frustrated with me.. also i remade my frmcheckbox i added a check and make the controlsource the print field Ok so i made another form (frmprint) with frmcheckbox as the subform "Klatuu" wrote: Great. I forgot to say that the control in the form for the new field PrintReport should be a check box, sorry. But you need that. Once you have done that, create a main form and make this form a sub form it it. Post back when you get that done. (BTW, you are pretty fast) -- Dave Hargis, Microsoft Access MVP "The Uke" wrote: ok i made the form it looks just like the query did "Klatuu" wrote: Okay, now create a new form with the query as the record source of the form. You will want the default view to be datasheet. This is going to be the subform to your main form, but for now, we will work with it on it's own. -- Dave Hargis, Microsoft Access MVP "The Uke" wrote: got it "Klatuu" wrote: Okay, let's start there. Create a new query in design view select your userid table select the columns you want to show Now in an empty column in the design grid, enter the following in the Field: row PrintReport: 0 Now when you run the query, you will see a column with the name PrintReport and for each row the value will be 0. When you have that working, post back. -- Dave Hargis, Microsoft Access MVP "The Uke" wrote: Klatuu, I would like you for sending me a response, but when it comes to programing im not fully blessed in totally understanding it need, I normally break it down into its smallest parts and work from there. I guess i would like to start with is it possiable to make a list of self generating checkboxs based upon a query of of userID table. "Klatuu" wrote: A cleaner way to do this would be to use a datasheet subform for the USERID table, but instead of using the table, use a query based on the table and add a calculated column to the query for the user to select - Something like: PrintReport: False in the Field row of the query builder or 0 As Print Report If you write your own SQL. Then you would bind this field to the check box control (chkPrintReport in the example below) on the form. Now you can loop through the subform's recordset to see if you need to print a report for that user. I think, based on your post, you want to print a separate report for each user checked, so I wrote the After Update event that way: Private Sub cmdReports_Click() Dim frm As Form Set frm = Me.MySubform.Form With frm.RecordsetClone Do While Not .EOF If frm.chkPrintReport Then Docmd.OpenReport "rptUsers", , , "[USER] = " & frm.txtUser End If Loop End With Set frm = Nothing End Sub -- Dave Hargis, Microsoft Access MVP "The Uke" wrote: On i want to make this kinda automated here is what i want to do I want to be able to open a form and have the from look up and use check boxs for all the users from everyone listed in the USERID table. Then as you check off each check box and enter a date range and hit a button a report will print a copy for each USERID that has been checked for that date range Is this possiable, and does anyone else have more questions The date range i understand how to do Its more how to feed the report of each checked off name and make it print (I think its need a loop) and How to make an expandable check box list |
#15
|
|||
|
|||
Mutliply reports all at once
Dave,
I appreciate it, thanks "Klatuu" wrote: Uke, I am going to have to work on this a bit and get back to you. -- Dave Hargis, Microsoft Access MVP "The Uke" wrote: frmprint is the name of the from that has the dateboxs and the button with the subform of checkboxs (frmcheckbox) when it beeps im clicking on the check boxs but there is no check mark showing up that why i bring it up b/c i forsee this being a problem that no check mark is showing up "Klatuu" wrote: Is frmprint the name of the main form with the text boxes and command button? I don't know what the beep is about, but for the command button, we will need to put code behind it to run the reports when we get to that point. Now do you have the subform in the main form (frmprint?) done? -- Dave Hargis, Microsoft Access MVP "The Uke" wrote: i got the unbound textboxes I know how to do that from another set up i have. but what does the command button need to do just run report. btw when i have the frmprint open can i click one of the boxs and i get a beep error "Klatuu" wrote: Not to worry. More likely I will get it wrong and cause you extra work. On the main form, you will need text boxes for the dates and a command button to run the report. -- Dave Hargis, Microsoft Access MVP "The Uke" wrote: Thanks i understand this stuff but not great, Just so we are on the same page Want i need is to open a form have in that form two unbound feilds were the date will go so the report has something to limit its self then there is a list of the 6 users checking off each user will run the report and print it accroding to the date field and the user that is it just want to make sure so if we get 10 step is it and its totally wrong you dont get frustrated with me.. also i remade my frmcheckbox i added a check and make the controlsource the print field Ok so i made another form (frmprint) with frmcheckbox as the subform "Klatuu" wrote: Great. I forgot to say that the control in the form for the new field PrintReport should be a check box, sorry. But you need that. Once you have done that, create a main form and make this form a sub form it it. Post back when you get that done. (BTW, you are pretty fast) -- Dave Hargis, Microsoft Access MVP "The Uke" wrote: ok i made the form it looks just like the query did "Klatuu" wrote: Okay, now create a new form with the query as the record source of the form. You will want the default view to be datasheet. This is going to be the subform to your main form, but for now, we will work with it on it's own. -- Dave Hargis, Microsoft Access MVP "The Uke" wrote: got it "Klatuu" wrote: Okay, let's start there. Create a new query in design view select your userid table select the columns you want to show Now in an empty column in the design grid, enter the following in the Field: row PrintReport: 0 Now when you run the query, you will see a column with the name PrintReport and for each row the value will be 0. When you have that working, post back. -- Dave Hargis, Microsoft Access MVP "The Uke" wrote: Klatuu, I would like you for sending me a response, but when it comes to programing im not fully blessed in totally understanding it need, I normally break it down into its smallest parts and work from there. I guess i would like to start with is it possiable to make a list of self generating checkboxs based upon a query of of userID table. "Klatuu" wrote: A cleaner way to do this would be to use a datasheet subform for the USERID table, but instead of using the table, use a query based on the table and add a calculated column to the query for the user to select - Something like: PrintReport: False in the Field row of the query builder or 0 As Print Report If you write your own SQL. Then you would bind this field to the check box control (chkPrintReport in the example below) on the form. Now you can loop through the subform's recordset to see if you need to print a report for that user. I think, based on your post, you want to print a separate report for each user checked, so I wrote the After Update event that way: Private Sub cmdReports_Click() Dim frm As Form Set frm = Me.MySubform.Form With frm.RecordsetClone Do While Not .EOF If frm.chkPrintReport Then Docmd.OpenReport "rptUsers", , , "[USER] = " & frm.txtUser End If Loop End With Set frm = Nothing End Sub -- Dave Hargis, Microsoft Access MVP "The Uke" wrote: On i want to make this kinda automated here is what i want to do I want to be able to open a form and have the from look up and use check boxs for all the users from everyone listed in the USERID table. Then as you check off each check box and enter a date range and hit a button a report will print a copy for each USERID that has been checked for that date range Is this possiable, and does anyone else have more questions The date range i understand how to do Its more how to feed the report of each checked off name and make it print (I think its need a loop) and How to make an expandable check box list |
#16
|
|||
|
|||
Mutliply reports all at once
Hi Dave,
Just woundering how it was going "Klatuu" wrote: Uke, I am going to have to work on this a bit and get back to you. -- Dave Hargis, Microsoft Access MVP "The Uke" wrote: frmprint is the name of the from that has the dateboxs and the button with the subform of checkboxs (frmcheckbox) when it beeps im clicking on the check boxs but there is no check mark showing up that why i bring it up b/c i forsee this being a problem that no check mark is showing up "Klatuu" wrote: Is frmprint the name of the main form with the text boxes and command button? I don't know what the beep is about, but for the command button, we will need to put code behind it to run the reports when we get to that point. Now do you have the subform in the main form (frmprint?) done? -- Dave Hargis, Microsoft Access MVP "The Uke" wrote: i got the unbound textboxes I know how to do that from another set up i have. but what does the command button need to do just run report. btw when i have the frmprint open can i click one of the boxs and i get a beep error "Klatuu" wrote: Not to worry. More likely I will get it wrong and cause you extra work. On the main form, you will need text boxes for the dates and a command button to run the report. -- Dave Hargis, Microsoft Access MVP "The Uke" wrote: Thanks i understand this stuff but not great, Just so we are on the same page Want i need is to open a form have in that form two unbound feilds were the date will go so the report has something to limit its self then there is a list of the 6 users checking off each user will run the report and print it accroding to the date field and the user that is it just want to make sure so if we get 10 step is it and its totally wrong you dont get frustrated with me.. also i remade my frmcheckbox i added a check and make the controlsource the print field Ok so i made another form (frmprint) with frmcheckbox as the subform "Klatuu" wrote: Great. I forgot to say that the control in the form for the new field PrintReport should be a check box, sorry. But you need that. Once you have done that, create a main form and make this form a sub form it it. Post back when you get that done. (BTW, you are pretty fast) -- Dave Hargis, Microsoft Access MVP "The Uke" wrote: ok i made the form it looks just like the query did "Klatuu" wrote: Okay, now create a new form with the query as the record source of the form. You will want the default view to be datasheet. This is going to be the subform to your main form, but for now, we will work with it on it's own. -- Dave Hargis, Microsoft Access MVP "The Uke" wrote: got it "Klatuu" wrote: Okay, let's start there. Create a new query in design view select your userid table select the columns you want to show Now in an empty column in the design grid, enter the following in the Field: row PrintReport: 0 Now when you run the query, you will see a column with the name PrintReport and for each row the value will be 0. When you have that working, post back. -- Dave Hargis, Microsoft Access MVP "The Uke" wrote: Klatuu, I would like you for sending me a response, but when it comes to programing im not fully blessed in totally understanding it need, I normally break it down into its smallest parts and work from there. I guess i would like to start with is it possiable to make a list of self generating checkboxs based upon a query of of userID table. "Klatuu" wrote: A cleaner way to do this would be to use a datasheet subform for the USERID table, but instead of using the table, use a query based on the table and add a calculated column to the query for the user to select - Something like: PrintReport: False in the Field row of the query builder or 0 As Print Report If you write your own SQL. Then you would bind this field to the check box control (chkPrintReport in the example below) on the form. Now you can loop through the subform's recordset to see if you need to print a report for that user. I think, based on your post, you want to print a separate report for each user checked, so I wrote the After Update event that way: Private Sub cmdReports_Click() Dim frm As Form Set frm = Me.MySubform.Form With frm.RecordsetClone Do While Not .EOF If frm.chkPrintReport Then Docmd.OpenReport "rptUsers", , , "[USER] = " & frm.txtUser End If Loop End With Set frm = Nothing End Sub -- Dave Hargis, Microsoft Access MVP "The Uke" wrote: On i want to make this kinda automated here is what i want to do I want to be able to open a form and have the from look up and use check boxs for all the users from everyone listed in the USERID table. Then as you check off each check box and enter a date range and hit a button a report will print a copy for each USERID that has been checked for that date range Is this possiable, and does anyone else have more questions The date range i understand how to do Its more how to feed the report of each checked off name and make it print (I think its need a loop) and How to make an expandable check box list |
#17
|
|||
|
|||
Mutliply reports all at once
Sorry to be so long getting back.
I found out what I was thinking about was not what you are doing. My memory confused me. Sorry to put you through all this. One way you can do it might be to add a Yes/No field to your table just for this purpose. You can still use the subform you created, just bind the checkbox control to the new field. Then you should be able to use it. Now, two additional things have to happen. Before you actually run the report, you need to requery the subform. And when you close your main form, you need to run an update query that will set all the yes/no checkbox fields in the table back to false. The only other option is a temporary table. Please pardon my mistake. -- Dave Hargis, Microsoft Access MVP "The Uke" wrote: Hi Dave, Just woundering how it was going "Klatuu" wrote: Uke, I am going to have to work on this a bit and get back to you. -- Dave Hargis, Microsoft Access MVP "The Uke" wrote: frmprint is the name of the from that has the dateboxs and the button with the subform of checkboxs (frmcheckbox) when it beeps im clicking on the check boxs but there is no check mark showing up that why i bring it up b/c i forsee this being a problem that no check mark is showing up "Klatuu" wrote: Is frmprint the name of the main form with the text boxes and command button? I don't know what the beep is about, but for the command button, we will need to put code behind it to run the reports when we get to that point. Now do you have the subform in the main form (frmprint?) done? -- Dave Hargis, Microsoft Access MVP "The Uke" wrote: i got the unbound textboxes I know how to do that from another set up i have. but what does the command button need to do just run report. btw when i have the frmprint open can i click one of the boxs and i get a beep error "Klatuu" wrote: Not to worry. More likely I will get it wrong and cause you extra work. On the main form, you will need text boxes for the dates and a command button to run the report. -- Dave Hargis, Microsoft Access MVP "The Uke" wrote: Thanks i understand this stuff but not great, Just so we are on the same page Want i need is to open a form have in that form two unbound feilds were the date will go so the report has something to limit its self then there is a list of the 6 users checking off each user will run the report and print it accroding to the date field and the user that is it just want to make sure so if we get 10 step is it and its totally wrong you dont get frustrated with me.. also i remade my frmcheckbox i added a check and make the controlsource the print field Ok so i made another form (frmprint) with frmcheckbox as the subform "Klatuu" wrote: Great. I forgot to say that the control in the form for the new field PrintReport should be a check box, sorry. But you need that. Once you have done that, create a main form and make this form a sub form it it. Post back when you get that done. (BTW, you are pretty fast) -- Dave Hargis, Microsoft Access MVP "The Uke" wrote: ok i made the form it looks just like the query did "Klatuu" wrote: Okay, now create a new form with the query as the record source of the form. You will want the default view to be datasheet. This is going to be the subform to your main form, but for now, we will work with it on it's own. -- Dave Hargis, Microsoft Access MVP "The Uke" wrote: got it "Klatuu" wrote: Okay, let's start there. Create a new query in design view select your userid table select the columns you want to show Now in an empty column in the design grid, enter the following in the Field: row PrintReport: 0 Now when you run the query, you will see a column with the name PrintReport and for each row the value will be 0. When you have that working, post back. -- Dave Hargis, Microsoft Access MVP "The Uke" wrote: Klatuu, I would like you for sending me a response, but when it comes to programing im not fully blessed in totally understanding it need, I normally break it down into its smallest parts and work from there. I guess i would like to start with is it possiable to make a list of self generating checkboxs based upon a query of of userID table. "Klatuu" wrote: A cleaner way to do this would be to use a datasheet subform for the USERID table, but instead of using the table, use a query based on the table and add a calculated column to the query for the user to select - Something like: PrintReport: False in the Field row of the query builder or 0 As Print Report If you write your own SQL. Then you would bind this field to the check box control (chkPrintReport in the example below) on the form. Now you can loop through the subform's recordset to see if you need to print a report for that user. I think, based on your post, you want to print a separate report for each user checked, so I wrote the After Update event that way: Private Sub cmdReports_Click() Dim frm As Form Set frm = Me.MySubform.Form With frm.RecordsetClone Do While Not .EOF If frm.chkPrintReport Then Docmd.OpenReport "rptUsers", , , "[USER] = " & frm.txtUser End If Loop End With Set frm = Nothing End Sub -- Dave Hargis, Microsoft Access MVP "The Uke" wrote: On i want to make this kinda automated here is what i want to do I want to be able to open a form and have the from look up and use check boxs for all the users from everyone listed in the USERID table. Then as you check off each check box and enter a date range and hit a button a report will print a copy for each USERID that has been checked for that date range Is this possiable, and does anyone else have more questions The date range i understand how to do Its more how to feed the report of each checked off name and make it print (I think its need a loop) and How to make an expandable check box list |
|
Thread Tools | |
Display Modes | |
|
|