Timetable
Duane,
Thanks for this.
I'll take a look at it.
Regards
Chris
"Duane Hookom" wrote:
It appears your table is un-normalized. This forces you to write two or more
pieces of code that position two or more controls in the detail section of
the report.
--
Duane Hookom
MS Access MVP
"ir26121973" wrote in message
...
Duane,
The field names are as follows:
E- Form Test 1
Test 2
(Form Name) (Date Test Performed) (Date Test
Performed)
So like The dates that I would add in my form against the form name are
the
ones that I would like to be able to plot under the relevant dates on then
report.
Hope this helps
Many thanks
Chris
"Duane Hookom" wrote:
I don't believe you need the DateDiff() function so comment it out. You
can
apply similar code to each date field.
I'm not sure you have ever provided the field names in your report record
source. I fear it might be un-normalized but can't tell for sure.
--
Duane Hookom
MS Access MVP
"ir26121973" wrote in message
...
Duane,
Thanks for geeting back to me again.
I've been looking at what you said, and I understand the principle of
your
coding.
I know in your code you show a start and end date, which I don't have
and
this also has the DateDiff formula attached to it.
I see the various tests that I have as a replacement to the start date,
but
if I only have one date per test per form, can you tell me please would
I
need a different formula to DateDiff and because I have more than one
date
would I need the same line repeated for each test?
Many thanks for taking the time to help me.
Regards
Chris
"Duane Hookom" wrote:
If you aren't concerned about changing the length of the text box, you
won't
need to set the lngDuration or later the
Me.txtName.Width =10
and
Me.txtName.Width = (lngDuration * dblFactor)
The lngStart value will set where horizontally the text box will be
positioned on the time line (left to right).
"have one date as dd mmm yy" isn't important. The format a date is
displayed
makes no difference with what happens in code. A date value is a date
value
is a date value.
--
Duane Hookom
MS Access MVP
"ir26121973" wrote in message
...
Duane,
I've taken a look at the database and I agree with you that it is
the
sort
of report I need but I wondered whether you could help me out with
something.
I'm really new to VB, (you can probably tell), so please bear with
me.
There are 2 lines of code that I'm having a spot of bother with.
lngStart = DateDiff("d", #1/1/2006#, Me.[Start Date])
lngDuration = DateDiff("d", Me.[Start Date], Me.[End Date])
I understand the principal but I'm not sure how to amke the changes
to
fit
what I need.
I know the above code related a tour of duty i.e. between 2 dates.
However
with the database I have I have seperate tasks which are carried out
for
each
form and they only have one date as dd mmm yy.
So I'm not sure whether I need to repeat these lines many times for
each
test and whether I should be using something different to the
DateDiff
element.
Could you perhaps point me in the right direction.
Many thanks
Chris
"ir26121973" wrote:
OK Duane,
I'll have a look at it.
Many thanks once again
Chris
"Duane Hookom" wrote:
Sounds like the crew rotation schedule in the Calendar Report
samples.
--
Duane Hookom
MS Access MVP
"ir26121973" wrote in
message
...
Duane, thanks for hanging in there with me and taking the time
to
read my
posts it is greatly appereciated.
I'm going to try and explain what i would like, hopefully
better
The database is used to collate tests which are carried out on
e-forms
that
I use.
These tests can be carried out on anyday throughout the
financial
year.
Within the database I have use a data entry form where I fill
out
the
description of each e-form along with the dates that these
tests
are
carried
out.
For the ease of explaining I will use e-form 1 and e-form 2 as
an
example,
although there are more. For these forms there is a total of 2
tests,
again
for ease, I'll call these test 1 and test 2.
What I need is a report if you imagine marked out like a grid
with
every
day
in the year going across the top and then the names of the
e-forms
running
down the left hand side.
I would like the dates of the tests that I have entered to be
shown
in the
relevant dates on the report as different coloured blocks, so
e.g.
test 1
will be red and test 2 green.
Does this give you a better idea?
Regards
Chris
"Duane Hookom" wrote:
If you can't adequately describe your desired display then you
might
want
to
find a site that would host an image for free. I google this
and
got
lots
of
hits.
--
Duane Hookom
MS Access MVP
"ir26121973" wrote in
message
...
Duane,
There's no doubt in my mind that your database samples can
point
me in
the
right direction, like you said it just how to apply them to
what i
need. I
do
have a limited knowledge of access, but my experience is
getting
better
as
time goes on.
I've obviously got a file of how I want the report to look
but
haven't
got
a
clue where to post it. Not done this sort of thing before.
Any ideas?
Regards
Chris
"Duane Hookom" wrote:
I'm fairly sure all the information is there in one of the
reports.
You
just
have to understand how to apply it. You want dates across
the
top, my
sample
has dates across the top. You want records to be displayed
under
specific
dates, my sample prints record information under specific
dates.
Can you draw out your desired display in Paint Brush or
Excel
or
whatever
and post it on the web somewhere so we can understand what
you
mean?
--
Duane Hookom
MS Access MVP
"ir26121973" wrote
in
message
...
Duane,
As I said last night, thanks for this.
|