A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Timetable



 
 
Thread Tools Display Modes
  #11  
Old September 26th, 2006, 07:14 PM posted to microsoft.public.access.reports
ir26121973
external usenet poster
 
Posts: 13
Default Timetable

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.

I've had a look at this today and it's not quite what I would like.

I'll try and explain a little better.

The report that you pointed me to shows the timeline across the top
but
what
I really need, if possible is for the dates for the relevant
activities
against my categories, (which will be in a query in the background)
to
be
populated under the relevant date in the timeline. Almost as if you
were
filling in cells in excel

I'm not even sure whether there is a way to export this into excel
and
for
that to create a table in Excel?

Hope this helps

Many thanks

Chris

"Duane Hookom" wrote:

Check the Calendar reports at
http://www.access.hookom.net/Samples.htm.

--
Duane Hookom
MS Access MVP

"ir26121973" wrote in
message
...
Hi,

I don't even know whether this can be done, but I wonder if
someone
can
help
please.

I have the following information in an access query:

Date Started Date Tested
Date
Finished
Test 14/08/06 30/09/06
31/12/06
Live 01/01/06 31/10/06
31/01/07

I would like this to be able to be shown as a timetable, if you
can
imagine
looking like a hotel reservation screen, where there is a
timeline
across
the
top and blocks of colour to highlight the paticular dates for the
two
categories.

Can anyone help please. I'm not sure whether this may even be
better
in
Excel.

Many thanks

Chris












  #12  
Old September 26th, 2006, 09:55 PM posted to microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 2,251
Default Timetable

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.

I've had a look at this today and it's not quite what I would
like.

I'll try and explain a little better.

The report that you pointed me to shows the timeline across the
top
but
what
I really need, if possible is for the dates for the relevant
activities
against my categories, (which will be in a query in the
background)
to
be
populated under the relevant date in the timeline. Almost as if
you
were
filling in cells in excel

I'm not even sure whether there is a way to export this into
excel
and
for
that to create a table in Excel?

Hope this helps

Many thanks

Chris

"Duane Hookom" wrote:

Check the Calendar reports at
http://www.access.hookom.net/Samples.htm.

--
Duane Hookom
MS Access MVP

"ir26121973" wrote in
message
...
Hi,

I don't even know whether this can be done, but I wonder if
someone
can
help
please.

I have the following information in an access query:

Date Started Date Tested
Date
Finished
Test 14/08/06 30/09/06
31/12/06
Live 01/01/06 31/10/06
31/01/07

I would like this to be able to be shown as a timetable, if
you
can
imagine
looking like a hotel reservation screen, where there is a
timeline
across
the
top and blocks of colour to highlight the paticular dates
for the
two
categories.

Can anyone help please. I'm not sure whether this may even
be
better
in
Excel.

Many thanks

Chris














  #13  
Old September 29th, 2006, 06:45 PM posted to microsoft.public.access.reports
ir26121973
external usenet poster
 
Posts: 13
Default Timetable

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.

I've had a look at this today and it's not quite what I would
like.

I'll try and explain a little better.

The report that you pointed me to shows the timeline across the
top
but
what
I really need, if possible is for the dates for the relevant
activities
against my categories, (which will be in a query in the
background)
to
be
populated under the relevant date in the timeline. Almost as if
you
were
filling in cells in excel

I'm not even sure whether there is a way to export this into
excel
and
for
that to create a table in Excel?

Hope this helps

Many thanks

Chris

"Duane Hookom" wrote:

Check the Calendar reports at
http://www.access.hookom.net/Samples.htm.

--
Duane Hookom
MS Access MVP

"ir26121973" wrote in
message
...
Hi,

I don't even know whether this can be done, but I wonder if
someone
can
help
please.

I have the following information in an access query:

Date Started Date Tested
Date
Finished
Test 14/08/06 30/09/06
31/12/06
Live 01/01/06 31/10/06
31/01/07

I would like this to be able to be shown as a timetable, if
you
can
imagine
looking like a hotel reservation screen, where there is a
timeline
across
the
top and blocks of colour to highlight the paticular dates
for the
two
categories.

Can anyone help please. I'm not sure whether this may even
be
better
in
Excel.

Many thanks

Chris















  #14  
Old September 29th, 2006, 07:14 PM posted to microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 2,251
Default Timetable

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.

I've had a look at this today and it's not quite what I
would
like.

I'll try and explain a little better.

The report that you pointed me to shows the timeline across
the
top
but
what
I really need, if possible is for the dates for the relevant
activities
against my categories, (which will be in a query in the
background)
to
be
populated under the relevant date in the timeline. Almost as
if
you
were
filling in cells in excel

I'm not even sure whether there is a way to export this into
excel
and
for
that to create a table in Excel?

Hope this helps

Many thanks

Chris

"Duane Hookom" wrote:

Check the Calendar reports at
http://www.access.hookom.net/Samples.htm.

--
Duane Hookom
MS Access MVP

"ir26121973" wrote
in
message
...
Hi,

I don't even know whether this can be done, but I wonder
if
someone
can
help
please.

I have the following information in an access query:

Date Started Date Tested
Date
Finished
Test 14/08/06 30/09/06
31/12/06
Live 01/01/06 31/10/06
31/01/07

I would like this to be able to be shown as a timetable,
if
you
can
imagine
looking like a hotel reservation screen, where there is a
timeline
across
the
top and blocks of colour to highlight the paticular dates
for the
two
categories.

Can anyone help please. I'm not sure whether this may
even
be
better
in
Excel.

Many thanks

Chris

















  #15  
Old September 29th, 2006, 07:57 PM posted to microsoft.public.access.reports
ir26121973
external usenet poster
 
