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
|
|||
|
|||
Mutliply reports all at once
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 |
#2
|
|||
|
|||
Mutliply reports all at once
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 |
#3
|
|||
|
|||
Mutliply reports all at once
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 |
#4
|
|||
|
|||
Mutliply reports all at once
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 |
#5
|
|||
|
|||
Mutliply reports all at once
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 |
#6
|
|||
|
|||
Mutliply reports all at once
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 |
#7
|
|||
|
|||
Mutliply reports all at once
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 |
#8
|
|||
|
|||
Mutliply reports all at once
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 |
#9
|
|||
|
|||
Mutliply reports all at once
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 |
#10
|
|||
|
|||
Mutliply reports all at once
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 | |
|
|