Re: Children's profile report

This really is an argument for top-posting. I've appended your first message
to the bottom of this one so that people can see all the facts which are
concealed in it. (some of us have to clean up our folders now and again and
not everyone wants to trawl through Google to find the original post).
Are you saying that you need a way to turn your PhotographName text field
back into a date and time field so that you can group by weeknumber and put
another subreport in the Week number footer or can you already do that?


Evi






OK, that's an idea. Let me illustrate. The existing report works well
(I will use "AOL" for "Area Of Learning") eg

Child
AOL1
Photo1 Photo2
Photo3 Photo4
AOL2
Photo5 Photo6
Photo7 Photo8
etc

Note: Child and AOL are in the main report (and are full width) and
the photos are in the sub-report (and are in two columns)

Now, what I need is to identify a particular photo by its date (dates
are implicit in the naming convention I use for the photos), suspend
the two column subreport, insert the project report (which itself
consists of a main and sub report) and then continue the original eg

Child
AOL1
Photo1 Photo2
Photo3 Photo4
AOL2
Photo5 Photo6
Photo7 Photo8
<----- Details of project centred on A4 page ----->
ProjectPhoto1 ProjectPhoto2
ProjectPhoto3 ProjectPhoto4
<----- Summary details of project centred ----->
Photo9 Photo10
Photo10 Photo11
etc

I'm having difficulty coming up with a way to insert the project
report

It's worth saying that the project report will always be inserted
first thing on a Monday ie after Friday's photos but before Monday's
so it might be that I need to further group all photos into individual
weeks eg week1, week2 etc to assist with this. I'm really not sure

Original Email:
We run a nursery school. As part of the children's profiles, we print
a report showing photographs of the children's
activities split into the various areas of learning eg physical
development (PD), creative development (CD) etc. The
sub-report, which contains the photographs, is a snaking report giving
us six photographs per page. The photographs are all named by the date
and time they were taken eg 200803110912 (ie taken at 12 minutes past
nine on the 11th March 2008). This allows them to be presented in the
order in which they were taken. The relevant table also has a sort
order field which mostly mirrors the filename but can be adjusted if
non-sequential photos need to be presented next to each other.

We now have a requirement in one of the areas of learning (knowledge
and understanding of the world - KUW) to insert into the report a
series of pre-selected photographs which illustrate a particular
week's project, along with a heading and explanation of the project.
The heading and explanation need to be full width so can't be included
in the snaking sub-report but the photographs associated with the
project do need to snake

In other words, the existing report has to be adjusted in some way to
allow the snaking photos in the KUW section to be interrupted, at the
right date, by a full width section of text (heading and explanation),
followed by snaking photos just of the project, followed by the rest
of the child's KUW photos, until the date of the next project when the
situation repeats itself. It's the process of how to interrupt the
current report, bung in the project report and then continue with the
original report that is causing me difficulties. Any pointers please?


.

Relevant Pages

  • Re: AddPicture in VBA without explict reference to a file path?
    ... Word 2003 all being contained in the same folder as the report to save fiel ... I was trying to figure out why my linked photos quit working when I copy and ...
    (microsoft.public.word.drawing.graphics)
  • Re: Childrens profile report
    ... sub-report, which contains the photographs, is a snaking report giving ... non-sequential photos need to be presented next to each other. ... allow the snaking photos in the KUW section to be interrupted, ...
    (microsoft.public.access.reports)
  • Childrens profile report
    ... sub-report, which contains the photographs, is a snaking report giving ... The heading and explanation need to be full width so can't be included ... allow the snaking photos in the KUW section to be interrupted, ...
    (microsoft.public.access.reports)
  • Re: Childrens profile report
    ... sub-report, which contains the photographs, is a snaking report giving ... allow the snaking photos in the KUW section to be interrupted, ...
    (microsoft.public.access.reports)
  • Re: Report -> Snapshot -> PDF -> Attach To PDF
    ... I can't see why you don't simply add the photos as required to your main ... to the report at some point prior to faxing. ... attachments in a PDF file as additional pages (If not, ...
    (microsoft.public.access.reports)