Re: How To Update VBA Code In Embeded Object In Table

I am thinking o using your suggested approach!! I have a question on how I
should approach the problem. I have a comma delimited database that I get
and I down load the data into my table. The amount of data in that database
determines the number of records I have.

I next put in the standard embed object template (visio) into the OLE field.
My use then start filling in addition data for each record and does the
drawing.

I was thinking of making a butch of these visio template files and storing
them in a folder. The folder will have the same name as the database except
inside this folder there will be all of the visio drawings.

That means in my table, I will be creating a link to this folder and the
individual visio drawings. That means the location of the visio folder can
be moved around because that will break the link and would could me to
reconnect the link.

Is this the approach you would suggest????

From an educational reason, can you tell me why its not recommend to embed,
but separate the ole object (visio) in its own folder??? Is it because it
really stored in disk while having it embeded, I am depending on another
application to store the data??

I really appreciate your help.

Gary

"Alex Dybenko" wrote:

Hi Gary,
ok, I understand your approach, but still think that storing Visio drawing
as a file will be better, you can store a full file path in database, to
open it you can use either ShellExecute API or open Visio via CreateObject()
and then open your drawing there.

From my experience - storing office files as OLE Objects in database is not
a reliable solution, I always recommend to avoid it

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com



"Gary" <Gary@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7F92967E-4129-49D0-A6D3-762CA071C08E@xxxxxxxxxxxxxxxx
What do you think would be the best approach in storing the drawings??

I have 80 records, and each record has text or number fields. There is
only
1 OLE Object field used to show a unqiue drawing for each record. There
will
be 80 unique drawing. I currently created a form for entering the various
fields for the data. There is also a bounded Object frame used to allow
the
drawing to be done by double clicking on the OLE Object and the
application
opens up in its own windows (visio in my case) on the Access Form. The
user
can draw his drawing while he is still entering data for that given
recordset. We use a pen to electronically draw our drawing on the screen.
Since its a database, we can do various queries on the recordset and come
up
with certain recordset that I need converted over to power point.

Before going over to power point, the user has the ability to select which
layers he want visible on drawing for the power point. He also makes the
decision if he wants to flip the image too before we make the power point.
The reason to go over to power point was to print a slide show and the
ability to slide edit the presentation before printing easily. If I could
have created my own slide editor (the way power point has), we would have
keept everthing in Access. The drawing would still be in visio.

If I kept all of the drawings on a file on hard drive during the data
entry
and drawing phase, I would need to link the location back to the OLE
Object
frame. I think the difference would be either a bounded or unbounded
object
will be required (no sure which right now). The user will go back and
review
the data for each record and change the drawing if it didn't match some of
the conditions in the recordset. The user will still double click the OLE
Object frame to activate the Visio drawing and make the changes. So I am
not
sure if it was better to embed or link the drawings here??? I think the
amount of storage space was the same.


What would you recommend as a possible approach to this problem???

What do you normally do for such problems????

I appreicate any suggestions you may offer!!!!

Thank You,

Gary

P.S. Making the form invisible doesn't work (first question above)
because
when you activate with a Verb=2 on the access bound object frame - it
opens
up a separate Visio Window. I want to hide the visio windows coming up
and
closing was a sequence through the table. If I can change the Visio
layers
properties of the drawing without activiating, then I don't have that
window
coming up. I have been trying to hide this for a while. I also tried
making a form alway on top, and that doesn't work either the the
activation
us a UI window.

"Alex Dybenko" wrote:

Hi Gary,

1) An Excel OLE Obj window is open (either in place or in a separate
window). Is there a way to hide this window?? It becomes ignoring
when
you
cycle through 80 of these.

i think you can try to hide form, make it Visible property=false

If I need to change which layers are visible on the embed object, do I
need
to activate (like what your example did) before I can change which
layers
are
visible and no-visible????

yes

If I left a version of Visio or Excel open (i.e. use CreateObject),
would
it
be faster when I activate each of the records which has the OLE
Object???

Well, perhaps this can be faster, but depends on how Visio handle this,
you
have to try.

In general - I don't know your whole idea, but I think the better idea -
is
to store Visio drawings as files on hard drive, or as binaries in access
table, this how we normally make such solutions

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com




.

Relevant Pages

  • Re: Data does not refresh to drawing.
    ... No, Access is on a server, I can link to the database. ... do not show the room number on the drawing and I am using it as the key. ... "Running XP Pro on a Network with Visio 2007", are Visio, the drawing, and ... If you select from the menu bar view => external data window, ...
    (microsoft.public.visio.general)
  • Re: How To Update VBA Code In Embeded Object In Table
    ... I put a unbound object frame, ... I was able to create all of the drawing on a folder with sequential names. ... I next put in the standard embed object template (visio) into the OLE ... OLE Object field used to show a unqiue drawing for each record. ...
    (microsoft.public.access.modulesdaovba)
  • Visio 2003, Database linking, Space Plans - Slowly going crazy
    ... Visio 2003, or at least my lack of knowledge about Visio 2003 is ... A SQL database which contains computer equipment assets. ... a main Asset table which contains a record for each asset along with ... I have a Visio drawing which spans multiple pages which diagrams ...
    (microsoft.public.visio)
  • Re: Visio 2003, Database linking, Space Plans - Slowly going crazy
    ... > Visio 2003, or at least my lack of knowledge about Visio 2003 is ... A SQL database which contains computer equipment assets. ... > a main Asset table which contains a record for each asset along with ... I have a Visio drawing which spans multiple pages which diagrams ...
    (microsoft.public.visio)
  • Re: dashed line not displaying
    ... it to Word due the following in Visio. ... Delete the dashed shape and replace it with a rectangle. ... Save your drawing. ... I am unable to use the pencil tool (to resize in any ...
    (microsoft.public.visio.general)
Loading