Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Morecambe England, Lancashire, England
    Posts
    105
    Thanks
    0
    Thanked 0 Times in 0 Posts

    IData entry on a datasheet form (Access 2000/ Windows XP)

    Hi sorry to bother you with a trivial one, but any ideas would be gratefully appreciated.

    I have a tabbed form and one of the tabbed pages is a datasheet view. I have sorted the data in descending date order so that the newest records are at the top of the form and visible and that

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: IData entry on a datasheet form (Access 2000/ Windows XP)

    You could sort the datasheet subform in ascending order, but use code to move to the last record in the On Current event of the main form (if the subform is bound to the main form), or when the tab page is activated.

  3. #3
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: IData entry on a datasheet form (Access 2000/

    You could try having a separate form for entering the new records. Put this above the datasheet form, and set its data entry property to Yes. Make this form just tall enough to show one line of data.

    After you enter each record requery the datasheet form so that the newly entered record appears at the top of it.
    Regards
    John



  4. #4
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Morecambe England, Lancashire, England
    Posts
    105
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: IData entry on a datasheet form (Access 2000/

    Thanks for your help, but you have confirmed what I was certain was the case, that there is no magic option to make data entry move to the top. As far as the client is concerned it was a 'Nice to have' that they would have like, but that was all

    Thanks again
    Michael Peak

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: IData entry on a datasheet form (Access 2000/

    Indeed, there is no 'magic option' to make a new record appear at the top. Whatever the sort order, the new record is always at the end/bottom.

  6. #6
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: IData entry on a datasheet form (Access 2000/

    I thought it was worth having a go at this so I attach a demo of a data entry form with two separate subforms.

    The top one is for data entry, the second one shows the records in descending order. Press tab at the end of the line and the new record appears below and you keep a blank line a the top.

    It might work in some circumstances.
    Regards
    John



Posting Permissions

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