Recent content by Repent

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

Oh you bet I do!! I'm of the belief that one can never have too many backups of projects. I always make a backup every morning before my daily development as well as backups before I change anything major. Yeah, I was thinking the same thing based on the feedback to my post. chris

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

Re: What am I missing in "this code will select the checkbox on the tab for the dupl Jim can you help me to further develop this piece? I like the idea especially if it reduces code and makes it easier for my users. Currently there is a Time combobox on the form for the user to select the...

Re: What am I missing in "this code will select the checkbox on the tab for the dupl Jim; Here are some screenshot that will hopefully show what I'm trying to do. As you can see, the form is made up of several tabs. On the tabs with the checkboxes those are all issues that could come up with...

Re: What am I missing in "this code will select the checkbox on the tab for the dupl Jim; I've uploaded a copy of my project. I think that will help. It's in Access 2010. I've had to learn and create as I go :banghead:with this project and so I know in some places it may not be "pretty"...

Re: What am I missing in "this code will select the checkbox on the tab for the dupl Jim; Thank you for the reply. I'm not quite sure I'm following you. I'll try to explain what is going on. SubAddRecords looks at a checkbox for a set time of day, such as 630am, 830am etc and if that...

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

Looks like this will work with using the macros on the VCR controls. Thanks for all your help on this Bob & Chris. Chris

I have a set of VCR controls on the form that allows a user to step backwards and forwards through the records. I'm thinking instead of driving my addentry code through a command box on the form of creating a snippet of code that only contains the code to clear the checkboxes and calling that...

You're right on that one Chris. I just commented out that code and can create multiple records. How would I best go about only having the checkboxes cleared after all the required records are created? I can see where even though I selected multiple boxes to create those records I basically...