Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Links

Discussion in 'Information Technology' started by Kerry Purdy, Jul 28, 2006.

Tags:
  1. Kerry Purdy

    Kerry Purdy
    Expand Collapse
    Guest

    Hiya

    I am so near - yet so far. I have a bookings database storing, room
    bookings, training course bookings, resource bookings (projector, flipchart
    etc) and catering bookings (pub lunch, buffet lunch etc.).

    Currently I have managed to join together my room and training bookings,
    display them as a cross tab query to show the date as the colum heading, the
    room as the row heading and then the client name or course name as the value.
    The user enters a date range on a switchboard, hits the button - hey presto
    - all is well so far.

    I then had trouble displaying it professionally, cross tab reports made my
    head hurt, a lot! I just don't understand how to set them up. So I went down
    the Excel route instead. I linked my cross tab query to an excel file, thus
    giving me the option to control column width, font size etc. Output to Excel
    didn't let me do this.

    Now what I have done is inserted the linked Excel file into an Access form,
    so now the user enters the date range, hits a button which runs the queries,
    then opens the form with the Linked Object (Excel File) However, it only
    updates the link manually, even though, checking all the properties it is set
    to be automatic. If I can sort this I will be chuffed to bits. I know I am
    probably going the long long way round but I really got stuck on crosstab
    reports and there is no-one else here who knows Access and i couldn't
    understand the demo databases from the forum.

    I haven't a clue how to now add in the Resource and catering requirements to
    this matrix either - any suggestions other than "you are dim" would be
    gratefully appreciated.

    Thanks very much indeed for your time.

    Kerry
     
  2. Loading...

    Similar Threads Forum Date
    India Indian sting busts up $130-million drug and money laundering ring-Links to Canada Breaking News Jan 31, 2013
    News Links to Doctored Video that Framed Professor Darshan Singh Now Exposed (Khalsa News) Punjab, Punjabi, Punjabiyat Dec 17, 2011
    World UN links Iran to nuclear weapons Breaking News Nov 9, 2011
    Learn Punjabi Looking for a Few Good Links to Learn Gurmukhi Language, Arts & Culture Aug 8, 2011
    Emotional Links to Genetic Health: Biological Heaven and Hell Interfaith Dialogues Mar 4, 2011

  3. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    if my memory serves me there's a refresh method for the object

    ie obj.refresh (check the help file)

    Pieter


    "Kerry Purdy" <KerryPurdy@discussions.microsoft.com> wrote in message
    news:EAEF2B2E-1C9E-42C5-B258-72CBFAD61C85@microsoft.com...
    > Hiya
    >
    > I am so near - yet so far. I have a bookings database storing, room
    > bookings, training course bookings, resource bookings (projector,
    > flipchart
    > etc) and catering bookings (pub lunch, buffet lunch etc.).
    >
    > Currently I have managed to join together my room and training bookings,
    > display them as a cross tab query to show the date as the colum heading,
    > the
    > room as the row heading and then the client name or course name as the
    > value.
    > The user enters a date range on a switchboard, hits the button - hey
    > presto
    > - all is well so far.
    >
    > I then had trouble displaying it professionally, cross tab reports made my
    > head hurt, a lot! I just don't understand how to set them up. So I went
    > down
    > the Excel route instead. I linked my cross tab query to an excel file,
    > thus
    > giving me the option to control column width, font size etc. Output to
    > Excel
    > didn't let me do this.
    >
    > Now what I have done is inserted the linked Excel file into an Access
    > form,
    > so now the user enters the date range, hits a button which runs the
    > queries,
    > then opens the form with the Linked Object (Excel File) However, it only
    > updates the link manually, even though, checking all the properties it is
    > set
    > to be automatic. If I can sort this I will be chuffed to bits. I know I
    > am
    > probably going the long long way round but I really got stuck on crosstab
    > reports and there is no-one else here who knows Access and i couldn't
    > understand the demo databases from the forum.
    >
    > I haven't a clue how to now add in the Resource and catering requirements
    > to
    > this matrix either - any suggestions other than "you are dim" would be
    > gratefully appreciated.
    >
    > Thanks very much indeed for your time.
    >
    > Kerry
     

Share This Page