break table across pages but keep the control under it on first page

I am trying to create appointment reminder letters, and at the bottom
of the first page of each letter I need the clinic contact information
(phone number and name). Immediately prior to this I must list various
instructions regarding what to bring, what to eat/not eat beforehand,
etc.
Regardless of the length of the list of instructions I still need the
clinic contact information to render at the bottom of the 1st page of
every letter, even if the list of instructions has to continue on to
page 2.
When I create a table footer it only appears on the 1st page of the 1st
child's letter, while the other several hundred letters get no footer.
(surely this can be done in one .PDF instead of a subscription to
create several hundred separate .PDFs?)
Here's what I need for each child:
|Page 1|
<Patient address, etc.>
<Schedule of appointments for the day>
<List of instructions>
<Clinic CONTACT INFO> <--bottom of 1st page of EVERY letter
|Page 1|
|Page 2|
<any remaining items from the list of instructions above>
<rest of my report requirements here...>
Any suggestions on how to do this are greatly appreciated.
Thanks,
Stewart Whaley
Arkansas Children's HospitalPut the information in the Page footer and set the page footer properties to
only print on the first page.
If you have multiple items in the footer--some for page 1 and some for page
2, you will have to set the visibility in a formula.
"Stewart" <whaleysa@.archildrens.org> wrote in message
news:1121353944.165681.77900@.o13g2000cwo.googlegroups.com...
>I am trying to create appointment reminder letters, and at the bottom
> of the first page of each letter I need the clinic contact information
> (phone number and name). Immediately prior to this I must list various
> instructions regarding what to bring, what to eat/not eat beforehand,
> etc.
> Regardless of the length of the list of instructions I still need the
> clinic contact information to render at the bottom of the 1st page of
> every letter, even if the list of instructions has to continue on to
> page 2.
> When I create a table footer it only appears on the 1st page of the 1st
> child's letter, while the other several hundred letters get no footer.
> (surely this can be done in one .PDF instead of a subscription to
> create several hundred separate .PDFs?)
> Here's what I need for each child:
> |Page 1|
> <Patient address, etc.>
> <Schedule of appointments for the day>
> <List of instructions>
> <Clinic CONTACT INFO> <--bottom of 1st page of EVERY letter
> |Page 1|
> |Page 2|
> <any remaining items from the list of instructions above>
> <rest of my report requirements here...>
> Any suggestions on how to do this are greatly appreciated.
> Thanks,
> Stewart Whaley
> Arkansas Children's Hospital
>|||My problem now is that I have the footer on every page but the last of
every letter except for the very last page of the last kid's letter.
For example, I have:
<PAGE 1>
Bob Jones
1233 Jones Street
Allergy Clinic 9:00
Dental Clinic 10:30
Don't forget:
* Please don't eat Oreos before you dental appointment
* Don't pet tigers
Clinic contact info (this is in a the footer because it MUST be at the
bottom of the 1st page and only the 1st page of each kid's letter).
<PAGE 2>
Continuation of the "Don't Forget" list from page 2
Image of map for the particular clinic(s)
Clinic contact info footer is repeating here and I DON'T want this
repeated within the SAME letter.
PAGE 3 (Start of the next letter)
Jon Smith
111 1st Street
Allergy Clinic 9:30
Orthopedic Clinic 11:00
Don't forget:
* Please don't jump off of buildings
* Still don't pet tigers
Clinic contact information (as expected)
<PAGE 2>
Continuation of "Don't Forget" stuff here if it is long enough to
stretch to page 2
Clinic contact information footer repeated again but I don't want it
repeated.
..........
I don't know what to do but I just want the clinic contact info at the
bottom of only the 1st page of each letter.
Unfortunately, a single letter's isn't guaranteed to be 2 pages,
either, so I'm not sure I can come up with a formula for hiding the
footer on every page but the 1st for each kid...
Thanks,
Stewart

Bound control timing issues in Visual Basic

It is just me or...
I have two appications in very different environments that have
suddenly shown very similar behavior, after a fashion.
One application is simple desktop. I've been working on the development
off and on for a number of months. It uses controls bound to an Access
database. As a for instance, I have two list boxes where items are
copied from left to right and deleted from the left, a fairly standard
practice. After the delete from the left, the repaint should eliminate
the deleted item, which worked fine until just recently.
The client became very upset when the the control repainted with the
deleted item still displayed. And this was also happening with two grid
controls. It was making me quite nuts. I dug around until I found a
reference to 'sleep' and implemented it. The problem was resolved.
Therefore, the cursor in memory was not being overwritten in time to
keep up with the repaint.
I also have an application in a Citirx/Softricity environment that is
working just fine on several servers (it produces reports using the VB6
data report designer) but is failing on one. I have not yet seen the
results, but I've added the same 'Sleep' methodology to this
application. My current working assumption is that the application
(data report dll) does not have enough time to locate the remote
network printer in time to produce a display when requested by the
application. It's just a working assumption.
What I'm wondering is whether or not anyone else out there in VB land
particularly VB6 land has recently encountered any timing related
errors. I want to document this, if I'm not the only one encountering
the issues.
I'm bringing this up because of something I read around the time of the
emergency patch related to the possibility of viruses or trojans being
embbedded in graphic files. It suggested that the underlayment
(operating environment) was being adversly affected, that is it was
significantly slower to respond to certain requests, as a result of the
patch.
Thanks for your attention...Hello,
If you are using an Access database and you do not have a single
connection for the entire application, you may be running into this
issue:
http://support.microsoft.com/kb/q200300
Razvan

Bound Control on Access Form Causing High Memory Usage on SQL Server

I got about 50 Access users every day using the SQL Server
2000 database. At the end of the day, SQL Server always
ran out of the memory. Someone told me this is because of
the bound connection on the Access form causing the memory
leak. Is there a way to fix this problem without changing
my Access form design.not really.
acccess bound controls open numerous connections PER FORM.
this is not good.
only way to fix it would be to code your connectivity manually.
GAJ|||I currently have 2 GB physical memory which could last for
about 2 to 3 days if no one runs a big report. What if I
increase the memory size to 4 GB?

>--Original Message--
>not really.
>acccess bound controls open numerous connections PER FORM.
>this is not good.
>only way to fix it would be to code your connectivity
manually.
>
>GAJ
>
>.
>|||I suspect you will still eventually run out of connections and\or memory.
instead of using bound controls, write the code manually to populate
controls. that way you have explicit control over connection management.
will this work for you ?
GAJ|||Ken,
Are you sure it is really a memory leak? SQL Server will not release memory
once it grabs it unless the OS specifically calls for it. That is by
design. http://www.support.microsoft.com/?id=321363 Do you have things
other than sql server running on the same machine? If so you may want to
set your max memory setting to something less than the default of max and
see if that helps.
Andrew J. Kelly
SQL Server MVP
"Ken" <anonymous@.discussions.microsoft.com> wrote in message
news:bf6601c3ecfa$9f12e2a0$a401280a@.phx.gbl...
> I got about 50 Access users every day using the SQL Server
> 2000 database. At the end of the day, SQL Server always
> ran out of the memory. Someone told me this is because of
> the bound connection on the Access form causing the memory
> leak. Is there a way to fix this problem without changing
> my Access form design.

Bound Control on Access Form Causing High Memory Usage on SQL Server

I got about 50 Access users every day using the SQL Server
2000 database. At the end of the day, SQL Server always
ran out of the memory. Someone told me this is because of
the bound connection on the Access form causing the memory
leak. Is there a way to fix this problem without changing
my Access form design.not really.
acccess bound controls open numerous connections PER FORM.
this is not good.
only way to fix it would be to code your connectivity manually.
GAJ|||I currently have 2 GB physical memory which could last for
about 2 to 3 days if no one runs a big report. What if I
increase the memory size to 4 GB?
>--Original Message--
>not really.
>acccess bound controls open numerous connections PER FORM.
>this is not good.
>only way to fix it would be to code your connectivity
manually.
>
>GAJ
>
>.
>|||I suspect you will still eventually run out of connections and\or memory.
instead of using bound controls, write the code manually to populate
controls. that way you have explicit control over connection management.
will this work for you ?
GAJ|||Ken,
Are you sure it is really a memory leak? SQL Server will not release memory
once it grabs it unless the OS specifically calls for it. That is by
design. http://www.support.microsoft.com/?id=321363 Do you have things
other than sql server running on the same machine? If so you may want to
set your max memory setting to something less than the default of max and
see if that helps.
--
Andrew J. Kelly
SQL Server MVP
"Ken" <anonymous@.discussions.microsoft.com> wrote in message
news:bf6601c3ecfa$9f12e2a0$a401280a@.phx.gbl...
> I got about 50 Access users every day using the SQL Server
> 2000 database. At the end of the day, SQL Server always
> ran out of the memory. Someone told me this is because of
> the bound connection on the Access form causing the memory
> leak. Is there a way to fix this problem without changing
> my Access form design.