MapForums

doddsHH · #1 (**permalink**) 01-24-2005

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??

**Eric Frost** · #2 (**permalink**) 01-24-2005

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

Quote:

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

doddsHH · #3 (**permalink**) 01-24-2005

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

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

**Eric Frost** · #4 (**permalink**) 01-24-2005

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

Eric

doddsHH · #5 (**permalink**) 01-24-2005

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

**Eric Frost** · #6 (**permalink**) 01-24-2005

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

Eric

doddsHH · #7 (**permalink**) 01-24-2005

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 ???

**Eric Frost** · #8 (**permalink**) 01-24-2005

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

doddsHH · #9 (**permalink**) 01-25-2005

thats great.

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mappoint 2004 & Office 2003 compatibility problem	javigdiaz	MapPoint Desktop Discussion	2	12-16-2004 09:24 AM
MapPoint 2004 Office Add-In error	StephenBurd	MapPoint Desktop Discussion	2	06-10-2004 09:41 PM
MP 2002: does it do the job also with non-XP Office?	pwy	MapPoint Desktop Discussion	2	05-14-2003 05:29 PM
Office 2003 conflicting with MapPoint 2002	Eric Frost	MapPoint Desktop Discussion	0	03-11-2003 09:56 PM
Mappoint control in an Office Application using VBA	ToddRCS	MapPoint Desktop Discussion	1	11-19-2002 04:00 PM

MapForums

Mappoint in an office enviroment - mp2k example

Mappoint in an office enviroment - mp2k example

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads