Open 5 combined Reports

[Johnny-Walker via AccessMonster.com]

I create an form in Access which requires an employee ID # to open the Form
and enter data on the employee, the data then appears on a 5 page report.
Problem is I have to enter the employee ID # all 5 time sto open the reports.
ANY WAY TO SET THE REPORTS UP SO I ONLY HAVRE TO ENTER THE EMPLOYEE ID # 1
TIME FOR ALL 5 PAGES TO OPEN?

THANK YOU IN ADVANCE FOR ANY HELP ON THIS!!!!!!

 

[Gina Whipp]

Johnny-Walker,

On the button on your form that open your reports use...

'If EmployeeID is numeric
DoCmd.OpenReport "YourReportName", acViewPreview, , "[YourEmployeeIDField]="
& Me![cboYourEmployeeIDFieldOnForm]

OR

'If EmployeeID is text
DoCmd.OpenReport "YourReportName", acViewPreview, ,
"[YourEmployeeIDField]='" & Me![cboYourEmployeeIDFieldOnForm] & "'"

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I create an form in Access which requires an employee ID # to open the Form
and enter data on the employee, the data then appears on a 5 page report.
Problem is I have to enter the employee ID # all 5 time sto open the
reports.
ANY WAY TO SET THE REPORTS UP SO I ONLY HAVRE TO ENTER THE EMPLOYEE ID # 1
TIME FOR ALL 5 PAGES TO OPEN?

THANK YOU IN ADVANCE FOR ANY HELP ON THIS!!!!!!

 

[Johnny-Walker via AccessMonster.com]

Johnny-Walker,

On the button on your form that open your reports use...

'If EmployeeID is numeric
DoCmd.OpenReport "YourReportName", acViewPreview, , "[YourEmployeeIDField]="
& Me![cboYourEmployeeIDFieldOnForm]

OR

'If EmployeeID is text
DoCmd.OpenReport "YourReportName", acViewPreview, ,
"[YourEmployeeIDField]='" & Me![cboYourEmployeeIDFieldOnForm] & "'"

I create an form in Access which requires an employee ID # to open the Form
and enter data on the employee, the data then appears on a 5 page report.
Problem is I have to enter the employee ID # all 5 time sto open the
reports.
ANY WAY TO SET THE REPORTS UP SO I ONLY HAVRE TO ENTER THE EMPLOYEE ID # 1
TIME FOR ALL 5 PAGES TO OPEN?

THANK YOU IN ADVANCE FOR ANY HELP ON THIS!!!!!!

Gina,


I am new to this so I have a few questions: I start by clicking on the first
report & then a box opens to enter the ID# of the employee records I am
looking for. I re-enter the same ID in the rest of the boxes to open the
rest of the 4 remaining reports to open all of them. The reports are driven
from a query and under the ID# in the query I put [Enter Employee ID Number:]
So

1st question can I enter the code you provided in a macro and set the 1st
report to open the additional reports On Click?

the Id#'s are from 70 to 600 do I enter that range in the code you provided ?

and in the code you provided do I seperate each report name with a comma?

Example:

DoCmd.OpenReport "Page1,Page2,Page3,Page4,Page5", acViewPreview, ,

"[YourEmployeeIDField]='" & Me![cboYourEmployeeIDFieldOnForm] & "'"

where would I ente rthe Id# range example 07-600

Thank Again Gina I really appreciate Your Help!!!

 

[Gina Whipp]

Johnny-Walker,

Okay... the code I provided is not for a macro and does not allow for using
the query to select the ID. The way I *thought* you were selecting the ID
was via a form AND you would only include one report per line, ie...

1. Form opens with combo box where you would select the ID
2. Button on form to open your report would include this in the On_Click
event of the button...

