O'Reilly logo

Professional Development with Visio® 2000 by David Edson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Querying Access for Visio's Use

Listing 22.4 shows a deletion process when items are deleted in Visio and they need to have the corresponding record deleted in the Access database.

Listing 22.4. Deleting Database Records by Deleting Shapes in a Visio Diagram
 Public g_dbsMyDatabase As DAO.Database Public g_szDBFileName As String Public g_bTrack As Boolean Global Const g_szDefFileName$ = "d:\MyDatabase.mdb" Global Const g_nFileNotFound% = &HFFFFFFFF Global Const g_szTableName$ = "Item" Global Const g_szFieldCost$ = "ItemCost" Global Const g_szFieldName$ = "ItemName" Global Const g_szFieldGUID$ = "ItemID" Global Const g_szUserFileName$ = "User.DBFileName" Global Const g_szUserTrack$ = "User.Track" Global Const g_szPropTrack$ = "Prop.Track" Global ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required