Search results

I have several pivot charts that I've created from pivot tables and would like to have several of those charts on a report or a form. I would like the user to be able to select the fields available in a pivot chart to filter chart results. How can this be done? I tried just dropping a pivot...

I am creating pivot charts using bar graphs and want to have data labels show up over the top of the bar in the chart, I know that I can right click on the top of the bar and using that property box I can select the button for data label as well as being able to also have series and...

I have several pivot tables in Access where I've created some calculated totals. I want to create pivot charts from these pivot tables but I cannot seem to get those calculated total into the charts. I'm only seeing where I can do "autocalc" like Sums, averages, etc. I thought I may have...

I have a form called frmProductionNumbers. On that form is a subform/subreport called frmSubformTabCtlProductivityWasteCharts. The subform is a tabbed form containing six tabs. On some of those tabs there are two charts some with only one. How do I get the form to load and the subform to...

I have the code below that was created in SQL view by someone else to help me out of a problem I was having. The code worked well until, when adding a new feature to my form, I had to change field types in my main table, "tblProductionNumbers", from Number type (because I was using lookups) to...

What am I missing in "this code will select the checkbox on the tab for the dupl rec" I'm trying to figure out where the error in my code is or if I need to be trying to create my additional records another way. So far with the code below I can create the additional records according to the...

I have the below code that, if a checkbox representing an additional available time on a form is checked then the record is duplicated and that additional available time is added into the time field of the new record. On the form there are numerous checkboxes that the user can select. These...

I've been trying to put the final touches on some code that a user has helped me with but for the life of me I cannot find out why I'm getting a data type mismatch error 13. I have a user form that workers fill out. They fill out this record every two hours. At times, they need to create...

I have a form where users enter production data at set times during the day. The set times for dayshift are: 6:30am, 8:30am, 10:30am, 12:30pm, 2:30pm and End-Days. The set times for nightshift are: 6:30pm, 8:30pm, 10:30pm, 12;30am, 2:30am, and End-Nights Both shifts work 12 hour shifts...

I am trying to create a query that will output only one line per product, giving Summed totals per product of LF Produced (tblProductionNumbers) and Manhours (tblManHours). The query would then divide LF Produced by Manhours for each product to give the value for "Productivity". Do I need...

I also posted this in the forms section but it probably belongs here. I am trying to create a DSum formula (to use as a control source in a chart) in a query that will look at a particular set of records(based on a product type), and take the value of that record's waste number (a calculated...

I am trying to create a DSum formula (to use as a control source in a chart) in a query that will look at a particular set of records(based on a product type), and take the value of that record's waste number (a calculated number) and divide that by the value of that record's LF Run number...

I am using CR2008 I am creating a report for our salesmen and one of the fields in the report will be a text box that shows what the last month was. For instance, if the report is run this month, the report will plug July 2011 into the box because that was what last month was. Tied to this...

Hello all; This is probably a dumb question but here goes..... I have a form called "frmProductionNumbers" with a subform called "frmSubformTabCtlProductivityWasteCharts" that resides on a tab control. I want to have the chart update it's values based on data in the currently displayed...

I have a query that returns records that occur during the current week. The criteria for this is: DatePart("ww", [ProductionDate]) = DatePart("ww", Date()) and Year( [ProductionDate]) = Year(Date()) In the query are several calculated fields: Waste: [LF Run]-[LF Produced] Waste%...

I've created a chart from a query and I'm wondering how to add a total in the chart of all the values represented? The chart is a bar chart, for example, and has 4 bars with the value of 25 each. I'd like to have a text box on the chart that shows the total of the bars added up is 100 in this...

I have created code to use the DoCmd to open reports nad queries in datasheet form. I have a query that opens in pivot table form. What DoCmd syntax would I use to open a query in PT form? Here is the code I've used with the DoCmd to open queries and reports. Cannot figure out how to get...

Hello All; I have a form that has about 17 command buttons on it :eek: that run different macros. The macros run queries and or reports. The frontend has gotten somewhat cluttered with 17 command buttons on it. How can I put the command buttons/macros in a combo box list so I can save room...

I have a DB with the following tables/fields: Table=GLAccount Field=GLAccountNumber In the field value, there are 7 different account numbers that I want to sum up (there are many more, but only want to sum seven of them). The account numbers represent different product lines. They are...

I am trying to figure out the formula for summing some consolidation accounts from Businessworks Gold 2011 (BWG). I have the developers edition of CR for BWG so I can access the DB for BWG. The account numbers from BWG "Chart of Accounts" are: 400000.000 419999.000 430000.000 The Table for...