Results 1 to 4 of 4
  1. #1
    nchesebro's Avatar
    nchesebro is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2010
    Posts
    108

    Tabbed Form & Printing...

    Hello,

    I am currently working on revamping a database for a small University. The database is used to schedule campus tours for interested prospects. Some of the information is collected by student workers, and later, other information is added by regular office staff...



    So...

    I have decided that it would be best to create a form with two tabs, one for student use, and the other for office staff use.

    What seems like a simple endeavor becomes an entirely different beast when presented with the scenario that when the students arrive to the admissions office, information entered into the form on BOTH tabs need to be printed out on ONE sheet of paper.

    The current database uses a single form with all fields present on one sheet, and the reason for going with a tabulated interface would be to prevent students from filling out information that office staff must complete. Therefore when it is printed, the printer spits out the completed record on one sheet, and we would like to maintain that for puroposes of simplicity...

    Any help would be appreciated!

    -Nate

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,137
    It is generally problematic to try and print a form. You have a lot more control over a report, so most of us would suggest creating a report and printing that. A tab control is obviously not conducive to printing, as you can't select a tab on a printed page.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    nchesebro's Avatar
    nchesebro is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2010
    Posts
    108
    That is what I was afraid of...

    The most important rule that I am bound to is "simple simple simple!!!"

    While it would be better to run the report, that entails more work for office staff who may not know how that is done...

    I think the best option now is to create a simple form, with it split with student inputting on one half, and office inputting on the other...

    I have more questions on the same database, but I think what I am about to ask is more related to the programming side, so I am going to make a new post...

    -Nate

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,137
    The users shouldn't need to know. You create a report, perhaps with parameters, and fire it off from a button. All the user has to do is click the button.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. tabbed form with subtabs
    By MWMike in forum Forms
    Replies: 1
    Last Post: 12-10-2010, 11:27 PM
  2. 2007 forms with tabbed interface option
    By Syswizard in forum Forms
    Replies: 4
    Last Post: 12-06-2010, 12:31 PM
  3. tabbed forms .. QUICK question!
    By kroenc17 in forum Forms
    Replies: 2
    Last Post: 12-01-2010, 08:38 AM
  4. Tabbed Sub Form
    By Vikki in forum Access
    Replies: 1
    Last Post: 02-10-2010, 10:30 AM
  5. Problems with list or combo box on tabbed form
    By kydbmaster in forum Forms
    Replies: 0
    Last Post: 02-20-2008, 01:33 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