DoCmd.OpenReport "Page1", acViewPreview, ,"[YourEmployeeIDField]='" &
Me![cboYourEmployeeIDFieldOnForm] & "'"
DoCmd.OpenReport "Page2", acViewPreview, ,"[YourEmployeeIDField]='" &
Me![cboYourEmployeeIDFieldOnForm] & "'"
DoCmd.OpenReport "Page3", acViewPreview, ,"[YourEmployeeIDField]='" &
Me![cboYourEmployeeIDFieldOnForm] & "'"
DoCmd.OpenReport "Page4", acViewPreview, ,"[YourEmployeeIDField]='" &
Me![cboYourEmployeeIDFieldOnForm] & "'"
DoCmd.OpenReport "Page5", acViewPreview, ,"[YourEmployeeIDField]='" &
Me![cboYourEmployeeIDFieldOnForm] & "'"

OR if you put the pages on page 1 as subreports (with pagebreaks) linked by
ID then...

DoCmd.OpenReport "Page1", acViewPreview, ,"[YourEmployeeIDField]='" &
Me![cboYourEmployeeIDFieldOnForm] & "'"

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Johnny-Walker,

On the button on your form that open your reports use...

'If EmployeeID is numeric
DoCmd.OpenReport "YourReportName", acViewPreview, ,
"[YourEmployeeIDField]="
& Me![cboYourEmployeeIDFieldOnForm]

OR

'If EmployeeID is text
DoCmd.OpenReport "YourReportName", acViewPreview, ,
"[YourEmployeeIDField]='" & Me![cboYourEmployeeIDFieldOnForm] & "'"

I create an form in Access which requires an employee ID # to open the Form
and enter data on the employee, the data then appears on a 5 page report.
Problem is I have to enter the employee ID # all 5 time sto open the
reports.
ANY WAY TO SET THE REPORTS UP SO I ONLY HAVRE TO ENTER THE EMPLOYEE ID # 1
TIME FOR ALL 5 PAGES TO OPEN?

THANK YOU IN ADVANCE FOR ANY HELP ON THIS!!!!!!

Gina,


I am new to this so I have a few questions: I start by clicking on the first
report & then a box opens to enter the ID# of the employee records I am
looking for. I re-enter the same ID in the rest of the boxes to open the
rest of the 4 remaining reports to open all of them. The reports are driven
from a query and under the ID# in the query I put [Enter Employee ID
Number:]
So

1st question can I enter the code you provided in a macro and set the 1st
report to open the additional reports On Click?

the Id#'s are from 70 to 600 do I enter that range in the code you provided
?

and in the code you provided do I seperate each report name with a comma?

Example:

DoCmd.OpenReport "Page1,Page2,Page3,Page4,Page5", acViewPreview, ,

"[YourEmployeeIDField]='" & Me![cboYourEmployeeIDFieldOnForm] & "'"

where would I ente rthe Id# range example 07-600

Thank Again Gina I really appreciate Your Help!!!

 

[Johnny-Walker via AccessMonster.com]

Hi Gina,

Thanks for all your help, It looks like I will need to find some one to look
at what I'm doing because I am sure the problem is with the way I set things
up, but I wanted to thank you for trying to help me get on track!

Johnny-Walker,

Okay... the code I provided is not for a macro and does not allow for using
the query to select the ID. The way I *thought* you were selecting the ID
was via a form AND you would only include one report per line, ie...

1. Form opens with combo box where you would select the ID
2. Button on form to open your report would include this in the On_Click
event of the button...

DoCmd.OpenReport "Page1", acViewPreview, ,"[YourEmployeeIDField]='" &
Me![cboYourEmployeeIDFieldOnForm] & "'"
DoCmd.OpenReport "Page2", acViewPreview, ,"[YourEmployeeIDField]='" &
Me![cboYourEmployeeIDFieldOnForm] & "'"
DoCmd.OpenReport "Page3", acViewPreview, ,"[YourEmployeeIDField]='" &
Me![cboYourEmployeeIDFieldOnForm] & "'"
DoCmd.OpenReport "Page4", acViewPreview, ,"[YourEmployeeIDField]='" &
Me![cboYourEmployeeIDFieldOnForm] & "'"
DoCmd.OpenReport "Page5", acViewPreview, ,"[YourEmployeeIDField]='" &
Me![cboYourEmployeeIDFieldOnForm] & "'"

