Search results for query: *

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

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

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

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

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

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

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 All, Once again I am stumped. Yes looking for direction. Legacy data and a few customers prevents using an LI for Serial Numbers 1) I would like to create a module or procedure to tell me which serial numbers are missing. This is this origin of the SN List which is passed from Labview via...

Hi All, I have an address list "tblOrgLocate" pk "LOID" (2066 records)that has many duplicate and unused addresses in it. I would like to count the number of times each entry [LOID] has been used in 10 different tables. Once identified I can remove those which have not been used. Table.field...

On a Continuous Style form I filter and arrange to the desired group of records. I next use the following Code to perform a Print Screen from my form via a command button. It works fine but my form has a gray background (Back Color: 12632256). How would I modify the code below to switch the...

I use the following code to open form2 using the AfterUpdate_Event from a text box on a form1. All works well until I return to form1 and clear that same Text box called [ItemsR4SB]. This triggers a MsgBox Syntax Error (missing operator) in query Expression '[ItemId] = ' How can I modify the...

On my form I use a double click procedure on a field [rePo] to open another form that contains the matching value using the code below. Private Sub rePO_DblClick(Cancel As Integer) On Error GoTo Err_rePO_DblClick Dim stDocName As String Dim stLinkCriteria As String stDocName =...

In short I am trying to convert an RFQ to a Purchase Order. The forms involved are: Source Form- frmRFQ Source Subform- frmRFQLines Destination Form- frmPO Destination Subform- frmPOLines The above 4 forms are based on 4 different tables. Both Subforms are based on querys and located on a...

I have several continuous forms which are directories of records in the system, some are based on Query and some based on Tables. The database is A2K mdb, multi user. To reach a particular record you first open the Directory Form then select the line, then click a button which opens the desired...

Originally I used the wizard. It would create a new record with the ID and quQuoteNo only Next I followed MS Article 208824 rev 3 as a guideline to create duplicates of Request for Quotation. My Problem appears to be that the pk quQuoteNo does not increase by 1 and I am unable to figure out...

I would like to be able to select values in Combo1 (year) or Combo3 (month) or both, then display the recordset on frmSuppEvalMonth for analisis. I am using a form called called frmSuppEvalFilter to set the values of Combo1 and Combo3 then click a command button (Command7) there to display...

I have a HyperLink on my form that requires the ability to ignore or adapt to the revision number of the target file name. I do not expect the rev # to ever exceed 99, the "rev" and ".doc" are constant. Link Example on Local Machine: AS9100/Job Description/John Brown rev 2.doc may change in...

I am using the following Code to generate a Graph on a Form. TRANSFORM Sum([AvgScore]) AS [SumOfAvgScore] SELECT (Format([EvalDate],"MMM 'YY")) FROM [tblSuppScores] GROUP BY (Year([EvalDate])*12 + Month([EvalDate])-1),(Format([EvalDate],"MMM 'YY")) PIVOT [scConID]; What must I change to...

Below is a snippet from code I use to select records between a range of dates in a query. Between #6/1/2005# And #9/1/2005# What would I enter to select all records in lets say the last 321 days or 196 days ? Thanks, uncleG

On A Form, who's source is a query, the answer does not need to be saved. I was Trying to make an unbound Text box display one of these 2 Values "On Time" or "Late" based on the value in a third text box. Text46 =Date() 'Todays Date generated by the system. rqDelDueOn = 'A Date Entered into...