A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Mutliply reports all at once



 
 
Thread Tools Display Modes
  #11  
Old August 9th, 2007, 08:52 PM posted to microsoft.public.access.reports
The Uke[_2_]
external usenet poster
 
Posts: 42
Default 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  
Old August 9th, 2007, 08:56 PM posted to microsoft.public.access.reports
Klatuu
external usenet poster
 
Posts: 7,074
Default 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  
Old August 9th, 2007, 09:20 PM posted to microsoft.public.access.reports
The Uke[_2_]
external usenet poster
 
Posts: 42
Default 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  
Old August 9th, 2007, 09:24 PM posted to microsoft.public.access.reports
Klatuu
external usenet poster
 
Posts: 7,074
Default 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  
Old August 9th, 2007, 09:30 PM posted to microsoft.public.access.reports
The Uke[_2_]
external usenet poster
 
Posts: 42
Default 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  
Old August 10th, 2007, 09:16 PM posted to microsoft.public.access.reports
The Uke[_2_]
external usenet poster
 
Posts: 42
Default 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  
Old August 10th, 2007, 10:36 PM posted to microsoft.public.access.reports
Klatuu
external usenet poster
 
Posts: 7,074
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:03 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.