Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

access

ResolvedVersion Standard

Leigh has attended:
Access Introduction course

Access

Once a Database has been created is it possible to link the data to objects in a Visio drawing and will the data update in the drawing as it is updated in the database. Or can a Visio drawing be linked by OLE?

Edited on Fri 4 Apr 2008, 09:52

RE: Access

Hi Leigh,

Sorry for the delay in getting back to you on this.

You can link Visio drawings as OLE objects.

Embedded drawings in the form - This option could be used when the developer wants to collect graphical information from the user. The diagram or graphic could be collected as an embedded drawing for temporary storage until it is committed by the user and stored either in a database or in the file system. This technique could also be used when the developer wants to generate drawings on the fly and display them to the user.

Linked Visio drawings - This option could be used when the developer wants to manage the creation and storage of a set of drawings. The user would be able to select either directly or indirectly the file or drawing they would want to display and/or edit. This option also works well as a method for viewing Visio drawings without opening Visio.

Visio drawings stored in a database - This option could be used in the same situations as linked Visio drawings where the developer is also collecting database-type information about each drawing and finds it convenient to store all the information in a database.

See also:
Visio and Visual Basic OLE Control FAQ
Sharing Visio Drawings
How to use OLE automation in Visio

I hope this helps.

Kind regards, Rich

Access tip:

Closing form after a certain time period

To make a form close automatically after a certain time period, you need to assign the close function to a macro.

Save the macro and ope up the form in design view. open the Properties sheet.

In the TimerInterval property enter the length of time you want the form open for. This should be in milliseconds, so for instance if you want the form open for 5 seconds enter 5000, for an minute enter 60000.

You now need to attach your macro (to execute the Close action) to the OnTimer event property of the form.



View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.