Ask Question Forum:
Model Library:2025-02-08 Updated:A.I. model is online for auto reply question page
C
O
M
P
U
T
E
R
2
8
Show
#
ASK
RECENT
←
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Below area will not be traslated by Google,you can input code or other languages
Hint:If find spelling error, You need to correct it,1 by 1 or ignore it (code area won't be checked).
X-position of the mouse cursor
Y-position of the mouse cursor
Y-position of the mouse cursor
Testcursor
caretPos
Attachment:===
Asked by Paul-bbc
at 2024-08-02 04:55:48
ModifyPoint:500 Replies:5 POST_ID:828663USER_ID:11547
Topic:
Microsoft Access Database;;
I am looking for a method within Microsoft Access to open Google maps and go to a postcode held in a data field [Postcode] on the current active form. Access 2007 and greater.
Author: Paul-bbc replied at 2024-08-05 01:30:32
Duncan got there first and gave me most of what was needed.
LSM post added some good extra bits
and Jerry's was useful for a quick solution that could almost be dropped into any existing system
LSM post added some good extra bits
and Jerry's was useful for a quick solution that could almost be dropped into any existing system
Assisted Solution
Expert: jerryb30 replied at 2024-08-02 17:18:49
100 points EXCELLENT
I found this by one of the Access Experts:
http://www.helenfeddema.com/access.htm
Article 193.
Download it and see if it is what you need.
[Edited by SouthMod]
http://www.helenfeddema.com/access.htm
Article 193.
Download it and see if it is what you need.
[Edited by SouthMod]
Expert: Scott McDaniel (Microsoft Access MVP - EE MVE ) replied at 2024-08-02 05:54:36
Here's a pretty decent list of the available parameters:
http://moz.com/ugc/everything-you-never-wanted-to-know-about-google-maps-parameters
Note to use that from Access, you'd do this, perhaps in the Click event of a button:
Application.FollowHyperlink "https://maps.google.com/?q=12345"
If you want to dynamically include that zip code:
Application.FollowHyperlink "https://maps.google.com/?q=" & Me.PostalCode
Where "Me.PostalCode" points to a Textbox on your Form that contains the Postal Code.
http://moz.com/ugc/everything-you-never-wanted-to-know-about-google-maps-parameters
Note to use that from Access, you'd do this, perhaps in the Click event of a button:
Application.FollowHyperlink "https://maps.google.com/?q=12345"
If you want to dynamically include that zip code:
Application.FollowHyperlink "https://maps.google.com/?q=" & Me.PostalCode
Where "Me.PostalCode" points to a Textbox on your Form that contains the Postal Code.
Assisted Solution
Expert: Scott McDaniel (Microsoft Access MVP - EE MVE ) replied at 2024-08-02 05:50:55
150 points EXCELLENT
When you say "open Google maps", do you mean you want to open the computer's internet browser and go to that site, or you want to open an embedded browser (one embedded in your form)?
You can open a Google Map window from a standard URL:
https://maps.google.com/?q=12345
This opens to a site in Schenectady, NY, since "12345" is the zip code for that city.
You may need to use localized Maps versions, for example:
https://maps.google.co.uk/maps?q=12345
Shows a location 123 45 Farsta in Sweden.
You can open a Google Map window from a standard URL:
https://maps.google.com/?q=12345
This opens to a site in Schenectady, NY, since "12345" is the zip code for that city.
You may need to use localized Maps versions, for example:
https://maps.google.co.uk/maps?q=12345
Shows a location 123 45 Farsta in Sweden.
Accepted Solution
Expert: duncanb7 replied at 2024-08-02 05:42:15
250 points EXCELLENT
Is it what your want ? the answer is inside
http://www.access-programmers.co.uk/forums/showthread.php?t=134371
http://www.access-programmers.co.uk/forums/showthread.php?t=125954
http://www.access-programmers.co.uk/forums/showthread.php?t=134371
http://www.access-programmers.co.uk/forums/showthread.php?t=125954
