> 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" <ir26121973[ at ]discussions.microsoft.com> wrote in message
>> news:2AF1C473-EEAD-44AC-9169-05362739DEAE[ at ]microsoft.com...
>> > 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" <ir26121973[ at ]discussions.microsoft.com> wrote in message
>> >> > news:A88AEFA3-DFAE-4E46-9A77-6ACBD7ED4FE0[ at ]microsoft.com...
>> >> > > 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" <ir26121973[ at ]discussions.microsoft.com> wrote in
>> >> > >> message
>> >> > >> news:0B8C7600-AF11-41A5-8C54-24FB3763E311[ at ]microsoft.com...
>> >> > >> > 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" <ir26121973[ at ]discussions.microsoft.com> wrote in
>> >> > >> >> message
>> >> > >> >> news:97AB6250-B78D-4F37-B3C3-2F36DDDB5013[ at ]microsoft.com...
>> >> > >> >> > 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" <ir26121973[ at ]discussions.microsoft.com> wrote
>> >> > >> >> >> in
>> >> > >> >> >> message
>> >> > >> >> >> news:02B2A879-E3F9-41A0-80A5-5DC34CC9787E[ at ]microsoft.com...
>> >> > >> >> >> > 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
>> >> > >> >> >>
>> >> > >> >> >>
>> >> > >> >> >>
>> >> > >> >>
>> >> > >> >>
>> >> > >> >>
>> >> > >>
>> >> > >>
>> >> > >>
>> >> >
>> >> >
>> >> >
>>
>>
>>