tomric
Last Activity: Jan 7 '11, 10:32 PM
Joined: Nov 3 '09
Location:
-
Thaank you very much. It's working just fine. -
Thank you. Both forms are open, but how do I change the parameter name in the evaluation statement, Eval(prm.Name)? All the parameter will have different namesLeave a comment:
-
Setting query parameters through VBA
I have a query that looks at two forms. The first form provides a number to pull a group of records out of a table. The second from provides a series of 8 different check boxes that the query ueses to filter the data as required by the person using it. The query works great when looking at the table or a report. Im having problems when I open the query in code to send it to excell for graphing. I don't know how to get the query to look at the... -
Thank you
Thank you I will give your suggestion a try.Leave a comment:
-
Entering criteria into a query using VBA
I have a question on passing data to the criteria of a parameter of a parameter query using VBA. I have a query set up that has ten different fields in it. One is field named “status”, this field contains numbers from 0 to 9 depending on the type of defect a particular part was rejected for. I need to filter the data from the query based on a number or numbers in the status field. On the form that calls this query is a series of 7 check boxes... -
Thank you, but I'm still a little lost. Im my querys there are 10 fields. one field is called "status", depending on how the automated testing goes a number from 0 to 9 will be placed in this field. The number represents either a 0 for a good part, or 1 through 9 depending on how the part failed. On my form there are 10 check boxes, and 6 option buttons. The check boxes will be used for filtering data. Depending on which box or combination...Leave a comment:
-
Query criteria
I have several queries that combines and averages data in different ways. I want to add check boxes to a form for filtering specific data out or in to the results when the query runs. Is there a way to set the criteria of a query from code? Thank you. -
Thank you for your help.Leave a comment:
-
Yes that is correct, the report will run just fine. it's the cancel button that's the problem. If I try running the report by itself, with out the code from the form, and click cancel it works ok.Leave a comment:
-
I tried that, it doesn't go into the subroutine. If I go through and run the report it works with no problems. It's just when I hit cancel it stops at the DoCmd.OpenRepor t line. I also tried steping through from the begining of the procedure, it gets to that line, opens the report which opens a query, hit cancel from the criteria question, goes back to that line and stops with the error.Leave a comment:
-
Thank you, but I'm still getting the "Run Time Error 2501". Have any other sugestions? I put a break in at the error sub routine and steped through it, it doesn't go into the routine before I get the error.Leave a comment:
-
Run time error 2501
Hi, I have an option group to select different reports, each report is based off a query that asks for criteria for that report. I have no problem opening any the querys through the group regardless of the data involved. The problem arises when you go to open a report and click the cancel button on the criteria question. I get a "Run Time Error 2501", "The Open Report Action was canceled". The error occurs only on the reoprt... -
Adding multiple records to a table based on data in a form.
I have a table set up that is used for viscosity data on a our parts. There are are eight different checks over three different materials that go into construction of our parts. There can also be between 2 and 8 parts made at the same time that the same viscosity numbers are valid for. I have a form set up that will generate the different part numbers in 8 different text boxes. Also, there are text boxes for each viscosity measurment. How do... -
When the data comes in all I get for indentification is the bar# and part#. That's the problem, I have no way to relate the tables on a one to one relationship. When I do querys on each table I can get the results I need, but I can't seem to find any way to combine the querys to get a cohesive data set.Leave a comment:
-
I konw the table structrues arn't the best, but with numours parts per bar in the testing phase I can't use the bar # as a primary key. I don't know what else to use sine the data data is imported the way from the testing equipment. On the report I need the Bar#, date fired, furnace #, date tested, part#, 5 test results from table #2, and 3 test results from table #3. The reuslts need to be correlated to each part number.Leave a comment:
-
Table #2 and table #3 both have multiple records for each bar number. Each bar can have up to 64 parts associated with it, and each part goes through the 10 tests from table #2, and the 6 tests from table #3.Leave a comment:
-
Query relationships
I have three tables that contain data on testing results from the parts we make. Table #1 contains 5 fields used to indentfy each bar. Table #2 contains electrical test data on 14 different tests. Table #3 contains data on 9 different dielectric tests. I need to make a report that contains data from each of these tables. Table #1 has the primary key for each bar #. The problem is I can't use the bar number as the primary key for any of the... -
Thank you very much, I got it to workLeave a comment:
-
Open an excell spreedsheet from access 2007?
I'm having a problem open an excel spreedsheet that I transfered data to from access. It use to work in access 2003, the we changed over to office 2007 and the code quit working. On the line "Application.Fo llowHyperlink" I get an error "Cannot open specified file" In the subroutine I call it does open the file and transfers data to it, but I can't get it to open once the data is there. Any advice on how to fix this.
...Last edited by Stewart Ross; Feb 4 '10, 07:05 PM. Reason: Please use the [Code] & [/Code] tags provided to enclose your code -
How do you average in a query?
I have a query that sorts data from a table based on a build type. Each build type has several designs, and each design has several bars associated with it. For each bar there is 42 to 64 different parts, and each part has data from 8 different electrical tests performed on it. How do you average the electrical test data so that my query comes out as a column for BAR#, DESIGN#, and a column for each electrical test that has the average for that...
No activity results to display
Leave a comment: