Search results for query: *

Anybody have any other ideas or suggestions for a solution? Still trying to work on this one. Thanks in advance. air1access

Thank you Dhookum. That did exactly what I needed. air1access

Anybody have any other ideas or suggestions for a solution? Still trying to work on this one. Thanks in advance. air1access

I have a piece of code I'm messing with to normalize a recordset. I'm trying to get the field name of rs1 and add it as a value for rs2. I have a tried a few things, but can quite get it.... Any suggestions? Thanks in advance..!! Dim db As Database Dim rs1 As Recordset Dim rs2 As Recordset Dim...

Ok - lets see if this is better. Thanks Andy..!! Dim db As DAO.Database Dim rs As DAO.Recordset 'Dim Fields As DAO.Field Dim ppObj As PowerPoint.Application Dim ppPres As PowerPoint.Presentation Dim iFound As Integer Dim cl As Cell Dim rw As Row Dim r As Integer Dim c As Integer Dim...

I have been messing with the code below. Can't get it to work. It looks like creates a new .pptx, and adds a powerpoint table (which would be best for me if I can get it to work), then adds the results of a query to the powerpoint table. If get an error on rs.Fields(1) and rs.Fields(c - 1)...

Theres got to be a way to do this. I found several code examples that either add a new slide, or adds a text box (with text) to an existing slide. Theres got to be a way to connect to power point template from ms access, go to a specific slide and add the results of a query to the specific...

Andrzejek, That must be a PowerPoint Add-in. I don't have that option. I seen that too. Any other suggestions? I'm looking to use a access query to populate a single slide in a powerpoint .potx (template) file , and save it as a .pptx with a new file name. Right now the powerpoint template...

I have lots of powerpoint slides I need to create every month. The slides are the same for every one. So I have a template basically that never changes. The only thing that changes is the info on slides 2 (current date) and 4 (table in powerpoint). I hoping there is a way to take a query of...

Thanks Duane..! That's exactly what I was lookin' for. Awesome..!! \m/

The union query will be the final goal... I'll copy it and paste it into excel...

Ok - I Hope this helps..! Here is how it looks now. Just 2 fields at the moment. No primary key, but I can add one if need be. Team[tab][tab][tab][tab][tab]Process Admin Ops-141[tab][tab]Escalated Member Status Change - 141.12 Admin Ops-141[tab][tab]HouseCalls Business Continuity Plan -...

I have seen this trick a while back but can't remember how to do it...! I have a table with the data like this: Admin Ops-141 Escalated Member Status Change - 141.12 Admin Ops-141 HouseCalls Business Continuity Plan - 141.11 Admin Ops-141 HouseCalls Small County Analysis - 141.13...

the value of i when viewed in the Watch Window is the series number... It does not show "CallCenter/eVendor", "External Partners", etc - such as the fields used for the chart. Am I doing it wrong? I'm trying..! lol I guess I can rename my field values to match the series index..? I don't know...

Ok - I have been working to understanding the Watch Window. Mostly greek to me, but I think I'm catching on.. I put a watch on "Select Case .Name"... The Watch Window shows the value for Name -- "Microsoft Access" Not sure what this means or what to do next...

Sooooo......? What... That's it..? I'm learning - what can I say? Is there another method to do what I'm trying to do in Access...?

I'm starting to believe that there is no .Name property with the Chart object in MS Access. I still get the same error...

Thanks for the help SkipVought..! I tried your example and I keep getting an error on: Select Case SeriesCollection(I).name The error message is: Compile Error: Sub or Function not defined Any ideas/suggestion?

Ok... I kinda got some where. The code below works for a column chart and sets the color of the column in each series separately... I'm needing it to be where it sets the column color based on the Series name... It always errors when I add something like: Series.Name = "dfassdffasd" Any...

I was looking at that myself dhookom... I'm still trying to wrap my head around it...