Office中国论坛/Access中国论坛

标题: 如何外部数据库的报表??? [打印本页]

---

作者: xingzhihao    时间: 2007-11-29 20:27
标题: 如何外部数据库的报表???
如题:如何打开外部数据库的报表?

---

作者: andymark    时间: 2007-11-29 21:49

1. Dim DbPath As String
   
2. Dim oApp As Access.Application
   
3. 
   
4. DbPath = "c:\db1.mdb"
   
5. 
   
6. Set oApp = New Access.Application
   
7. 
   
8. With oApp
   
9. 
   
10. .Visible = True
    
11. 
    
12. .OpenCurrentDatabase DbPath
    
13. 
    
14. .DoCmd.OpenForm "MyForm" ' 打开窗体
    
15. 
    
16. .DoCmd.OpenReport "MyReport", acViewPreview '打开报表
    
17. 
    
18. .Run "MyFuncion" '执行宏
    
19. End With
    
20. 
    
21. Set oApp = Nothing

复制代码

---

作者: tmtony    时间: 2007-11-30 10:45
好方法,同时要注意有时要弹出式,否则报表显示不出来

---

作者: xingzhihao    时间: 2007-12-4 10:52
感谢二位老大!!!!!!!!!!!!!!

---

欢迎光临 Office中国论坛/Access中国论坛 (http://www.office-cn.net/)

Powered by Discuz! X3.3