Results 1 to 4 of 4
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Timberville, VA
    Posts
    1,436
    Thanks
    14
    Thanked 0 Times in 0 Posts

    Printing SharePoint 2010 lists

    My current project involves SharePoint 2010 and Access 2007. The project keeps track of our organization's electronic publications and forms. I started by building lists in MS-Excel. Next I converted the data ranges to tables in Excel and imported them into SharePoint 2010 as lists. Then I exported these SharePoint lists into an Access 2007 database.

    The tables in Access are linked to the SharePoint site, so a change made in Access instantly reflects in the SharePoint lists. A colleague had warned of the potential for compatibility problems between Office 2007 and SharePoint, but so far this arrangement has worked pretty much flawlessly.

    I exported the list to Access for one reason: to allow me to print. Queries in Access arrange the data, which I then print as reports. The problem now is that I'm the only person who knows the Access database even exists. My boss periodically asks for printed reports, and I'm the only guy who knows how to give them what they want.

    In my mind's eye, the ideal solution would be to place a "Print" button in the SharePoint dashboard that any user can click to print out a usable report from Access. They don't even need to know that Access is involved. (Whenever I bring up Access, people's eyes start glazing over.)

    Do I need to get acquainted with SharePoint Designer? Any tips or suggestions?

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Administrator
    Join Date
    Mar 2001
    Location
    St Louis, Missouri, USA
    Posts
    20,162
    Thanks
    1
    Thanked 559 Times in 499 Posts

  4. #3
    New Lounger
    Join Date
    May 2012
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts
    "Hey Team,

    Question regarding printing a list item in SharePoint 2010.

    1. There aren't any ""print"" buttons to facilitate printing of a individual list item, what is a solution?

    2. When viewing a list item and forcing a print job of that item is there a way to increase the size of the font
    when printing?

    Any advice or help would be appreciated."

    Regards
    John
    sticker printing

  5. #4
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Timberville, VA
    Posts
    1,436
    Thanks
    14
    Thanked 0 Times in 0 Posts
    The Codeplex Print List Ribbon Button looks very interesting. Unfortunately, I work in an environment where the local geek squad does not trust mere mortals like me to download and install an untested product.

    Might there be a way to build a command into the SharePoint site that would prompt the linked Access database to print a selected report? I know I can place a command button on an Access form that prints a report. Whereas my SharePoint site and the Access database are linked, seems there ought to be a way to do something similar in SharePoint. No doubt such an arrangement would entail using VB or VBA code.
    Last edited by Caesar3; 2012-06-12 at 20:52.

Tags for this Thread

Posting Permissions

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