For some reason I am getting the "item not found in collection" error when I execute this code. It pertains to my line:
Code:
If rstSPC.[Ni_Au_Nickel_Thickness_Avg] > SPCAve + 2 * SPCSigma Then
grgimpy
Last Activity: Nov 1 '07, 04:04 PM
Joined: Nov 15 '06
Location:
-
Item not found in collection error
This code is supposed to take the last three records entered into the query "Ni-Au-CooperSubformQu ery" and place them in the table MyTable. After placing the three records in the table it should analyze them.
For some reason I am getting the "item not found in collection" error when I execute this code. It pertains to my line:
... -
MS Access VB text box glitch
My form has two main text boxes that are not working correctly with the code I wrote. Upon opening the form, the operator must select a "Part Number" from a list box. Once a "Part Number" is selected, some code fills in some parameters in other text boxes and brings up a subform based on a query. This all works fine. The operator must then enter in eight "Thickness" values. Once the last value is entered, three... -
MS Access Pivotchart code
I have a pivotchart in a tab in my main form. First question: Is there a way to display only a certain number of the most recent records? For example, to limit the pivotchart to displaying only the 20 most recent values. The values have both a time and ID tag on them if that helps.
For my second question: Is there a way to automatically update the pivot chart as the query is also updated? When I enter data into a form in one... -
i guess i should add also: if there is some other coding i can use to perform this operation, i'll definitely take that too. i just thought this might be the easiest way. i've tried lots of different codes like DoCmd.GoToRecor d and such, but it doesn't seem like Access wants to allow me to use coding to go to specific records in subforms from the main forms coding. -
Move Record Selectors in a subform MS Access
This is MS Access: Is it possible to move the RecordSelectors in a subform from the main form's coding? I want to use a RecordSelectors .MoveLast type code that will move to the last record in a subform, which is based on a query, from the main form's coding.
Thanks
No activity results to display
Leave a comment: