Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Mar 2001
    Location
    Eastern Pennsylvania, Pennsylvania, USA
    Posts
    97
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Assignment Report (97sr2)

    Hello all....I am building a report with a monthly calendar type layout. (Sundays through Saturdays, left to right) I have 31 textboxes I am populating from a select query. In the section detail OnFormat I have code picking a date field apart and dropping the data in the textbox corresponding to the calendar. The problem is that each record is being loaded as a single page. I have to scroll to the last page for all of the textboxes to be loaded. I have tried repainting in the loop, to no avail. If anyone has ideas for a solution, or a better way to do this, your help will be greatly appreciated.....Thank you, Dave P.

  2. #2
    New Lounger
    Join Date
    Oct 2002
    Location
    Perth, Western Australia, Australia
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Assignment Report (97sr2)

    If you go to the Utteraccess.com website there is a leave calendar that I created a couple of days ago. If you search by user name vicki_b you will see the post regarding the calendar there. Unfortunately I can't upload it to here as it is slightly to big even when zipped! It may have some functionality that you are looking for if there are any question as to how or why I have done some thing please feel free to ask.

    Cheers

    Vicki

  3. #3
    Star Lounger
    Join Date
    Mar 2001
    Location
    Eastern Pennsylvania, Pennsylvania, USA
    Posts
    97
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Assignment Report (97sr2)

    Vicki, I could not find the post you are referring to, nor where to search by user name. Could you point me in the right direction?? Thanks, Dave P.

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Assignment Report (97sr2)

    It sounds like you are binding the data source to the report, which would likely cause the behavior you are seeing. I think the approach of using an unbound report, and then with the OnFormat event, opening a recordset, stepping through it, and populating each of the text boxes would give you a better result. That may well be the solution Vicki proposes (BTW, I can't find her post either), but in order to know for certain the best approach, we would need details on the table structures involved.
    Wendell

  5. #5
    New Lounger
    Join Date
    Oct 2002
    Location
    Perth, Western Australia, Australia
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Assignment Report (97sr2)

    <P ID="edit" class=small>(Edited by charlotte on 21-Nov-02 21:54. to activate link)</P>Hey dave,

    Try the following link.
    http://www.utteraccess.com/forums/showflat...true#Post128021

    Hopefully if you cut this and put it in your browser it will take you to the right page.

    If thhis doesn't work then under the UA banner there is a menu where one of the options is search. Click on this the put vicki_b in the "words to search for" field then change the "search options" field to by username it will then bring you up all the posts that I have made click on any of the posts titled "Leave callendar - almost" and you will find the file as an attachment.

    Hope this helps

    Cheers

    Vicki.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •