[AccessD] Access 2010 specialised form controls

Thu Mar 7 02:33:02 CST 2013

Hi Stephen:

Have you looked at the following. Have used this for a client's website a
while back as all it takes is an appropriate series of plot points to create
graphics of various kinds. It should be easy to call from your Access web
interface.

https://developers.google.com/chart/

Check it out as it might have something you could use and will make your
client happy.

Here is a simple example of a gauge web page call:

https://developers.google.com/chart/interactive/docs/gallery/gauge#Example

Just build the page from within Access as follows:

dim strWebpage as String

  Open "c:\webpages\yourCharthere.html " For Output As #1
  Write #1, "<html>"
  Write #1, "<head>"
  Write #1, <script type='text/javascript'
src='https://www.google.com/jsapi'></script>"          
  ...
  Write #1, "</body>"
  Write #1, "</html>"
  Close #1

...and then call the page using something like:

Application.FollowHyperlink "http://yourCharthere.html" or use the Shell()
or ShellExecute() command to call the page.

Example: ShellExecute("c:\webpages\yourCharthere.html")

HTH

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stephen Bond
Sent: Wednesday, March 06, 2013 11:01 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Access 2010 specialised form controls

I've just picked up a new client who run Access 2010 and have done a
'bit of their own' front-ending into a SQL Server b/e, embedding reports
on forms etc.   I'm to pick up this f/e and add features. 

A couple of questions:

1. I tried porting back their Access f/e to 2003 so I could do some
_real_ development, but the time taken to find all the things that
Access says prevent me from doing this just isn't worth it.  I tried for
a couple of hours, but gave up.   So ... get used to it?   Or not?
(that's a question)

2. They want a Sales figure to show graphically.   But the graphic they
want is akin to a speedo on a car, circular dial, and all that stuff.
I tried Googling but quite honestly I ran into cross-referencing
problems mixing car terminology with Access forms terminology.  Anybody
know of something?

MTIA

Stephen Bond 

Otatara, New Zealand 

DISTRESS (n.)  A disease incurred by exposure to the prosperity of a
friend.

-- Ambrose Bierce

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com