Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2013
    Posts
    72

    Unanswered: Print REPORT based on the sales form

    Hi

    Sorry not quite familiar with access.
    I got a SALES FORM and like a PRINT button
    that prints a report/receipt.

    I kind of prepared the receipt but it only shows the very first record.
    How can I make it so, it shows/prints the current sale (or which one I chose to be)

    there must be some type of filtering
    but not sure where or how to do so ....


    Pls give me some advise


    Many Thanks


  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    set a filter as part of the code that runs when you click the print button
    look at your current form design
    look at the properties for the button that opens your report, then look at the code behind the button
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Apr 2013
    Posts
    72
    This is what I see:

    OpenReport: Print, Print Preview, , , Normal

    that is not even in VBA.
    I think if you chose the button wizard, it does different way.

    Now, I woulnt know any further on how to specify/filters
    for the SalesID (since each sale has its own ID)

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Openreport is a vba macro
    The commas delimit parametrs
    Look up the open report macro in the help and set an appropriate filter


    Say you want to to print the salesid of 123, then the filter is `salesid = 123`
    If you wanted to report logons for user bucki, then because its an alphanumeric value you must delimit thevalue so the filter is `userid = "bucki"`
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Apr 2013
    Posts
    72
    Heal

    I am just shocked of myself to how on earth I forgot all this.
    Seriously, I was the best in DB while back ago, when I did HigherEduction (HE)
    covered silly SQL, created DB, linked them up, queries and reports etc.

    I just hate myself to have forgotten all of this ... what is going with my brain lol

    --

    Anyway, my first report was basically drag and drop the fields from the tables.
    that didnt work quite how I wanted .... instead now created a query with the data
    and in the SalesID I specified [Forms]![Sales Order]![SalesID]

    and booooommmm it works like a modafoka lol :P
    I need my young age back lol

Posting Permissions

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