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

Topic

New Reply

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

Reply | Quote

Replies

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.

Reply | Quote

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

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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

Reply | Quote

>>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.

Reply | Quote