Results 1 to 3 of 3
  1. #1
    slimjen is offline Expert
    Windows XP Access 2007
    Join Date
    Mar 2010
    Posts
    727

    header and footer


    all; using access 2003. I want to display a subform like a datasheet view without using datasheet view. I have invoice numbers that can have many tracking records. My purpose is i need to display a total for the total amount of each records per invoice number. I inserted to view header and footer. I was trying to put just the lables of the controls in the header of the subform and leave the control in the detail section of the subform but it wouldn't let me. Can someone tell me how to do this or arrange my controls and labels so that they appear like a datasheet.
    Thanks

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,931
    Try Continuous View.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    slimjen is offline Expert
    Windows XP Access 2007
    Join Date
    Mar 2010
    Posts
    727
    Great. This worked.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 08-31-2011, 02:34 PM
  2. Replies: 3
    Last Post: 01-13-2011, 03:53 AM
  3. Footer Totals
    By allenjasonbrown@gmail.com in forum Reports
    Replies: 3
    Last Post: 09-30-2010, 09:40 AM
  4. Page Footer
    By jamil_kwi in forum Access
    Replies: 1
    Last Post: 05-31-2010, 04:02 AM
  5. Page Footer Top
    By RHall in forum Reports
    Replies: 3
    Last Post: 12-15-2005, 09:35 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums