December 1999
Intermediate to advanced
480 pages
11h 5m
English
IN THIS CHAPTER
Sending Data to Access
Getting Data from Access
Querying Access for Visio's Use
Severing the Connection
As we saw with Visio earlier, contacting Access from within Visio can be done using GetObject(), CreateObject(), and New. The first of these presumes that Access is already up and running. The second and third assume nothing and will launch a new copy of Access, even if it is already running. Listing 22.1 shows the syntax.
Public Sub RunAccess1() Dim accessApp As Access.Application Set accessApp = GetObject(,"Access.Application") accessObj.Visable = True End Sub Public Sub RunAccess2() Dim accessApp As Access.Application Set accessApp ... |
Read now
Unlock full access