Open 5 combined Reports

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

"Johnny-Walker via AccessMonster.com" u58651@uwe wrote in message
news:a5d88ff44f47e@uwe...
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.


Gina Whipp wrote:
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!

Gina Whipp wrote:
Johnny-Walker,

[quoted text clipped - 57 lines]

Thank Again Gina I really appreciate Your Help!!!

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/201003/1

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

"Johnny-Walker via AccessMonster.com" u58651@uwe wrote in message
news:a5d88ff44f47e@uwe...
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.


Gina Whipp wrote:
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!

Gina Whipp wrote:
Johnny-Walker,

[quoted text clipped - 57 lines]

Thank Again Gina I really appreciate Your Help!!!

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/201003/1

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?

Gina Whipp wrote:
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.

Gina Whipp wrote:
Johnny,

[quoted text clipped - 14 lines]

Thank Again Gina I really appreciate Your Help!!!

--
Message posted via http://www.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?

Gina Whipp wrote:
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.

Gina Whipp wrote:
Johnny,

[quoted text clipped - 14 lines]

Thank Again Gina I really appreciate Your Help!!!

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/201004/1

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

"Johnny-Walker via AccessMonster.com" u58651@uwe wrote in message
news:a62e0e3304b60@uwe...
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?

Gina Whipp wrote:
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.

Gina Whipp wrote:
Johnny,

[quoted text clipped - 14 lines]

Thank Again Gina I really appreciate Your Help!!!

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/201004/1