OR if you put the pages on page 1 as subreports (with pagebreaks) linked by
ID then...

DoCmd.OpenReport "Page1", acViewPreview, ,"[YourEmployeeIDField]='" &
Me![cboYourEmployeeIDFieldOnForm] & "'"

Johnny-Walker,

[quoted text clipped - 19 lines]

THANK YOU IN ADVANCE FOR ANY HELP ON THIS!!!!!!

Gina,

I am new to this so I have a few questions: I start by clicking on the first
report & then a box opens to enter the ID# of the employee records I am
looking for. I re-enter the same ID in the rest of the boxes to open the
rest of the 4 remaining reports to open all of them. The reports are driven
from a query and under the ID# in the query I put [Enter Employee ID
Number:]
So

1st question can I enter the code you provided in a macro and set the 1st
report to open the additional reports On Click?

the Id#'s are from 70 to 600 do I enter that range in the code you provided
?

and in the code you provided do I seperate each report name with a comma?

Example:

DoCmd.OpenReport "Page1,Page2,Page3,Page4,Page5", acViewPreview, ,

"[YourEmployeeIDField]='" & Me![cboYourEmployeeIDFieldOnForm] & "'"

where would I ente rthe Id# range example 07-600

Thank Again Gina I really appreciate Your Help!!!

 

[Gina Whipp]

Johnny,

Well, you didn't tell me what's happening... I could look at the database
but it probably won't be till tomorrow, if you can wait!

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hi Gina,

Thanks for all your help, It looks like I will need to find some one to look
at what I'm doing because I am sure the problem is with the way I set things
up, but I wanted to thank you for trying to help me get on track!

Johnny-Walker,

Okay... the code I provided is not for a macro and does not allow for using
the query to select the ID. The way I *thought* you were selecting the ID
was via a form AND you would only include one report per line, ie...

1. Form opens with combo box where you would select the ID
2. Button on form to open your report would include this in the On_Click
event of the button...

DoCmd.OpenReport "Page1", acViewPreview, ,"[YourEmployeeIDField]='" &
Me![cboYourEmployeeIDFieldOnForm] & "'"
DoCmd.OpenReport "Page2", acViewPreview, ,"[YourEmployeeIDField]='" &
Me![cboYourEmployeeIDFieldOnForm] & "'"
DoCmd.OpenReport "Page3", acViewPreview, ,"[YourEmployeeIDField]='" &
Me![cboYourEmployeeIDFieldOnForm] & "'"
DoCmd.OpenReport "Page4", acViewPreview, ,"[YourEmployeeIDField]='" &
Me![cboYourEmployeeIDFieldOnForm] & "'"
DoCmd.OpenReport "Page5", acViewPreview, ,"[YourEmployeeIDField]='" &
Me![cboYourEmployeeIDFieldOnForm] & "'"

OR if you put the pages on page 1 as subreports (with pagebreaks) linked by
ID then...

DoCmd.OpenReport "Page1", acViewPreview, ,"[YourEmployeeIDField]='" &
Me![cboYourEmployeeIDFieldOnForm] & "'"

Johnny-Walker,

[quoted text clipped - 19 lines]

THANK YOU IN ADVANCE FOR ANY HELP ON THIS!!!!!!

Gina,

I am new to this so I have a few questions: I start by clicking on the
first
report & then a box opens to enter the ID# of the employee records I am
looking for. I re-enter the same ID in the rest of the boxes to open the
rest of the 4 remaining reports to open all of them. The reports are
driven
from a query and under the ID# in the query I put [Enter Employee ID
Number:]
So

1st question can I enter the code you provided in a macro and set the 1st
report to open the additional reports On Click?

the Id#'s are from 70 to 600 do I enter that range in the code you provided
?

and in the code you provided do I seperate each report name with a comma?

