Replies

So you’re saying that I should go into properties of the field on my “Invoice” form and change “Name” to something else that is different from the “Control Source”?

Jen

Well, I got past that problem, but then I got a run-time error on the [txtInvID]. What does that whole line mean anyway?

.Filter = “[InvID]=” & [InvID] & “”

That is the big problem I have with Access. I never really know what each line (or property) does.

Jennifer

Okay, Charlotte. Call me a complete untechnical weenie, but I don’t understand “techie” lingo. What is “IDE” and what is the project explorer? Sorry.

Jennifer

I still can’t get it to work. It still gives me a compile error. When it does that it hightlights the first and the fifth line. Here’s the code I have:

Private Sub cmdPrint_Click()
‘dim an object variable as an
‘instance of the report class object
‘named “Invoice”
Dim rpt As Report_SingleRecord
‘open an instance of the report class object
‘this isn’t visible at this point
Set rpt = New Report_SingleRecord

With rpt
‘Set the report fileter to the value
‘of the current record on this form
.Filter = “[InvID]=” & [txtInvID] & “”
‘turn the filter on
.FilterOn = True
‘make the report visible
.Visible = True
End With
‘destroy the object variable
Set rpt = Nothing

End Sub

Thanks.

Jennifer

I’m trying to print off a single invoice, too. I used your code, but I keep getting: Compile Error–user-defined type not defined. What does this mean? Here’s my code:

Private Sub cmdPrint_Click()
‘dim an object variable as an
‘instance of the report class object
‘named “Invoice”
Dim rpt As Report_SingleRecord
‘open an instance of the report class object
‘this isn’t visible at this point
Set rpt = New Report_SingleRecord

With rpt
‘Set the report fileter to the value
‘of the current record on this form
.Filter = “[InvID]=” & [txtInvID] & “”
‘turn the filter on
.FilterOn = True
‘make the report visible
.Visible = True
End With
‘destroy the object variable
Set rpt = Nothing

End Sub

Also…how would you make it so you could preview it before you print it? Thanks for your help.

Jennifer

Okay…I’ll explain what’s going on. I have a student form that shows the student’s name, parents, address. On that form I have a button that opens an Invoices form. On that form I have a button that opens a Payments form, and a button that opens a Withdrew form. Now…

I made a button that opens an Account form. That form I made from a query that queries all the tables together. When you look at what info the query pulls, it shows each line of the invoice with the SAME $30 payment next to it. I want the program to tell that there was only one payment and not list it on each line of the query. How do I do that? Am I missing a step?

I hope you can tell what I’m trying to explain. I don’t really have any code to show you because it is the query where I think the problem is.

Jennifer

So I would enter under criteria in the query design for InvID “=forms!frmInvoices!InvID”? Is that right? I’m a little confused.

Jennifer

Thanks, Brian!

Now I get a syntax error in this line:

stLinkCriteria = “[InvID]=” & Forms!Invoices Subform!InvID

What did I do wrong? This is really driving me crazy!

…okay, now I don’t get the syntax error, but now it can’t find the form “Invoices_Subform”. But I DO have a form called “Invoices Subform”(I noticed that it syntaxed because I had no “_” in there). Why can’t it find my subform?

…okay. I fiddled with it some more. Now I actually got it to print my one invoice! Yeh, I’m doing the happy dance! But now, how do I get it just to print instead of preview it first?

Jennifer

Mark, I am having trouble printing a single invoice. I tried this “CurrentRecord”, but I don’t get any data to print out. All I get is my report with no records. And when I tried it without using CurrentRecord I get my records printed, but they ALL print. I only want the record that I’m working on to print.

I am creating an invoicing program for Student’s School Fees. I have the student on the form, and the invoice number is in a subform and the invoice detail is on another subform on the Student form. I want a “Print Invoice” button on the Student form to print out the invoice for that student, but I just can’t seem to get it to work. I made up a Query that pulls all the data that I need on my invoice in to one datasheet, but it lists all the invoices. How can I get just one? I hope you can help.

Jennifer

I found something about using a “CurrentRecord” phrase in the coding, but it doesn’t really show enough info for me to really know how to use it properly. Have you used this?

Jennifer

Okay, I tried this again, Rupert. I can get it to print the invoices, but now I get a box asking for a Parameter value. What is that? And it still prints out all invoices. Aaaarrrggghhh!!!

I tried it and it gave me a message that it couldn’t find my “frm_Student”, so I changed it to just “Student” because that is what it is called under my forms tab. Then it gave me the same message as before that it couldn’t find InvID.

Jennifer

Ummmmmm….I tried it, but it didn’t work. It said that it can’t find InvID. I have that on my form, but InvID is actually on the form in a subform. Does that make any difference?

Jennifer

Where do I enter that code you gave me? I told you I’m pretty when it comes to VBA.

Jennifer