Results 1 to 4 of 4
  1. #1
    Bronze Lounger
    Join Date
    Feb 2001
    Location
    Escondido, California, USA
    Posts
    1,458
    Thanks
    0
    Thanked 1 Time in 1 Post
    I'm still fretting with Access 2007 trying to create a form that has a data sheet view. So far every time I try the form displays the first record in the data sheet, but when advancing to the next record the first one scrolls up and out of view. I want the form to display all the records as they are bein entered. In addition I would like to permit the user to enter some information in the header area (it's just there for the printout). So far all I have come up with is the datasheet view, but if I turn form header/footer on the datasheet view disappears and I'm back to one record at a time. Any solution to this? I could swear that back in Access 2000 days I was able to do this with a datasheet subform, but 2007 has me completely puzzled.

  2. #2
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    If you want to be able to use the form header and footer, but also have a list style form, you need to use a Tabular Form.
    This is the Continuous Form option of the Default View Property
    Andrew

  3. #3
    Bronze Lounger
    Join Date
    Feb 2001
    Location
    Escondido, California, USA
    Posts
    1,458
    Thanks
    0
    Thanked 1 Time in 1 Post
    I can select the Datasheet View, but there is no properties option unless I switch to the Design View. But once switched to Design View the Properties list has no View property. I must be missing something big time here.

  4. #4
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    You cannot have a form with header data in datasheet view.
    You could put a datasheet subform on a main unbound form.
    In 2007 you could also look at using a split form.

    If you want to have a form that appears as a tabular list but has a form header and footer then you need to make a tabular form.
    See the images below.

    Tabular Form Wizard

    [attachment=89974:TabularWiz1.jpg]

    In Design

    [attachment=89975:TabFormDes.jpg]

    In Design view set the default view property to continuous form

    [attachment=89976:TabFormProp.jpg]

    This is a data view.

    [attachment=89977:TabFormDat.jpg]
    Attached Images Attached Images
    Andrew

Posting Permissions

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