I didn't look on the net, I used PowerPoint, to come to this conclusion: Now, I'm not sure of your office install, so let me summarize what I have installed: Office XP fully patched, when I installed it, I installed everything except ms office toolbar and the stupid paperclip ;^D Ok, inside PowerPoint, I went to Tools-->Macro-->Visual Basic Editor This opens up a new window (vb editor) >From here I deduced that you can access slide properties (hit F2, then where it says "<All Libraries>" there is a thing there that says "PowerPoint") that you can set the slide(s) properties, ie: text, location of text boxes, etc. I am no way able to help you with this part, I try to steer clear of Office and DB's (other than access). Access may work, but again, I'm a VB programmer, and I steer clear of using any office type dependencies. I have done large display news tickers where they would in effect take over a screen, read information from a DB and post the information on a Label in a Form. There was also a separate app that did the updating of the db.
Sorry I couldn't give you a definite How-To, but this is the best advice I can give. Thanks, James -----Original Message----- From: redhat [mailto:[EMAIL PROTECTED] Sent: Friday, August 27, 2004 4:36 PM To: mysql Subject: RE: PowerPoint and mysql On Fri, 2004-08-27 at 15:06, James wrote: > Looking quickly at PowerPoint, you *can* do what you want to do, > however, here's the catch, there is no quick way to pull from a file or > data source and have it write to the field in pp. You can do some VB > trickery with the built in VBA in it, where you can use the MySQL ODBC > driver and could read from a db and write to the screen. Another > (probably better) way would have a standalone app read the db, and with > some GUI (could be VB) take over the screen (such as pp does) and > display the music. I'm not sure how your church is setup with the pp > presentation, but these are my initial thoughts on the matter. I realize > you aren't a programmer, however, from a quick run through, I don't see > a way to do what you are asking with out any programming. > MSQuery is a program that usually comes with office that allows you to > connect to db's inside of office apps. > A DSN is a way for programs to connect to DBs (simple description). You > can setup DSNs in systems under Data Sources (ODBC) under administrative > tools (windows 2k/xp). > HTH > > Thanks, > James > > > -----Original Message----- > From: redhat [mailto:[EMAIL PROTECTED] > Sent: Friday, August 27, 2004 3:45 PM > To: mysql > Subject: RE: powerpoint and mysql > > On Fri, 2004-08-27 at 14:30, Victor Pendleton wrote: > > How did you plan on using the information pulled from the database? If > you > > are currently using MS Query or a DSN you can modify the current > connection > > information to point to your MySQL database. > > > > -----Original Message----- > > From: redhat > > To: mysql > > Sent: 8/27/04 2:21 PM > > Subject: powerpoint and mysql > > > > Greetings, > > I'm new to the list. > > I was wondering if it is possible to user mysql and powerpoint? I > have > > a small database of simple text entries that I want to create whereby > I > > can pull a title up and have the rest of the slide dynamically > > generated. The reason for this is that the presentation data will > > change weekly but over time the data will be used over and over - so I > > don't want to lose it or have to re-enter it. Any ideas? > > thanks, > > Doug > That is part of the equation. I know that in ppt I can add "objects" > but I don't see anywhere for any kind of datasource. I didn't know if > anyone was working on a possible plugin or maybe knew of a way to make > it work. Here's what I am doing. I handle all of the music at my > church. Every week we use a projector and a laptop to put the words to > the songs on a screen. I am taking the task of putting the songs on the > laptop and realized that for the past two years they were creating new > presentations for each week. I think this is a waste of time. At a > bare minimum I am going to dump all of the songs into some sort of text > document in a single directory - named by the title of the song. I use > mysql (I'm not a programmer) on some very simple php/mysql stuff at work > and am familiar with inputting data and then retrieving it again. If I > could have a db with just two columns (title, song) I and a way to > actually "import" this data to ppt I could make it work. In a perfect > world I would create a much larger db with song keys, dates of last > play, etc. I hope this clears my request up. As for "MS Query" or > "DSN", I don't use MS Query (not sure what it is) and I have no clue > what DSN is either. Sorry. Thanks for the input. > Doug > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > Thanks for the info. What resource did you use to come up with this information - can you share that? I suppose it may be worth checking to see if Access might work more readily than mysql?? I have limited exposure to Access and don't really like it but it may be an easier route?? I would like to view your resources though. thanks, Doug -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
