Results 1 to 4 of 4
  1. #1
    Mantaii is offline Novice
    Windows XP Access 2003
    Join Date
    Oct 2011
    Posts
    21

    How to create a custom report from the a form

    Hi!
    I have a feeling this may be the first of many questions when building my new database but I hope you are able to help me.

    I am building a database to allow me to create monthly reports on finishing positions for a road running championship race.



    So far I have managed to create a report which uses queries and data that is input but now I have a problem.

    My report shows me all the data for all of the months but what I would like to do is have a form with a drop down list which allows me to select a month.

    Once I have selected the month I would click on a command button which then shows me a report of all the runners, their finishing positions and times for that specific month.

    Is this possible and are their tutorials online which I can follow to do this first step.

    Thanks

  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,640
    This would be one way:

    http://www.baldyweb.com/wherecondition.htm

    using OpenReport instead of OpenForm.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    Mantaii is offline Novice
    Windows XP Access 2003
    Join Date
    Oct 2011
    Posts
    21
    Hi!
    Thanks for that, I have got the button working but it seems to print rather than just open a report - it does print the correct report though so that's a start!

    Will look in to this but thanks again for the help!

    edit: fixed it,

    DoCmd.OpenReport "official_finish_time", acViewPreview, , "Month_Year = " & Me.cboMonth

    Just added the ,acViewPreview, and this seems to prevent it printing but just allows you to preview the report! Perfect. Now to move on to the next part of the project

    O.

  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,640
    Glad you got it sorted out.
    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. Create a form have 'group' like report
    By namserious in forum Forms
    Replies: 2
    Last Post: 06-28-2011, 02:47 AM
  2. Replies: 1
    Last Post: 06-20-2011, 03:56 PM
  3. Replies: 0
    Last Post: 03-17-2011, 09:57 AM
  4. Replies: 1
    Last Post: 03-02-2009, 11:54 AM
  5. how do I create custom part numbers?
    By Sinatra Fan in forum Database Design
    Replies: 1
    Last Post: 09-01-2006, 04:09 PM

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