Search results for query: *

I have this: mdate mshift mmachine mQty 01/01/2004 1 machineA 50 01/01/2004 1 machineA 25 01/01/2004 1 machineA 15 01/01/2004 1 machineB 65 01/01/2004 1 machineB 45 01/01/2004 1 machineB 15 01/01/2004 2...

I have had a lot of trouble with this particular query. Here is what I want... The 3 largest downtime reasons for each date, shift, machine combination. I have a table that has these fields: tbl1ID date shift machine I have a 2nd table that has these fields: tbl2ID...

I am using Access 2002. I have been trying to find the proper source information to read on this topic. I am not finding it. I want to use a query to edit my table Production Speeds. I want to the query to list all machine/product combinations in a production group and provide the ability to...

I am relatively new to VBA. I have had no formal training and I do not expect to get any in the near future. Is it bad to declare a variable inside an if then statement? for example: if x = 1 then Dim Series1 Set Series1 = operatorChart.SeriesCollection.Add end if Set Series1 = Nothing...

I have a field in a query that is filled with values formated like this: format(mDate,"mmm") where mDate is a date. I want to Limit the values to only "Jan". If I put "Jan" in the criteria section I get a type mismatch error. I understand why, but what can I put in the criteria section...

I am putting a recordset values into a string, but I am having a little trouble storing the highest value into a variable. The type of rs1.Fields(0).Value is Variant/Double. I thought I could do something like: Dim Highval if highval < rs1.Fields(0).Value then highval = rs1.Fields(0).Value...

I have linked the my database to an excel spreadsheet. Changing the layout of the spreadsheet is not an option. The spreadsheet lists year, month, and day separately. Is there a function to build a date from these components? I want to make a query that reconstructs these components into a...

I am using Access 2002. I want to use VBA to add two data fields to my pivot chart. I want the chart to contain Employee names across the X axis, and two plots, one of efficiency and one of shifts worked on the same chart. I have a working example that I was able to construct by dragging and...

I want to discuss possible solutions to my problem. I cannot see how to solve my problem, elegantly. I have a query that lists a date, shift, and machine. The date and shift are taken from a production table. Those two fields represent a unique listing of all times that product was generated...

Here is what I want: 1. To SELECT 3 columns FROM a query ORDER BY column 3 ASC. I want to display the second and 3rd columns in dropdown and the non-dropdown area of the combo box. 2. I want to start typing data from column 2 and have it automatically select the correct entry from the...

I want to limit data entry on a textbox to numbers. No alphanumeric values. Is there a quick way to set this type of numeric validation?

Sometimes when you at the early stages of the learning process, you don't have the vocabulary necessary to formulate an intelligible question. I have a form with comboboxes and subform-pivot charts. Changes made to the comboboxes are reflected in the pivot charts... kind of a poor man's data...

I am a novice programmer and I am unfamiliar with the proper terminology. I have a form with 7 subforms. Two are pivotcharts. I have written code that &quot;refreshes&quot; the form and all subforms as new data is entered. However, it I can see it switching to the first record then back to...

Has anyone worked with dynamically generating pivotcharts in Access 2002. I am getting near duplicate instances of my data when I try to print my pivotchart using a print button that is generated by access. I am just a beginner, and I am pretty sure that my lack of knowledge is hampering my...

I am still pretty new to Access and VBA. I am displaying a query as a pivot chart. The query is based off of a query that I have constructed already. (I still don't know all the syntax for creating a query completely from scratch.) I modify the query with an SQL statement that I build in VBA...

This is my first post. Please tell me if I need to provide more information. I am still learning. I have a table similar to this: tblProduction ProductionID pDate pItem pQtyProduced I want to sum the production by week, starting on a Sunday. I want to list Sunday's date instead of...