Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 12-10-2019, 09:05 AM   #1
Boch
Newly Registered User
 
Join Date: Dec 2019
Posts: 8
Thanks: 4
Thanked 0 Times in 0 Posts
Boch is on a distinguished road
Map button - Go slow I'm a noob

hi Everybody (Trying not to sound too much like Dr Nick from the Simpsons)

I have been using one of the templates that come with MS Access 2016 (Contacts template), I have tweaked it a little bit but nothing major. What little Access skills I have, I have from YouTube - mainly. So I'm at a very basic level.

In the Contacts template there is a feature which, when you press the "click to map" button, will take the address and open Bing maps where the address is.
So far I have been able to change this to Google maps (who uses Bing Maps?!?) but have been unable to replicate this function in the new template I'm planning on migrating to (Personal contact manager).

I have been able to copy the VBA <modMapping> into the new template but can't get the button to link to this or find what the missing link is to make this function happen.

Any help would be much appreciated.
TIA

Attached Images
File Type: jpg MS Click to map.jpg (6.1 KB, 9 views)
File Type: jpg MS Modules.jpg (2.5 KB, 4 views)

Boch is offline   Reply With Quote
Old 12-10-2019, 09:08 AM   #2
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,921
Thanks: 120
Thanked 3,327 Times in 3,003 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Map button - Go slow I'm a noob

Hi Boch
Your post was moderated due to the attached images. Until you have 10 posts you need to zip any attached files

Buttons can't link to modules but they can run procedures contained in those modules.
You might get more specific help from someone if you upload your database (zip it first!)
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Colin (Mendip Data Systems)
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)
isladogs is offline   Reply With Quote
The Following User Says Thank You to isladogs For This Useful Post:
Boch (12-10-2019)
Old 12-10-2019, 09:11 AM   #3
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 7,248
Thanks: 63
Thanked 1,681 Times in 1,636 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Map button - Go slow I'm a noob

Hi. Did you also copy the code or macro behind the button from the first template?

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 12-10-2019, 09:14 AM   #4
Boch
Newly Registered User
 
Join Date: Dec 2019
Posts: 8
Thanks: 4
Thanked 0 Times in 0 Posts
Boch is on a distinguished road
Re: Map button - Go slow I'm a noob

Quote:
Originally Posted by theDBguy View Post
Hi. Did you also copy the code or macro behind the button from the first template?
Could only copy the VBA - can't find the macro to make it happen, which is the frustrating part, otherwise, I'd be able to do the command button wizard
Boch is offline   Reply With Quote
Old 12-10-2019, 09:21 AM   #5
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 7,248
Thanks: 63
Thanked 1,681 Times in 1,636 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Map button - Go slow I'm a noob

Quote:
Originally Posted by Boch View Post
Could only copy the VBA - can't find the macro to make it happen, which is the frustrating part, otherwise, I'd be able to do the command button wizard
If you go to Design View of the Form and select the button, you can check what it says in the Click Event property. What do you see?
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 12-10-2019, 09:37 AM   #6
Boch
Newly Registered User
 
Join Date: Dec 2019
Posts: 8
Thanks: 4
Thanked 0 Times in 0 Posts
Boch is on a distinguished road
Re: Map button - Go slow I'm a noob

Quote:
Originally Posted by theDBguy View Post
If you go to Design View of the Form and select the button, you can check what it says in the Click Event property. What do you see?
Wish I could post screen grabs or links, which is making this harder than it needs to be

On click [Embedded macro] in design view
Boch is offline   Reply With Quote
Old 12-10-2019, 09:48 AM   #7
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,921
Thanks: 120
Thanked 3,327 Times in 3,003 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Map button - Go slow I'm a noob

Quote:
Originally Posted by Boch View Post
Wish I could post screen grabs or links, which is making this harder than it needs to be

On click [Embedded macro] in design view
You can!
As previously stated, ZIP the screenshots and upload one zip file.
Once you reach 10 posts, that restriction is removed

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Colin (Mendip Data Systems)
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)
isladogs is offline   Reply With Quote
Old 12-10-2019, 10:38 AM   #8
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 7,248
Thanks: 63
Thanked 1,681 Times in 1,636 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Map button - Go slow I'm a noob

Quote:
Originally Posted by Boch View Post
Wish I could post screen grabs or links, which is making this harder than it needs to be

On click [Embedded macro] in design view
Okay, next to that, click on the three dots button, what do you see?
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 12-11-2019, 04:58 AM   #9
Boch
Newly Registered User
 
Join Date: Dec 2019
Posts: 8
Thanks: 4
Thanked 0 Times in 0 Posts
Boch is on a distinguished road
Re: Map button - Go slow I'm a noob

Quote:
Originally Posted by theDBguy View Post
Okay, next to that, click on the three dots button, what do you see?
See image 3dots
Attached Files
File Type: zip DB Contact design view.zip (250.7 KB, 4 views)
Boch is offline   Reply With Quote
Old 12-11-2019, 05:58 AM   #10
Boch
Newly Registered User
 
Join Date: Dec 2019
Posts: 8
Thanks: 4
Thanked 0 Times in 0 Posts
Boch is on a distinguished road
Re: Map button - Go slow I'm a noob

Big thx for all the help guys.

Basically with you pointing me in the right direction I managed to copy the cmdMap macro (in a fashion) and then wrote new cmdMap macro in new template.

Either that or it's just luck that it now works -

Big thx all round for the inspiration in helping me getting this to work, am a very happy bunny now
Boch is offline   Reply With Quote
Old 12-11-2019, 06:18 AM   #11
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 7,248
Thanks: 63
Thanked 1,681 Times in 1,636 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Map button - Go slow I'm a noob

Quote:
Originally Posted by Boch View Post
Big thx for all the help guys.

Basically with you pointing me in the right direction I managed to copy the cmdMap macro (in a fashion) and then wrote new cmdMap macro in new template.

Either that or it's just luck that it now works -

Big thx all round for the inspiration in helping me getting this to work, am a very happy bunny now
Hi. Congratulations! Glad to hear you got it sorted now. Good luck with your project.

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Reply

Tags
mapping , maps

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Slow performance (REALLY slow!) shacket General 29 10-06-2011 12:33 PM
Help for another noob Frag'd Forms 1 06-14-2009 01:17 PM
Access slow to load [really really slow!] Elfman General 3 12-14-2007 05:32 AM
Help a noob RaptorZ Forms 1 02-01-2006 02:59 PM
help for a noob! tru- Tables 4 01-30-2006 01:56 AM




All times are GMT -8. The time now is 05:52 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World