1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Access 2007: Creating a Button to allow user to export report to Excel

Discussion in 'Business Applications' started by Pyrofeline, Feb 6, 2015.

Thread Status:
Not open for further replies.
  1. Pyrofeline

    Pyrofeline Thread Starter

    Joined:
    Jan 22, 2015
    Messages:
    9
    I have several reports from a database that I have built for my boss to see different views of work progress. She currently copies and pastes to put them in Excel.

    I'd like to provide her with a button she can click to Export everything to Excel for her. She is not the most tech-savvy, so showing her how to do it within Access is not a feasible option (she'd just ask me to show her every time she needed to do it).

    Thanks in advance!
     
  2. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    In Form design Mode the Form "Button Wizard" will create the button for you.
    The fourth item on the "button sub menu" is Report Operations and on the right hand side the last option is Send Report to File.
    You then select the report that you want and then "Output to MS Exel"
     
  3. Pyrofeline

    Pyrofeline Thread Starter

    Joined:
    Jan 22, 2015
    Messages:
    9
    Thank you! For some reason I was missing that option! :)
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1142585

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice