Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: BJNK
  • Order by date
  1. BJNK

    Changing Values On Crosstab Columns (Dates)

    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 :)
  2. BJNK

    Update Query - Add a prefix?

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

    Changing Values On Crosstab Columns (Dates)

    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]...
  4. BJNK

    Changing Values On Crosstab Columns (Dates)

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

    Changing Values On Crosstab Columns (Dates)

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

    Changing Values On Crosstab Columns (Dates)

    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 :)
  7. BJNK

    Changing Values On Crosstab Columns (Dates)

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

    Changing Values On Crosstab Columns (Dates)

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

    Listbox to Filter Form

    Ahh PHV my hero once again. Thank you!
  10. BJNK

    Listbox to Filter Form

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

    Listbox to Filter Form

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

    Required Property

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

    Required Property

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

    DLookup You Cancelled Previous Operation

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

    DLookup You Cancelled Previous Operation

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

    DLookup You Cancelled Previous Operation

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

    DLookup You Cancelled Previous Operation

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

    DLookup You Cancelled Previous Operation

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

    Getting started with VBA?

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

    Subreport Repeating Values

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

Part and Inventory Search

Back
Top