Results 1 to 4 of 4

Questions about the split forms in the Northwind sample database

  1. #1
    Aaron5714 is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2012
    Posts
    48

    Questions about the split forms in the Northwind sample database


    In the Northwind sample database (available here), I noticed that they are using split forms where it looks like they have pulled the splitter bar all the way up to the top of the form, so that all you can see is the form header with various controls, and then the datasheet portion of the split form. I am trying to implement something similar in my database and had some questions about how they did this:

    1) In the Northwind DB, when you switch to layout view and pull down the splitter bar, somehow it looks like they have removed or hidden the fields that normally display on the top half of the split form. When I try to recreate this type of split form in my database, if I remove the fields from the top of the form they will also be removed from the datasheet portion. This is not really important since the fields are hidden/covered by the datasheet when it is pulled all the way up, but I am just curious as to how they did it.


    2) When I create a split form in my database, there is a small amount of white space above the splitter bar that I cannot seem to get rid of. When I pull the splitter bar up so that it sits right below the form header (this is what they are doing in the Northwind database), this white space overlaps my header. In the Northwind database somehow this white space does not exist above the splitter bar.

    Example of Northwind split form:
    Click image for larger version. 

Name:	Northwind Split Form Example.png 
Views:	10 
Size:	74.2 KB 
ID:	10252

    Example showing splitter bar pulled down:
    Click image for larger version. 

Name:	Northwind Split Form Example2.png 
Views:	8 
Size:	62.1 KB 
ID:	10253

    Example showing splitter bar pulled up over form header. There is no white space between the top of the datasheet and the header:
    Click image for larger version. 

Name:	Northwind Split Form Example3.png 
Views:	8 
Size:	61.9 KB 
ID:	10254

    Example from my database. The white space on top of the splittler bar overlaps my header:
    Click image for larger version. 

Name:	Northwind Split Form Example 4.png 
Views:	8 
Size:	33.7 KB 
ID:	10255

  2. #2
    RuralGuy's Avatar
    RuralGuy is online now Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,894
    Are you sure they are not just using a Form in DataSheet View?
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

  3. #3
    Aaron5714 is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2012
    Posts
    48
    RuarlGuy - yes I'm pretty sure it is a "split form". I don't think it's possible to display a form header when in datasheet view.

  4. #4
    RuralGuy's Avatar
    RuralGuy is online now Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,894
    Well I loaded the NorthWind sample and you are correct. The Order List form is a Split Form. Unfortunately, I do not have an answer for your original question. Sorry.
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

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

Similar Threads

  1. MOdifying forms in split database
    By Ignace in forum Access
    Replies: 1
    Last Post: 05-11-2012, 06:36 AM
  2. sample database
    By TP takamiya in forum Access
    Replies: 4
    Last Post: 10-06-2010, 07:33 PM
  3. Help with Database from Northwind
    By jpl85716 in forum Access
    Replies: 2
    Last Post: 09-24-2010, 08:35 AM
  4. ULS database sample please...
    By genesis in forum Access
    Replies: 1
    Last Post: 07-17-2009, 12:12 PM
  5. Northwind sample database query
    By wasim_sono in forum Programming
    Replies: 5
    Last Post: 02-28-2006, 07:34 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
  •  
Tech Forums: Microsoft Office Forums