Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Canada
    Posts
    284
    Thanks
    0
    Thanked 0 Times in 0 Posts

    WON'T PRINT INVOICE WITHOUT A PAYMENT (Access 2000)

    I have a Student Fee program that records school fees for each Student. I have a Student table and an Invoice table that just shows the invoice #, Student ID#, and date of the invoice, then there is an InvoiceDetails table that shows each line of the invoice (invoice #, type of fee (e.g. elementary, Jr high, etc.), and the amount of the fee). All these tables are linked to the Student table. Then I have a Payment table that has a payment # automatically assigned, Student ID#, date of payment, payment amount, cheque #, Notes, and check boxes for whether its a cheque or cash. This table is linked to the Student table.

    The problem is that when I go to add an invoice, which is a button "Enter Invoice" on the Student form, I can't print it. When I click on the "Print Invoice" button, it shows a blank invoice. But when I enter in a payment, and go back to the invoice screen to print the invoice, it shows the invoice (in preview). On the invoice I have a "Total Invoice" then a "Total Payments", and an "Amount Due". Could that be where I'm going wrong? Could it be something to do with the total payments? Does it need a payment amount to print?

    Jen

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: WON'T PRINT INVOICE WITHOUT A PAYMENT (Access 2000)

    My guess is the recordsource for your invoice printing is a query that joins the invoice table and the payment table. Therefore, if there is no record in the payment table, the invoice isn't in the query results.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Canada
    Posts
    284
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: WON'T PRINT INVOICE WITHOUT A PAYMENT (Access 2000)

    So how do I remedy this? How can I show the payments on the invoice without joining them?

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Canada
    Posts
    284
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: WON'T PRINT INVOICE WITHOUT A PAYMENT (Access 2000)

    I fixed it! But now another screen that I have is probably having the same problem. I have a summary screen on the main Student screen that shows the invoice total and the total payments, but it is not showing up. I just entered an invoice. How do I get it to show up without a payment? I used a query that pulled in the Student table, a Total Invoice Query, and a Total Payments Query. I tried adjusting the Join properties but that didn't seem to work. Do you have any idea what I might be doing wrong?

    ---------

    Okay, I fixed some of it. I now get the lines to show up on the Account Info Query whether there is a payment or not. But I still can't get it to show up on the Student form. I noticed when I open the Account Info Query, it won't put in the StudID. It will only put in the first one, and then it leaves it blank for every record after that. Do you know why this is? (I'll keep playing with it--if I figure it out before you do, I'll let you know). Thanks.

    ----------

    I can't believe this! I ACTUALLY FIGURED IT OUT ON MY OWN!!! YIPEEEEEEE!!! Well, thanks for listening to my complaints and questions anyway, Mark.

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Canada
    Posts
    284
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: WON'T PRINT INVOICE WITHOUT A PAYMENT (Access 2000)

    Okay...How about another printing problem? I go to enter a payment on the Payment form, and when I press the "Print Receipt" button it comes out with a blank receipt. You have to click on the next record arrow to go to the next record, then go back to the previous record (the payment you just entered), then when you press "Print Receipt" it shows up. How do I get it to print out the receipt without having to do all that?

    Also, when I press on "Enter Payment" from the main Student screen, it goes to the first record. How do I make it so that when I click on "Enter Payment" it goes to a blank record?

    Appreciate any help.

  6. #6
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: WON'T PRINT INVOICE WITHOUT A PAYMENT (Access 2000)

    >>So how do I remedy this? How can I show the payments on the invoice without joining them?<<

    Just create a subreport based solely on payments, just like you would create a subform on a form. The Master/Child link will be studentID.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  7. #7
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: WON'T PRINT INVOICE WITHOUT A PAYMENT (Access 2000)

    Jennifer,

    In the code to print the report, insert :

    RunCommand acCmdSaveRecord

    before the DoCmd.OpenReport
    This will save the record witch is what you are doing by moving to the next record and come back.

    For opening the form:
    Docmd.OpenForm "YourForm",,,, acFormAdd
    will bring you a blank form to insert a new record

    Francois
    Francois

Posting Permissions

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