Search results for query: *

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

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

I have a form with 3 individual sub forms on it using A2003, Split FE/BE. The Main form: frmPurLinesMake2 bound to qryPurlinesMake2 field: qryPurLinesMake2.Quantity field: TheFinQty (=[frmProductionYield2].[Form]![Sum2]) The 3 subs are: frmProductionYield2 is bound to...

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

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

Mission: Pass the calculated values from qryBomMaterialsAddParts2.[IncreaseBy] into tblBomMaterials.AssemblyAdds There can be 0 to 25 or more records involved in the record set to update. Query 2 provides the recordset needed to update. Query 3 should update the table, but does not. Query1...

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

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

Using Access 2003, WinXP Split FE, BE in Multi user enviorment. I am currently trying to save the results of a union query to a table [tblBomMaterials] that shares a field named ItemNo (LI). This info will be used at the time this Requisition is prepared and processed and then replaced with...

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

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

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

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

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

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

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

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

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

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

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