Mutliply reports all at once

[The Uke]

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

 

[Klatuu]

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

 

[The Uke]

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.

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

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

 

[Klatuu]

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

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.

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

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

 

[The Uke]

got it

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

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.

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


:

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

 

[Klatuu]

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

got it

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

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.

:

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


:

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

 

[The Uke]

ok i made the form it looks just like the query did

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

got it

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


:

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.

:

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


:

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

 

[Klatuu]

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

ok i made the form it looks just like the query did

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

got it

:

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


:

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.

:

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


:

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

 

[The Uke]

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

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

ok i made the form it looks just like the query did

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


:

got it

:

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


:

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.

:

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


:

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

 

[Klatuu]

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

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

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

ok i made the form it looks just like the query did

:

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


:

got it

:

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


:

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.

:

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


:

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

 

[The Uke]

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

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

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

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


:

ok i made the form it looks just like the query did

:

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


:

got it

:

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


:

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.

:

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


:

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

 

[Klatuu]

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

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

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

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

:

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


:

ok i made the form it looks just like the query did

:

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


:

got it

:

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


:

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.

:

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


:

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

 

[The Uke]

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

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

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

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


:

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

:

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


:

ok i made the form it looks just like the query did

:

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


:

got it

:

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


:

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.

:

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


:

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

 

[Klatuu]

Uke, I am going to have to work on this a bit and get back to you.
--
Dave Hargis, Microsoft Access MVP

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

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

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

:

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


:

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

:

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


:

ok i made the form it looks just like the query did

:

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


:

got it

:

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


:

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.

:

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


:

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

 

[The Uke]

Dave,
I appreciate it, thanks

Uke, I am going to have to work on this a bit and get back to you.
--
Dave Hargis, Microsoft Access MVP

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

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


:

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

:

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


:

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

:

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


:

ok i made the form it looks just like the query did

:

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


:

got it

:

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


:

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.

:

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


:

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

 

[The Uke]

Hi Dave,
Just woundering how it was going

Uke, I am going to have to work on this a bit and get back to you.
--
Dave Hargis, Microsoft Access MVP

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

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


:

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

:

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


:

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

:

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


:

ok i made the form it looks just like the query did

:

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


:

got it

:

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


:

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.

:

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


:

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

 

[Klatuu]

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

Hi Dave,
Just woundering how it was going

Uke, I am going to have to work on this a bit and get back to you.
--
Dave Hargis, Microsoft Access MVP

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


:

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


:

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

:

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


:

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

:

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


:

ok i made the form it looks just like the query did

:

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


:

got it

:

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


:

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.

:

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


:

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