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

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

I understand now thanks Nidge. I'll fix that. I got this working now by getting rid of the lookups and using value lists but with the code it is only creating one record even though I've selected for it to create several records at once? Do I need to use a looping statement? If so, what...

Bob; So instead of using lookups at the table level should I just use a value list created and defined at the table? What Integer data type would I use to handle numbers and text since some of the values are text, i.e; "End-Days" or "6:30 AM"?

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

This is still driving me nuts. I continue to get the "run-time error '13': Type Mismatch when I try to run the above code. When I debug the debugger highlights the "Call addentry (varTime) for the 8:30am checkbox. I have that checkbox checked on the form. If I have the 10:30am box checked...

OK so I've been working with this all morning and not making any headway. Still not sure where or why the Runtime error 13 is coming from or why. Below is the code I'm using along with screenshots of the checkboxes and the code behind them. Private Sub AddRecords_Click() Dim varTime As...