Paste an ole object

[Mike Mueller]

Access 2000

On a form I am generating a MapPoint map (ActiveX control).
I am able to copy the map using vba. Map image is on
clipboard. I would like to put this image into an ole
field. Problem is I don't know the command to paste it.

 

[Michel Walsh]

Hi,


First, I must say I don't know, but I find that will increase your
database size quite tooooo fast, I think. Can't you just store the
coordinates (and zoom level) in the db, re-opening the MapPoint ActiveX and
specifying those rather than storing the picture you got (at the moment you
got it, I mean, blind to new update eventually brought to the map) ?



Hoping it may help,
Vanderghast, Access MVP

 

[Mike Mueller]

I am aware of the bloat this will incur. What would
probably be best is to save the image as a bitmap and link
it to that field to eliminate that bloat. I don't know how
to automate that either though.


: Hi,
:
:
: First, I must say I don't know, but I find that will
: increase your database size quite tooooo fast, I think.
: Can't you just store the coordinates (and zoom level) in
: the db, re-opening the MapPoint ActiveX and specifying
: those rather than storing the picture you got (at the
: moment you got it, I mean, blind to new update eventually
: brought to the map) ?
:
:
:
: Hoping it may help,
: Vanderghast, Access MVP
:
:
:
:
: message :: Access 2000
::
:: On a form I am generating a MapPoint map (ActiveX
:: control).
:: I am able to copy the map using vba. Map image is on
:: clipboard. I would like to put this image into an ole
:: field. Problem is I don't know the command to paste it.
::
:: --
:: M^2

 

[Michel Walsh]

Hi,


From MapPoint help file, it seems the control has its own method to SaveMapAs:


=============
The MapPoint Control

File I/O in the Control
The most noticeable change in behavior of methods and properties in the Control is the way that you load and save files. The methods and properties of the Application and Map objects that load and save MapPoint files (.ptm and .ptt) will not work when running in the Control. You must use the Control's methods for loading and saving maps. These include the NewMap, OpenMap, SaveMap, SaveMapAs, and CloseMap methods, as well as the FullMapName property.

=============



Vanderghast, Access MVP