PowerPoint Presentations based on Access Databases. 
Author Message
 PowerPoint Presentations based on Access Databases.

Hello All,
    Im still struggling with a problem of hooking PowerPoint Presentations Up to
Access DataBases via PowerPoint VBA Macros. I have read the KB articles
titled "Sample VB Code Uses DAO to Create Presentation","How to Fill MS VB 5.0
Flex Grid Controls" and "How to Fill A UserForm ListBox with DataBase
Values"...... But, Whenever I try to run the KB codes I get an error that
says "Can't Start your Application. The workgroup information file is missing or
opened Exclusively by another User." or "Missing Parameter. Expected 3" As near
as I can tell, these codes are all short one key component in connecting to my
database(s): I need to pass WorkGroup information (like DataSource and System
DataBase). I have done this in VB 6 but have no clue how to do it in VBA for
PowerPoint. The closest I have gotten is the following:

Set oWorkSpace= CreateWorkSpace(Name="JetWorkSpace", UserName= "MyName",
Password= "MyPassWord", UseType:=dbUseJet)

Is there some other Parameter that needs to be put in the above... Like
maybe "SystemDatabase = C:\Database\System.mdb" (I tried this and it didn't work)
Thanks In Advance for any assistance.



Fri, 07 Nov 2003 22:28:48 GMT  
 PowerPoint Presentations based on Access Databases.
Tomas Bucco wrote

Quote:
> Set oWorkSpace= CreateWorkSpace(Name="JetWorkSpace", UserName=
> "MyName", Password= "MyPassWord", UseType:=dbUseJet)

Set the SystemDB property of the DBEngine. For a sample, see q163002 in the
Knowledge Base.

  -- Dev



Sat, 08 Nov 2003 07:15:34 GMT  
 PowerPoint Presentations based on Access Databases.
THANK YOU!!!!
     That was exactly what I needed.

I did not know about the DBEngine's Properties.

Quote:
-----Original Message-----

Tomas Bucco wrote

> Set oWorkSpace= CreateWorkSpace(Name="JetWorkSpace", UserName=
> "MyName", Password= "MyPassWord", UseType:=dbUseJet)

Set the SystemDB property of the DBEngine. For a sample, see q163002 in the
Knowledge Base.

  -- Dev
.



Sun, 09 Nov 2003 04:19:29 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. auto powerpoint presentations and word letters from a database

2. Updating PowerPoint Presentation graphs using data from Access

3. Export reports to powerpoint presentation

4. PowerPoint Presentations

5. Keypress detection during a powerpoint presentation

6. PowerPoint record presentation API

7. Extract text and images from powerpoint presentation

8. powerpoint presentation

9. Object reference to Powerpoint presentation

10. Error trying to set relative path on linked powerpoint presentation

11. PowerPoint presentation as object

12. Opening a Powerpoint Presentation from VB

 

 
Powered by phpBB® Forum Software