hi, i am having trouble using mappoint in a office enviroment.

i have been able to use the mp2k example in access form but when it comes to integreating with a access REPORT, i am unable to paste the directions from clipboard or copy the image map to the report.

i am using mappoint 2004 and office 2003

http://www.mp2kmag.com/articles.asp?ArticleID=39

has any bright spark got any ideas??

Try the Home Locator sample application article.. -
http://www.mp2kmag.com/a74--home.locator.mappoint.html

Another approach that may seem a bit unusual is used to generate a report that includes a map. When the report is opened, the application first saves the map as a web page and then strips out the GIF file that is used in the Access report.

hope this helps!
Eric

do you know where i can have a look at the code for this?

can you use the mappoint control in a access report???

I don't believe so.. can you embed other controls on an Access report?

Eric

is there any where i can download the code for the Home Locator sample application article?

See the download link at the bottom of the article -
http://www.mp2kmag.com/downloads/homelocator.zip

Eric

thanks, i have already downloaded the file but i am unable to view the source code. is there anywhere i can view vb code ?

i am starting to run out of ideas for using mappoint with a access report, do you think it can be done, to produce directions and a image of a map from a database in a access report ???

Yes, it's possible as the demo shows.. but it sounds like you might need to enlist someone who knows Access development to get it to work for you..

Hold down the shift key while opening the database, this will prevent "autoexec" events from firing and allows access to the database window.

The code John Washenberger put in the report is -

Code:

Option Compare Database
Private Sub Report_Open(Cancel As Integer)
  'Display the Map as the report's picture
  Me.Picture = GetAppDir & "map.gif"
End Sub

The forms have a lot more code.

good luck!
Eric

thats great.


do you also know if it is possible to save the directions to a text file?