Solved

Script error - Microsoft Access 2010 automation Google Maps

Posted on 2014-01-12
4
611 Views
Last Modified: 2014-01-17
I have been trying to resolve the following:

http://www.devhut.net/2013/10/18/webbrowser-activex-control-google-maps-invalid-character-scripting-error/

This was the final fix for a previous ASK:

I opened up the access database file referred to above. I anticipated the fix database would have a form with a command button to execute the registry fix. I think, though, the fix must have been applied to an open event on the form and it executed when I opened the database. I received an error on my Windows 8 system upon opening the form.

I don't know what to do from here, but the script error still persists.

Previous ASK below:


"I have created a Microsoft Access application automating the process of creating driving directions using Google Maps. The address data originates in Microsoft Access text boxes.

This used to work on my Windows 7 system. Now, I am getting the error on a Windows 8.1 and Windows 7 system. My client has one computer that is able to run the application without error. It is a Windows XP system running an older version of Microsoft Access."
0
Comment
Question by:pabrann
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 85
ID: 39775271
You mention several errors, but you haven't told us what those errors are.

Can you show screenshots of the errors?
0
 

Author Comment

by:pabrann
ID: 39775334
Sure, I'll attach an access database that demonstrates the error. If it does not generate an error on your system, please let me know.. Thanks!!

GoogleMap-Access-Database.zip
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
ID: 39787755
Not sure , ...but as a start, you are using "Global" variables, ...try changing that to "Public"

Also set the VBA option to require variable declarations for all new modules.
Then add "Option Explicit" to the top of all of your existing modules.

Are you sure that the Installed / default web browser has nothing to do with this?
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 39789996
Glad I could help
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question