Recent content by woodman650

I am trying this and getting an error "Characters found after the end of SQL statement" SELECT qryClientData.InvoiceID, qryClientData.InvoiceDate FROM qryClientData WHERE qryClientData.ClientName=Forms![frmMain]![lstList] ORDER BY [InvoiceDate];

hmm, arg. still getting an error. How do I reference a listbox on a main form from a sub form? Forms![frmMain]![lstList] Is that right? I am still getting errors.

Yeah, I found some examples... but I don't know how to relate it to a selected value in a listbox. strWhere = "[InvoiceID] = " & Me.ListboxName.[InvoiceID] DoCmd.OpenReport "InvoiceReport", acViewPreview, , strWhere

oh cool. thanks Moniker. is there a way to invert the value in that statement? (make positive numbers negative, etc)? Just a formatting trick would do it I'm sure.

hmm, I've got it all set up properly... but I still get the error. It works fine when the form is open by itself, but as a subform, I get the error.

My code abilities are not the best yet... but I've got this: ="$ " & Sum(tblFinance!Amount WHERE tblFinance.Type="Revenue") It doesn't work. I'm just trying to display all of the revenues from a table in a sum command. Anyone know how I might be able to fix syntax? thanks!

oh, that works perfectly Road Warrior! thanks! One quick question... this works on a standalone form, but what if the form is a SubForm in a parent form called "MainForm"? Right now I get the error "Enter Parameter Value - [Forms]![frmSummary]![ClientName]"

paul, you are quick on the responses tonight... thank you =) Could you elaborate a little bit more on this? I just don't know where to take the code. I have to specify that the report displays the information associated with the ID of the value selected from the listbox... no clue how to turn...

haha, a simple fix! awww, I wish I was better with code. thanks Paul, greatly appreciated!

Hey guys, I was wondering... is there a way to have a listbox display values associated with a parent form ID? in other words... say I have a customer with invoices associated with their name, I want to display a form for that customer with a listbox (or maybe even subform) containing the...

Hey all, Happy Holidays! I just had a question regarding reports... I have a listbox containing ID numbers for invoices... I wondered if there was a way to click on a Listbox entry, hit a command button and have a report template for my invoices open up displaying the data for invoice ID...

it is actually an autonumber field. does that change anything? I put the debug code in but I don't know where it prints the result or how to run the debug procedure.

hmm... doesn't want to work. still having the same problem. nothing happens. I have other values in the listbox with the TransactionID, would that conflict?

Hey all, I'm trying to delete a record in a table by selecting a value in a list box and hitting a command button to delete the associated record. Here is what I am using: Private Sub DeleteMovie_Click() CurrentDb.Execute "Delete from " & _ "tblFinance " & _ "where TransactionID = """ &...

yeah that could work... then I could export from excel to pdf. Maybe I can find something that will handle a direct export to pdf. Anyone know? thanks! ;)