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 derfloh 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: *

  1. uncleG

    Does Form Load before underlying Query can Finish or?

    My Thoughts..... That would be...Thank You very much TheAceMan1, it now works like a charm. I was unaware of setting the Recalc and calling it from the load event. Some how I just never needed it before. I had tried resetting the tab orders of the subforms, Requery of the subforms, I had even...
  2. uncleG

    Does Form Load before underlying Query can Finish or?

    Hi PHV, thanks for the interest, Sorry for the confusion, by individual I was implying that the subforms where not 3 levels deep however each is related to a field on the main form as follows. Where I said is bound I was implying to where the data source actually came from. I probably need some...
  3. uncleG

    Does Form Load before underlying Query can Finish or?

    ...tblIsMadeFrom.QtyPer, tblIsMadeFrom.QtyYie, tblIsMadeFrom.Rank, tblIsMadeFrom.ItemNoFk, tblIsMadeFrom.mfID, (([Forms]![frmPurlinesMake2]![Quantity])*1) AS FullQty, ((([FullQty])/([QtyYie]))*1) AS FullQtyRequires, (([Forms]![frmPurlinesMake2]![TheFinQty])*1) AS CompletedParts...
  4. uncleG

    Update Query runs, no warnings, and not passing values.

    Thanks for showing some interest here Duane, I have read your answers here at tek tips and have learned a lot over the years. Query 3 was the result of several days of frustration. Trying this that and the other thing. In essence one query contained the records and the values to update and I...
  5. uncleG

    need tweaking of code open a pdf file

    Hi DougP, Some time ago I set up something that performed a simular function and found trouble in maintaining the links due to adding and changing files. I then was directed to Allan Brownes module "List files to tables" at his site http://allenbrowne.com/ser-59alt.html It was a little work to...
  6. uncleG

    Update Query runs, no warnings, and not passing values.

    ...IIf(([tblBomMaterials].[LN])=([tblBomMaterials].[LN]/1),1,0) AS IsTopLevel, DLookUp("AddForFallout","QryBomMaterialsAddParts") AS AFF, [Qty]*[AFF] AS IncreaseBy FROM tblBomMaterials LEFT JOIN tblItems ON tblBomMaterials.ItemNo = tblItems.ItemID WHERE...
  7. uncleG

    Save Union Query results to table fields

    Got it. Followed the advice found at http://www.fmsinc.com/microsoftaccess/query/non-updateable/index.html In essence the work around was to put my union query into an make table query. Run the make table query, which adds a table to the front end. Next run the update query with my fields from...
  8. uncleG

    Save Union Query results to table fields

    Hi PHV, Thanks for your response. When I tried running this from the query panel, it produced an error. "Operation must use an updateable query". And "The number of columns in the union don't match."I am suspecting I may have to step back behind the union query and run three updates. Any...
  9. uncleG

    Save Union Query results to table fields

    ...or is it me? My Union Query: qryFalloutRates [code] SELECT DISTINCTROW qryProductionYield.ItemNo, Avg(qryProductionYield.SR) AS [Avg MS SR], Count(*) AS MsRuns FROM qryProductionYield GROUP BY qryProductionYield.ItemNo Union All SELECT DISTINCTROW qryProductionYieldAssem.ItemNo...
  10. uncleG

    Find the First Letter at the Right end of a field.

    Thanks Andy, I tested the function out to 4 trailing letters. Now if only I could understand it ;).
  11. uncleG

    Find the First Letter at the Right end of a field.

    Hi Andrzejek, Thanks for your rapid reply, I ran your function against my sample record set and it work with all except the last sample. A2343900AC = A2343900 Rev AC It returned A2343900 Rev C How can I handle it when it ends with double letters at the right as some of our revisions my reach...
  12. uncleG

    Find the First Letter at the Right end of a field.

    I have been using the following public function in my query which both PHV and Golom had shared with me back in 2009. Thread 701-1577313 GetBPName = Split(Split(Split(Split(myfield & "", " ")(0), "_")(0), "-")(0), ".")(0) Function Sample Data Current Result GetBPName(B15722.pdf...
  13. uncleG

    How to Get Left portion of String in Query

    Thanks PHV, You have done it again. For others up against the same type of issue. In my query I had to add and IIf Trim Statement to handle the nulls, empty, zls and or Blanks which were throwing errors. BPNo2: IIf(Trim([BpNo] & "")="","",GetBPName([BpNo])) The above function is much cleaner...
  14. uncleG

    How to Get Left portion of String in Query

    Thanks for the input. Pwise, I replaced tablename with the table name in a new query and it wouldn't run. Also tried the 4 statements independently in the query grid and yeilded multiple results. Golom, I added the Public Function and changed GetName to GetBPName at both locations. This also...
  15. uncleG

    How to Get Left portion of String in Query

    Hi All, I am stumped again Starting from the left I need to locate the first " ", or "_", or "-", or "." Then return all Characters before it. The engineers have promised not to add any more variances. Using Access 2003 Sample Data in [tblItems].[BPNo]: B21821 Outline.pdf...
  16. uncleG

    Get 3 lines for Each SN

    Thanks PHV, I Like them both, now to decide which to use. I have named a command button in my application in your honor. Thanks again, UncleG
  17. uncleG

    Get 3 lines for Each SN

    Hi All The following query returns 11 test lines (records) for 2 SerialNumbers. 6 lines for SerialNumber 1 and 5 lines for SerialNumber 2 My documents will require only 3 lines for each individual SerialNumber First: I would like it to limit the query to return only 3 records for each...
  18. uncleG

    Get the First Long Integer in a Text String

    Thanks Duane, MajP and HarleyQuinn. Seeing 3 versions goes a long way to helping me understand Code, of course it will take me a while to digest the responses. And HarleyQuinn the disappearing Ink, nice touch. Thanks Again, uncleG
  19. uncleG

    Get the First Long Integer in a Text String

    To arrange a list in my Combo Box I use the following in my Query: xyz: IIf([QtyRange] Is Null,0,Val(Mid(([QtyRange]),37,3))) [QtyRange] [xyz] 0 Price Each effective for quantities 1 to 24 pieces 1 Price Each effective for quantities 25 to 49 pieces 25 Price Each effective for...
  20. uncleG

    Find and List the Missing Serial Numbers

    Hi MajP, I will play with the alpha numeric as well later in the week after we settle (hopefully) on a new format. Thanks Again and have a Happy Holiday season, UncleG

Part and Inventory Search

Back
Top