Web page on a form; google

I am prototyping a small application interface and wish to use ms/access 2013, possibly using the new APP functionality.

The idea is to have a small database, but, at least one of the fields would contain a web address that would present a page inside a form. the first idea is to show, inside the form, a frame where the page shows and when the user clicks on the frame, it activates the frame and control goes to the web page (google maps, just like what we see when loking for routes to an hotel).

Ideally, some information would be passed on so google maps, so it would center on the gps coordinates that I have stored.

then, after clicking, all google maps functionality would be activated.

Is it possible? How do I do it?
João serras-pereiraAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Barry CunneyCommented:
Hi jirdeaid,
In Form Design, choose Web Browser Control from the Controls group.
On the 'Insert Hyperlink' dialog there is a Parameters section in which you can specify that parameters come from a form field e.g. =[txtCoordinates]
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
I did something similar to this.   It was an application that allowed a user to checked on the placement of ads, and tracked their checks as well.

As BCUNNEY said, you do this through the web browser control.  However a word of caution; it's a very simple control with few events and methods.    If it's anything more then what you describe, you will find it difficult to accomplish the task.

There's also very little documentation on the control.

Last, I'd have to double check, but I believe the control is a throwback to an earlier version of Office.  Not even sure it's available with 2013 anymore.

Jim.
0
João serras-pereiraAuthor Commented:
Hi BCunney and Jim.

I have found the control. It exists and it is there. The problem is that I cannot find anywhere the Insert hyperlink dialog. When I select the control it just puts a black window on the screen.

Nothing on the properties sheet as well...

Any suggestions?
0
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

Jeffrey CoachmanMIS LiasonCommented:
post a sample of the database that you tried this in...
0
João serras-pereiraAuthor Commented:
0
Jeffrey CoachmanMIS LiasonCommented:
Ok, and what is it that you are trying to do?

Please list the explicit steps you want the user to make, and state the exact results you need.

For example:
1. The user Opens the from
2. the user clicks a Hyperlink
3. The webcontrol displays the website...
4. ...etc
0
João serras-pereiraAuthor Commented:
Well -

1. The opens the form
2. a predefined site is open (actually - google maps at a specified coordinate)
3. the user plays with google maps and the form gets the coordinates...
0
Jeffrey CoachmanMIS LiasonCommented:
Is this what you want the form to open to?:
https://maps.google.com/
If so, then no real "hyperlink" is needed, just set the web control to go to this site when the form opens:

It is quite easy to have Google maps map out a route between two points, ...or find a location, provided you know the two addresses...

But I am not sure if it is possible to "read" the cursor location in Google maps...
0
João serras-pereiraAuthor Commented:
well... my real problem is "where do I put the https://maps.google.com/" ?

the data source of the control has no field for it...

I do know that goggle maps does sent the coordinates, when it is invoked, but I do not knpw where...
0
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
Took a peek at your database.

First thing I noticed is that you are not using the native Access Web Browser Control.

I change the control Access Web Browser Control in the toolbox and bound it to the table. See the attached
Database11-HiTechCoach.accdb
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
João serras-pereiraAuthor Commented:
Ok. Got it and thanks

But I cannot find this control in my Active X controls. could only find the previous one. How do I do it?
0
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
But I cannot find this control in my Active X controls.
That is because it is not in the ActiveX list. It is a native control found on the Design Tab in the Controls group. Same place you would find he other native controls like Textbox, etc.  

To see the additional controls click the scroll down arrow on the right side of the Controls group.

I am currently not at a machine with Access 2013 installed so I can give you a screen shot.
0
João serras-pereiraAuthor Commented:
' got it!

Thanks a lot

Anyway its a bit cumbersome (actually, in the end, what I am really trying to do is to develop mock ups of web user interfaces

I fell that this approach does not really deliver what I want. I suppose that with 2013 WEB APPS I could do it, but then I need to change my license from current full office 2013 to Office 365.

I'll give a try and post a specific question on the matter if required..
0
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
what I am really trying to do is to develop mock ups of web user interfaces
I do web UIs also. Access does not come very close to what you can do with Web 2.0.  

AFAIK, to built Access web apps you will need a Sharepoint server.

I actually do it the other way around. I prototype Access UIs with Web pages.

If you will be building web apps then take a look at IronSpeed. ( http://ironspeed.com/ ).
0
João serras-pereiraAuthor Commented:
Thanks a lot!!!

I too a look at Ironspeed and it looks great. However is pricey ($250 USD/month and per seat...)

But I'll search for equivalent. I understand that, for instance Filemaker Pro does a nice job and a one time license is 500 USD... and I'll for alternatives as well.

Thanks again

Joao
0
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
Joao,

What will be your final platform (ASP/ASP.net, PHP, Perl, Java, etc)?

Whatever it is, I would recommend using a tool design to prototype for that platform.

Have your seen the free Visual Studio Express for Web here:  http://www.microsoft.com/visualstudio/eng/products/visual-studio-express-for-web

FWIW: IronSpeed will easily pay for itself with the first app you build with the time/cost saving.   I highly recommend trying the trial version
0
João serras-pereiraAuthor Commented:
well -

I have got Visual Studio 2012 fully licensed from my company. And I have extensively used the 2005 version for prototyping along with ChartFX and Syncfusion (but only its Windows forms part), then I moved out to another world but kept doing small things in ms/access which I found extremely convenient. But, since then, the world changed quite a lot and I moved to architecture.

Now I need to mock-up things; I am using Visual Paradigm's Agilian and they do have a mock-up for GUI design, but it is really too clumsy and the components have no behaviour at all so you never know if you are designing anything useful for the user; nowadays we need to play around a bit with the interface  to learn if it is useful at all for the user. This is why I thought that, by using MS/ACCESS 2013 custom web it could do the job. But again I am stuck with rebuying what I have bought (either I need SharePoint (?) or have an office 365 license to use it.

Definitely I will follow your recommendation for download and try IronSpeed but as I am not a developer anymore and I do not know which final platform will be, I think that it will not be the best solution for mock-ups, at least at that cost.

Maybe the solution would be to just use what I have (Visual Studio 2013) on its web part and try to learn how to use it...

joao
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Development Software

From novice to tech pro — start learning today.