Posts: 13
Default Timetable

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.

I've had a look at this today and it's not quite what I
would
like.

I'll try and explain a little better.

The report that you pointed me to shows the timeline across
the
top
but
what
I really need, if possible is for the dates for the relevant
activities
against my categories, (which will be in a query in the
background)
to
be
populated under the relevant date in the timeline. Almost as
if
you
were
filling in cells in excel

I'm not even sure whether there is a way to export this into
excel
and
for
that to create a table in Excel?

Hope this helps

Many thanks

Chris

"Duane Hookom" wrote:

Check the Calendar reports at
http://www.access.hookom.net/Samples.htm.

--
Duane Hookom
MS Access MVP

"ir26121973" wrote
in
message
...
Hi,

I don't even know whether this can be done, but I wonder
if
someone
can
help
please.

  #16  
Old September 29th, 2006, 08:01 PM posted to microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 2,251
Default Timetable

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.

I've had a look at this today and it's not quite what I
would
like.

I'll try and explain a little better.

The report that you pointed me to shows the timeline
across
the
top
but
what
I really need, if possible is for the dates for the
relevant
activities
against my categories, (which will be in a query in the
background)
to
be
populated under the relevant date in the timeline. Almost
as
if
you
were
filling in cells in excel

I'm not even sure whether there is a way to export this
into
excel
and
for
that to create a table in Excel?

Hope this helps

Many thanks

Chris

"Duane Hookom" wrote:

Check the Calendar reports at
http://www.access.hookom.net/Samples.htm.

--
Duane Hookom
MS Access MVP

"ir26121973"
wrote
in
message
...
Hi,

I don't even know whether this can be done, but I
wonder
if
someone
can
help
please.



  #17  
Old September 29th, 2006, 08:33 PM posted to microsoft.public.access.reports
ir26121973
external usenet poster
 
Posts: 13
Default 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.

  #18  
Old October 1st, 2006, 05:10 PM posted to microsoft.public.access.reports
ir26121973
external usenet poster
 
Posts: 13
Default Timetable

Duane,

I really didn't want to have to bother you again, but I really am stuck on
this.

You may have see that I ave even posted on access monster just so I didn't
bother you, but you really do seem to be the expert on these
calendar/timetable reports.

I've been looking at your ship rotation report, and I've taken it apart to
try and understand how it works.

I think the problem is that I don't have a start and finish date, just a one
off date per test. so in essence 1, 2, or 3 dates on tests that I've carried
out on each of my e-forms.

I have tried and managed to change the timeline on the report to weekly so I
understand that, but the coloured text boxes don't seem to move or should I
say plot themselves under the correct date and the boxes are so small in size
that I can't see the dates in them.

Other than not having a whole amount of experience in access, am I missing
something?

Thanks very much for taking the time to read this.

Kind regards

Chris



"ir26121973" wrote:

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?

  #19  
Old October 2nd, 2006, 01:50 AM posted to microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 2,251
Default Timetable

Can you provide your report's record source field like:

ID primary key
FieldName1 Datatype
FieldName2 Datatype (use this field to position horizontally)
FieldName3 Datatype (display this one on time line)
FieldName4 Datatype (display this one on time line)
FieldName5 Datatype (use this field to position horizontally)


Can we assume the names of the controls are the same as the fields? If not,
provide the control names and sources.

We also need to know what value starts your scale on the left and how the
scale is determined (6" = 2 weeks or whatever)
--
Duane Hookom
MS Access MVP

"ir26121973" wrote in message
...
Duane,

I really didn't want to have to bother you again, but I really am stuck on
this.

You may have see that I ave even posted on access monster just so I didn't
bother you, but you really do seem to be the expert on these
calendar/timetable reports.

I've been looking at your ship rotation report, and I've taken it apart to
try and understand how it works.

I think the problem is that I don't have a start and finish date, just a
one
off date per test. so in essence 1, 2, or 3 dates on tests that I've
carried
out on each of my e-forms.

I have tried and managed to change the timeline on the report to weekly so
I
understand that, but the coloured text boxes don't seem to move or should
I
say plot themselves under the correct date and the boxes are so small in
size
that I can't see the dates in them.

Other than not having a whole amount of experience in access, am I missing
something?

Thanks very much for taking the time to read this.

Kind regards

Chris



"ir26121973" wrote:

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?



  #20  
Old October 2nd, 2006, 09:12 PM posted to microsoft.public.access.reports
hobbit2612 via AccessMonster.com
external usenet poster
 
Posts: 107
Default Timetable

Duane,

Thanks for getting back to me. I really do appreciate it.

My fields are as follows:

E-Form ID (Primary Key)
Form Number
Form (This is the description of the E-Form)
Test 1
Test 2
Test 3
Test 4
Test 5
Test 6
Test 7

All test fields are date/time formats.

I can confirm that the names of the controls are exactly the same as the
fields which, incidentally are all text boxes.

I've tried and like I said I feel I cracked it in getting the months in the
timline to run from April and to continue for 12 months. With regards to the
actual scale I would like, if possible for this to be weekly, would that be
ok?

Once again Duane, many thanks for helping me.

Kind regards

Chris

Duane Hookom wrote:
Can you provide your report's record source field like:

ID primary key
FieldName1 Datatype
FieldName2 Datatype (use this field to position horizontally)
FieldName3 Datatype (display this one on time line)
FieldName4 Datatype (display this one on time line)
FieldName5 Datatype (use this field to position horizontally)

Can we assume the names of the controls are the same as the fields? If not,
provide the control names and sources.

We also need to know what value starts your scale on the left and how the
scale is determined (6" = 2 weeks or whatever)
Duane,

[quoted text clipped - 328 lines]
you
mean?


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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:19 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.