Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.
Hi all, please see this major site announcement: https://www.boards.ie/discussion/2058427594/boards-ie-2026

Microsoft Access

  • 26-08-2008 11:51AM
    #1
    paconnors
    Registered Users, Registered Users 2 Posts: 1,648 ✭✭✭


    Hi Can anybody help me

    I Have an access database for a club membership can i print out a certain record like an invoice, say select such a member and press a button and it previews an invoice or a receipt so you can print


Comments

  • #2
    kayos
    Registered Users, Registered Users 2 Posts: 2,494 ✭✭✭kayos


    Seeing as you have given sod all detail in your question I'll give you the short answer.

    Yes.


  • #3
    Thomas_S_Hunterson
    Closed Accounts Posts: 6,151 ✭✭✭Thomas_S_Hunterson


    You'll need a Form, a Report, a Query and a small bit of VB and SQL.

    /edit: If memory serves me correctly, you might not even need to use SQL


  • #4
    paconnors
    Registered Users, Registered Users 2 Posts: 1,648 ✭✭✭paconnors


    Say i Have Joe Blogs record infront of me, can i make a button on the form that will convert the current form into a Report Preview with that current record that i was working on. so i can print a receipt


  • #5
    Thomas_S_Hunterson
    Closed Accounts Posts: 6,151 ✭✭✭Thomas_S_Hunterson


    paconnors wrote: »
    Say i Have Joe Blogs record infront of me, can i make a button on the form that will convert the current form into a Report Preview with that current record that i was working on. so i can print a receipt

    Ok you need a report which pulls the information from a query which in turn pulls it's information from the database, using the current record in the form as a filter.

    Then just have a button on the form to bring up the report.


Advertisement
Advertisement