Example:

DoCmd.OpenReport "Page1,Page2,Page3,Page4,Page5", acViewPreview, ,

"[YourEmployeeIDField]='" & Me![cboYourEmployeeIDFieldOnForm] & "'"

where would I ente rthe Id# range example 07-600

Thank Again Gina I really appreciate Your Help!!!

 

[Johnny-Walker via AccessMonster.com]

That would be great, let me know when you have time and I will send you a
copy of the database, I can be reached at (e-mail address removed)

Thank You!!

Johnny,

Well, you didn't tell me what's happening... I could look at the database
but it probably won't be till tomorrow, if you can wait!

Hi Gina,

Thanks for all your help, It looks like I will need to find some one to look
at what I'm doing because I am sure the problem is with the way I set things
up, but I wanted to thank you for trying to help me get on track!

Johnny-Walker,

[quoted text clipped - 57 lines]

Thank Again Gina I really appreciate Your Help!!!

 

[Johnny-Walker via AccessMonster.com]

That would be great, let me know when you have time and I will send you a
copy of the database, I can be reached at (e-mail address removed)

Thank You!!

Johnny,

Well, you didn't tell me what's happening... I could look at the database
but it probably won't be till tomorrow, if you can wait!

Hi Gina,

Thanks for all your help, It looks like I will need to find some one to look
at what I'm doing because I am sure the problem is with the way I set things
up, but I wanted to thank you for trying to help me get on track!

Johnny-Walker,

[quoted text clipped - 57 lines]

Thank Again Gina I really appreciate Your Help!!!

 

[Gina Whipp]

Johnny,

*Never* post your real eMail address in a public newsgroup. The spammers
will harvest it and, well, you know what happens after that. Please go to
my web page (www.regina-whipp.com) and click the button on the home page and
attach you database and send it to me. Please put your name from the
newsgroup in the Subject Line or you will end up in the trash!

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Johnny,

Well, you didn't tell me what's happening... I could look at the database
but it probably won't be till tomorrow, if you can wait!

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hi Gina,

Thanks for all your help, It looks like I will need to find some one to look
at what I'm doing because I am sure the problem is with the way I set things
up, but I wanted to thank you for trying to help me get on track!

Johnny-Walker,

Okay... the code I provided is not for a macro and does not allow for using
the query to select the ID. The way I *thought* you were selecting the ID
was via a form AND you would only include one report per line, ie...

1. Form opens with combo box where you would select the ID
2. Button on form to open your report would include this in the On_Click
event of the button...

DoCmd.OpenReport "Page1", acViewPreview, ,"[YourEmployeeIDField]='" &
Me![cboYourEmployeeIDFieldOnForm] & "'"
DoCmd.OpenReport "Page2", acViewPreview, ,"[YourEmployeeIDField]='" &
Me![cboYourEmployeeIDFieldOnForm] & "'"
DoCmd.OpenReport "Page3", acViewPreview, ,"[YourEmployeeIDField]='" &
Me![cboYourEmployeeIDFieldOnForm] & "'"
DoCmd.OpenReport "Page4", acViewPreview, ,"[YourEmployeeIDField]='" &
Me![cboYourEmployeeIDFieldOnForm] & "'"
DoCmd.OpenReport "Page5", acViewPreview, ,"[YourEmployeeIDField]='" &
Me![cboYourEmployeeIDFieldOnForm] & "'"

OR if you put the pages on page 1 as subreports (with pagebreaks) linked by
ID then...

DoCmd.OpenReport "Page1", acViewPreview, ,"[YourEmployeeIDField]='" &
Me![cboYourEmployeeIDFieldOnForm] & "'"

Johnny-Walker,

[quoted text clipped - 19 lines]

THANK YOU IN ADVANCE FOR ANY HELP ON THIS!!!!!!

Gina,

I am new to this so I have a few questions: I start by clicking on the
first
report & then a box opens to enter the ID# of the employee records I am
looking for. I re-enter the same ID in the rest of the boxes to open the
rest of the 4 remaining reports to open all of them. The reports are
driven
from a query and under the ID# in the query I put [Enter Employee ID
Number:]
So

1st question can I enter the code you provided in a macro and set the 1st
report to open the additional reports On Click?

the Id#'s are from 70 to 600 do I enter that range in the code you provided
?

and in the code you provided do I seperate each report name with a comma?

Example:

DoCmd.OpenReport "Page1,Page2,Page3,Page4,Page5", acViewPreview, ,

"[YourEmployeeIDField]='" & Me![cboYourEmployeeIDFieldOnForm] & "'"

where would I ente rthe Id# range example 07-600

Thank Again Gina I really appreciate Your Help!!!

 

[Johnny-Walker via AccessMonster.com]

Gina,

I made the changes you suggested and used a combo box to look up the name in
the form and that works, but when I open a report, it just opens up to the
first person on the list, not the one I am working on in the form.

Johnny,

Well, you didn't tell me what's happening... I could look at the database
but it probably won't be till tomorrow, if you can wait!

Hi Gina,

Thanks for all your help, It looks like I will need to find some one to look
at what I'm doing because I am sure the problem is with the way I set things
up, but I wanted to thank you for trying to help me get on track!

Johnny-Walker,

[quoted text clipped - 57 lines]

Thank Again Gina I really appreciate Your Help!!!

 

[Gina Whipp]

I am sooo sorry... I have a little tied up. I will look at your database
tonight!

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Gina,

I made the changes you suggested and used a combo box to look up the name in
the form and that works, but when I open a report, it just opens up to the
first person on the list, not the one I am working on in the form.

Johnny,

Well, you didn't tell me what's happening... I could look at the database
but it probably won't be till tomorrow, if you can wait!

Hi Gina,

Thanks for all your help, It looks like I will need to find some one to
look
at what I'm doing because I am sure the problem is with the way I set
things
up, but I wanted to thank you for trying to help me get on track!

Johnny-Walker,

[quoted text clipped - 57 lines]

Thank Again Gina I really appreciate Your Help!!!

 

[Gina Whipp]

JW,

I returned the database... what you missed was...

1. Button has to go on the form and then the code is placed behind the
button. So I did remove the code from behind the report.
2. When using the combo box to link to a report never use the name as there
can be two of anybody. Use the Entities ID which is guaranteed to be unique
as long as you set it up as a Primary Key. BUT you can still look up and
individual by name because the Bound Column of the combo box and be hidden.

Observation... 3. I am a little concerned about your database as it is set
up more like an Excel spreadsheet (flat file format) then a database
(Relational). If you get some time I suggest you look at...

http://www.rogersaccesslibrary.com/forum/topic3.html

Observation... 4. Memo fields can be tricky as they are usually the first
to cause issues in a database. I usually store those in separate tables.
Observation... 5. You have 5 separate reports when you can put then all on
one report with pages breaks and set to grow. Unless there is another
reason you want to print them separately.

Post back with any additional questions...

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Gina,

I made the changes you suggested and used a combo box to look up the name in
the form and that works, but when I open a report, it just opens up to the
first person on the list, not the one I am working on in the form.

Johnny,

Well, you didn't tell me what's happening... I could look at the database
but it probably won't be till tomorrow, if you can wait!

Hi Gina,

Thanks for all your help, It looks like I will need to find some one to
look
at what I'm doing because I am sure the problem is with the way I set
things
up, but I wanted to thank you for trying to help me get on track!

Johnny-Walker,

[quoted text clipped - 57 lines]

Thank Again Gina I really appreciate Your Help!!!

 

[Johnny-Walker via AccessMonster.com]

Hi Gina,

In reference to the 5 page report both reports and the forms will only expand
to 22 inches in total. Once the entries are made in made report this would
exceed the 22 inch limit. So does the report expand beyond the 22 inch limit
if you insert page breaks?

JW,

I returned the database... what you missed was...

1. Button has to go on the form and then the code is placed behind the
button. So I did remove the code from behind the report.
2. When using the combo box to link to a report never use the name as there
can be two of anybody. Use the Entities ID which is guaranteed to be unique
as long as you set it up as a Primary Key. BUT you can still look up and
individual by name because the Bound Column of the combo box and be hidden.

Observation... 3. I am a little concerned about your database as it is set
up more like an Excel spreadsheet (flat file format) then a database
(Relational). If you get some time I suggest you look at...

http://www.rogersaccesslibrary.com/forum/topic3.html

Observation... 4. Memo fields can be tricky as they are usually the first
to cause issues in a database. I usually store those in separate tables.
Observation... 5. You have 5 separate reports when you can put then all on
one report with pages breaks and set to grow. Unless there is another
reason you want to print them separately.

Post back with any additional questions...

Gina,

I made the changes you suggested and used a combo box to look up the name in
the form and that works, but when I open a report, it just opens up to the
first person on the list, not the one I am working on in the form.

Johnny,

[quoted text clipped - 14 lines]

 

[Johnny-Walker via AccessMonster.com]

Hi Gina,

In reference to the 5 page report both reports and the forms will only expand
to 22 inches in total. Once the entries are made in made report this would
exceed the 22 inch limit. So does the report expand beyond the 22 inch limit
if you insert page breaks?

JW,

I returned the database... what you missed was...

1. Button has to go on the form and then the code is placed behind the
button. So I did remove the code from behind the report.
2. When using the combo box to link to a report never use the name as there
can be two of anybody. Use the Entities ID which is guaranteed to be unique
as long as you set it up as a Primary Key. BUT you can still look up and
individual by name because the Bound Column of the combo box and be hidden.

Observation... 3. I am a little concerned about your database as it is set
up more like an Excel spreadsheet (flat file format) then a database
(Relational). If you get some time I suggest you look at...

http://www.rogersaccesslibrary.com/forum/topic3.html

Observation... 4. Memo fields can be tricky as they are usually the first
to cause issues in a database. I usually store those in separate tables.
Observation... 5. You have 5 separate reports when you can put then all on
one report with pages breaks and set to grow. Unless there is another
reason you want to print them separately.

Post back with any additional questions...

Gina,

I made the changes you suggested and used a combo box to look up the name in
the form and that works, but when I open a report, it just opens up to the
first person on the list, not the one I am working on in the form.

Johnny,

[quoted text clipped - 14 lines]

 

[Gina Whipp]

JW.

You do not need to put the full subreport on the main report... just a
sliver and set it to can grow. The full page view will happen when you
print it.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hi Gina,

In reference to the 5 page report both reports and the forms will only
expand
to 22 inches in total. Once the entries are made in made report this would
exceed the 22 inch limit. So does the report expand beyond the 22 inch
limit
if you insert page breaks?

JW,

I returned the database... what you missed was...

1. Button has to go on the form and then the code is placed behind the
button. So I did remove the code from behind the report.
2. When using the combo box to link to a report never use the name as
there
can be two of anybody. Use the Entities ID which is guaranteed to be
unique
as long as you set it up as a Primary Key. BUT you can still look up and
individual by name because the Bound Column of the combo box and be hidden.

Observation... 3. I am a little concerned about your database as it is set
up more like an Excel spreadsheet (flat file format) then a database
(Relational). If you get some time I suggest you look at...

http://www.rogersaccesslibrary.com/forum/topic3.html

Observation... 4. Memo fields can be tricky as they are usually the first
to cause issues in a database. I usually store those in separate tables.
Observation... 5. You have 5 separate reports when you can put then all on
one report with pages breaks and set to grow. Unless there is another
reason you want to print them separately.

Post back with any additional questions...

Gina,

I made the changes you suggested and used a combo box to look up the name
in
the form and that works, but when I open a report, it just opens up to the
first person on the list, not the one I am working on in the form.

Johnny,

[quoted text clipped - 14 lines]