Search results for query: *

Well to be honest I havent had an internet connection until this afternoon when I replied, so I didn't see it... And thank you for your help here and in the other thread I just started :)

I am wondering if its possible to run an update query and add a prefix to the fields being updated? The specific example is when we receive an order and not all of it can fit onto a truck it creates a back order. In the invoice form I have a "Create BackOrder" button that brings the...

Actually this was the finished product: SELECT Customer_ID, CustomerPO, Due, InvoiceDate, IIf(([Due])>=Date(),Remaining,0) AS [0-29Days], IIf(([Due]) <=Date()-1 AND [Due]>=Date()-29,Remaining,0) AS [30-59Days], IIf(([Due]) <=Date()-30 AND [Due]>=Date()-59,Remaining,0) AS [60-89Days]...

Ok I've almost got it figured out, just need some help with the SQL. The problem I was having was that we were basing the due off of the Invoice-Due, when it should have been relevant to todays Date() So here is the code, I just don't know how to have it properly say <=Date()-30 AND...

No this new column displays 30 all the way down, because the default between Invoice sent and payment due is 30 days. Perhaps I wasn't clear, that the query is returning all outstanding values ($ owed) but is placing them all in the 30-59 Column, even when some were entered yesterday and should...

That change just creates a new column which displays the difference between the Invoice Date and Due Date. It does not seem to effect the placement of the values in the age columns.. Thanks for your patience :)

Well you've definitly got a lock on what Im trying to do, I've got the code edited to my tables, and fields, but all of the values are appearing in the 30-59 Column.. What are your thoughts? SELECT Customer_ID, CustomerPO, Due, InvoiceDate, IIf(([Due]-[InvoiceDate])<=29,Remaining,0) AS...

Ok I tried searching through the forums and didn't see what I was looking for, so either Im going about this the wrong way or I didn't look hard enough :) Regardless here is my question.. The end result that I am looking for is to create a report - a general ledger that would show a companies...

Ahh PHV my hero once again. Thank you!

Thats exactly what I don't know how to do. Im not sure what the VB coding should be other than the DoCmd.Filter.. No idea about the rest of it.

Ok I apologize since I know the answer is fairly simple, but all the things I've found searching have been for more complex situations. It's always the easiest parts I struggle with the most... I have a form based on a query of Accounts Receivable. In this form I have added a listbox showing...

That will work. Not exactly what ol boss man was looking for but it gets the job done! Thank you!

AceMan thats exactly what I have been looking for as well. I was just wondering if there is a way to also have an over ride function with this? My boss wants it so that any new customer added has to have ALL of their info added, unless its a one time customer who just wants to make one order...

Because its been a long week and Im an rtard. Thank you very much for your help!

Private Sub Product_ID_AfterUpdate() On Error GoTo Err_Product_ID_AfterUpdate Dim strFilter As String ' Evaluate filter before it's passed to DLookup function. strFilter = "Product_ID = ""Product_ID='" & Me!Product_ID & "'" ' Look up product's unit price and assign it...

Hmmm doesnt work.. The products do contain numbers ie: E8809 So now the error is Syntax error in string in query expression 'Product_ID = "Product_ID='E8809" Sorry I am clueless with VBA Syntax.. trying to learn but its a slow process.

No it is not. They are text. I see where your going with this, but I dont know the solution :( Thanks for your help!

Ok I have a very simple DLookup function that I cannot figure out! I have an order detail subform in my order form and I just want the selected product to update the SalePrice field to the Price in the Product table. I took the code directly out of the Northwinds database and changed the code...

Hi I was wondering if anyone could point me in the right direction in regards to books, websites, texts etc that would be good for learning VBA? I have some understanding of it, and a good understanding of other DB principles, but I don't know VBA very well. I would say I am a high level...

Yes I simply moved the subreport from out of the details section and into the PartID header, formatted it slightly and now its beautiful thank you. I was just curious if there was some code or something I could do that would be like it Material#=X, X or X then multiply by two. But really I...