Rick Nelson
RickN at NelsonTech.com
Sat Sep 4 18:47:29 CDT 2010
Sorry, gang, but after all these years (mostly lurking) I've never figured
out how to reply cleanly here - so I apologize if this is scrambled...
Just in case you're asking about an RDP book because you want to run an
Access app remotely, there's an excellent book on Terminal Server that
covers things on RDP I would never have thought possible:
Terminal Services for Microsoft Windows Server 2003: Advanced Technical
Design Guide
http://www.amazon.com/Terminal-Services-Microsoft-Windows-Server/dp/09711510
40/ref=sr_1_4?s=books&ie=UTF8&qid=1283643145&sr=1-4
Brian Madden, the primary author, also has a web site:
http://www.brianmadden.com/ which I haven't used for a while but used to
have a lot of Term Services / RDP content. He's an excellent source of good
info.
I'm taking some time to post this info because we've found Term Server / RDP
to be an excellent way to provide remote access to complex Access apps, and
a great response to "it has to be a web app", which normally means they want
remote access. We have one mission-critical Access/SQL Server app with
about 100 users around the US that works great (in many ways better than the
Salesforce.com app it's linked to...). I've noticed than many Access
developers don't seem to be aware of this architecture - hopefully now a few
more are...
We've had clients using Citrix the same way; it's better but more expensive.
There's a ton of great technology in this space and some excellent ways to
deploy Access apps with the kind of UI's and functionality you rarely see in
a "real" (browser based) web app.
Good luck!
Rick Nelson
Nelson Technology Associates
Danville, CA USA
Message: 1
Date: Fri, 3 Sep 2010 13:29:27 -0500
From: Gary Kjos <garykjos at gmail.com>
Subject: Re: [AccessD] Windows Remote Desktop
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Message-ID:
<AANLkTi=aSUJb-0vmihatcTv05mWmgrv_ydiTDJ80PaGj at mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1
No book but Lots of info here.....
http://www.microsoft.com/windowsxp/using/mobility/getstarted/remoteintro.msp
x
http://windows.microsoft.com/en-US/windows-vista/Remote-Desktop-Connection-f
requently-asked-questions
GK
On Fri, Sep 3, 2010 at 6:20 AM, <Johncliviger at aol.com> wrote:
>
> Hi all
>
> Anyone found any literature (or even a book) on Windows XP or ?later
Remote
> Desktop?
>
> TIA
>
> john cliviger
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
--
Gary Kjos
garykjos at gmail.com
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
accessd-request at databaseadvisors.com
Sent: Saturday, September 04, 2010 10:00 AM
To: accessd at databaseadvisors.com
Subject: AccessD Digest, Vol 91, Issue 7
Send AccessD mailing list submissions to
accessd at databaseadvisors.com
To subscribe or unsubscribe via the World Wide Web, visit
http://databaseadvisors.com/mailman/listinfo/accessd
or, via email, send a message with subject or body 'help' to
accessd-request at databaseadvisors.com
You can reach the person managing the list at
accessd-owner at databaseadvisors.com
When replying, please edit your Subject line so it is more specific
than "Re: Contents of AccessD digest..."
Today's Topics:
1. Re: Windows Remote Desktop (Gary Kjos)
2. Friday Puzzler - Only Integers on X Axis on Graph (Brad Marks)
3. Re: Friday Puzzler - Only Integers on X Axis on Graph (Dan Waters)
4. Re: Friday Puzzler - Only Integers on X Axis on Graph (Brad Marks)
5. Re: Friday Puzzler - Only Integers on X Axis on Graph (Dan Waters)
6. OT Friday Experience: Rocket Science and submarines (Gustav Brock)
7. Re: OT Friday Experience: Rocket Science and submarines
(Stuart McLachlan)
8. Re: Windows Remote Desktop (Johncliviger at aol.com)
9. How to Change Access 2007 Chart Colors with VBA (Brad Marks)
10. Re: OT Friday Experience: Rocket Science and submarines
(Arthur Fuller)
11. Re: How to Change Access 2007 Chart Colors with VBA (Dan Waters)
12. Re: OT Friday Experience: Rocket Science and submarines
(Gustav Brock)
----------------------------------------------------------------------
Message: 1
Date: Fri, 3 Sep 2010 13:29:27 -0500
From: Gary Kjos <garykjos at gmail.com>
Subject: Re: [AccessD] Windows Remote Desktop
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Message-ID:
<AANLkTi=aSUJb-0vmihatcTv05mWmgrv_ydiTDJ80PaGj at mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1
No book but Lots of info here.....
http://www.microsoft.com/windowsxp/using/mobility/getstarted/remoteintro.msp
x
http://windows.microsoft.com/en-US/windows-vista/Remote-Desktop-Connection-f
requently-asked-questions
GK
On Fri, Sep 3, 2010 at 6:20 AM, <Johncliviger at aol.com> wrote:
>
> Hi all
>
> Anyone found any literature (or even a book) on Windows XP or ?later
Remote
> Desktop?
>
> TIA
>
> john cliviger
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
--
Gary Kjos
garykjos at gmail.com
------------------------------
Message: 2
Date: Fri, 3 Sep 2010 14:49:24 -0500
From: "Brad Marks" <BradM at blackforestltd.com>
Subject: [AccessD] Friday Puzzler - Only Integers on X Axis on Graph
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Message-ID:
<E9A6E8C998E16F4FB3D861390AFE32C5F708B3 at blkltd.blkfst2003.local>
Content-Type: text/plain; charset="us-ascii"
Is there a way force the scale of the X Axis of an Access 2007 graph to
only show integers.
The items that I would like to graph are always whole numbers. (1.5
parts is confusing)
Thanks,
Brad
------------------------------
Message: 3
Date: Fri, 3 Sep 2010 15:00:35 -0500
From: "Dan Waters" <df.waters at comcast.net>
Subject: Re: [AccessD] Friday Puzzler - Only Integers on X Axis on
Graph
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Message-ID: <692132B658F149829460F8AB5CBA83FF at danwaters>
Content-Type: text/plain; charset="us-ascii"
Hi Brad,
With the chart in Edit mode, right click on the axis, and select Chart
Options (I think). Then select the Axis tab, then uncheck Auto for the
Major interval, then enter the major interval that you want the axis to
display. It's very similar to Excel.
Dan
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Friday, September 03, 2010 2:49 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Friday Puzzler - Only Integers on X Axis on Graph
Is there a way force the scale of the X Axis of an Access 2007 graph to
only show integers.
The items that I would like to graph are always whole numbers. (1.5
parts is confusing)
Thanks,
Brad
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
------------------------------
Message: 4
Date: Fri, 3 Sep 2010 14:57:54 -0500
From: "Brad Marks" <BradM at blackforestltd.com>
Subject: Re: [AccessD] Friday Puzzler - Only Integers on X Axis on
Graph
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Message-ID:
<E9A6E8C998E16F4FB3D861390AFE32C5F708B6 at blkltd.blkfst2003.local>
Content-Type: text/plain; charset="us-ascii"
Dan,
Thanks for the tip - works great.
I appreciate the assistance.
Brad
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
Sent: Friday, September 03, 2010 3:01 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Friday Puzzler - Only Integers on X Axis on Graph
Hi Brad,
With the chart in Edit mode, right click on the axis, and select Chart
Options (I think). Then select the Axis tab, then uncheck Auto for the
Major interval, then enter the major interval that you want the axis to
display. It's very similar to Excel.
Dan
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Friday, September 03, 2010 2:49 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Friday Puzzler - Only Integers on X Axis on Graph
Is there a way force the scale of the X Axis of an Access 2007 graph to
only show integers.
The items that I would like to graph are always whole numbers. (1.5
parts is confusing)
Thanks,
Brad
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
------------------------------
Message: 5
Date: Fri, 3 Sep 2010 15:17:55 -0500
From: "Dan Waters" <df.waters at comcast.net>
Subject: Re: [AccessD] Friday Puzzler - Only Integers on X Axis on
Graph
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Message-ID: <EABB041B4CBA4555B5EC46C78DB69F36 at danwaters>
Content-Type: text/plain; charset="us-ascii"
Great!
I do like graphs in Access (MS Graph). Once you get the data source right,
the rest is a lot like making a chart/graph in Excel.
Dan
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Friday, September 03, 2010 2:58 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Friday Puzzler - Only Integers on X Axis on Graph
Dan,
Thanks for the tip - works great.
I appreciate the assistance.
Brad
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
Sent: Friday, September 03, 2010 3:01 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Friday Puzzler - Only Integers on X Axis on Graph
Hi Brad,
With the chart in Edit mode, right click on the axis, and select Chart
Options (I think). Then select the Axis tab, then uncheck Auto for the
Major interval, then enter the major interval that you want the axis to
display. It's very similar to Excel.
Dan
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Friday, September 03, 2010 2:49 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Friday Puzzler - Only Integers on X Axis on Graph
Is there a way force the scale of the X Axis of an Access 2007 graph to
only show integers.
The items that I would like to graph are always whole numbers. (1.5
parts is confusing)
Thanks,
Brad
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
------------------------------
Message: 6
Date: Sat, 04 Sep 2010 11:01:36 +0200
From: "Gustav Brock" <gustav at cactus.dk>
Subject: [AccessD] OT Friday Experience: Rocket Science and submarines
To: <accessd at databaseadvisors.com>
Message-ID: <sc822725.050 at cactus.dk>
Content-Type: text/plain; charset=US-ASCII
Hi all
As if it isn't enough to build your own spacecraft, these guys (previously)
built a submarine (which is not as easy as you may think). Nautilus it is
proudly named after the famous USS nuclear sub passing the North Pole years
back .
So, of course, this is now used for maneuvering the launch platform to the
launch area at a military area of the Baltic Sea:
http://www.copenhagensuborbitals.com/index.php
This first test flight planned to take place tomorrow, Sunday, aimed at
reaching an altitude of only 30 km will only carry a doll.
I must say I feel respect for such enthusiasm as all costs and labour are
carried by donations and volunteers.
By the way, the USS Nautilus was designated a National Historic Landmark and
is now settled at the Submarine Force Museum in Connecticut:
http://www.ussnautilus.org
/gustav
------------------------------
Message: 7
Date: Sat, 04 Sep 2010 19:23:30 +1000
From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
Subject: Re: [AccessD] OT Friday Experience: Rocket Science and
submarines
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Message-ID: <4C821012.32020.B770C2C at stuart.lexacorp.com.pg>
Content-Type: text/plain; charset=US-ASCII
Then of course there is The Register's PARIS (Paper Aircraft Released Into
Space) effort.
Also planned to reach 30Km.
http://www.theregister.co.uk/science/paris/
The PARIS mission includes two main components: the main payload and the
Vulture 1
aircraft.
The main payload is a styrofoambox containing video and stills cameras, GPS
tracker unit,
back-up beacon transmitter and the all-important Vulture 1 release
mechanism.
Vulture 1 - an all-paper aircraft - sits under the main payload, and both
are lifted by a helium-
filled meteorological balloon. At 20,000 metres, Vulture 1 is released to
fly to earth, tracked
by an onboard GPS radio system. The plane also carries a miniature stills
camera to record
its journey.
The main payload continues to ascend to around 30,000 metres, at which point
the balloon
bursts and the box descends by parachute.
Two tracking teams will follow and recover the main payload and Vulture 1.
The main
payload GPS transmits its location over the phone network. If that fails,
there's a back-up
beacon transmiting in morse.
Vulture 1's position is plotted live online via the OpenAPRS system. The
main payload also
offers live positional updates via a dedicated Google map.
On 4 Sep 2010 at 11:01, Gustav Brock wrote:
> Hi all
>
> As if it isn't enough to build your own spacecraft, these guys
> (previously) built a submarine (which is not as easy as you may
> think). Nautilus it is proudly named after the famous USS nuclear sub
> passing the North Pole years back .
>
> So, of course, this is now used for maneuvering the launch platform to
> the launch area at a military area of the Baltic Sea:
>
> http://www.copenhagensuborbitals.com/index.php
>
> This first test flight planned to take place tomorrow, Sunday, aimed
> at reaching an altitude of only 30 km will only carry a doll. I must
> say I feel respect for such enthusiasm as all costs and labour are
> carried by donations and volunteers.
>
> By the way, the USS Nautilus was designated a National Historic
> Landmark and is now settled at the Submarine Force Museum in
> Connecticut:
>
> http://www.ussnautilus.org
>
> /gustav
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
------------------------------
Message: 8
Date: Sat, 4 Sep 2010 05:54:56 EDT
From: Johncliviger at aol.com
Subject: Re: [AccessD] Windows Remote Desktop
To: accessd at databaseadvisors.com
Message-ID: <9dc2f.53520e3.39b37170 at aol.com>
Content-Type: text/plain; charset="US-ASCII"
In a message dated 03/09/2010 19:30:22 GMT Daylight Time,
garykjos at gmail.com writes:
http://windows.microsoft.com/en-US/windows-vista/Remote-Desktop-Connection-f
requently-asked-questions
Cheers GK
jc
------------------------------
Message: 9
Date: Sat, 4 Sep 2010 06:29:10 -0700
From: Brad Marks <brad.marks1 at gmail.com>
Subject: [AccessD] How to Change Access 2007 Chart Colors with VBA
To: accessd at databaseadvisors.com
Message-ID:
<AANLkTi=hwEGjKgDKXscfTFuHMfWYtc4ScwhGy7bpzz_h at mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1
All,
I would like to learn how to change various Chart attributes with VBA.
I set up a new chart (Report Design Tab / Insert Chart).
I can use the built-in tools to change the Chart colors manually.
I would like to learn how to change things via VBA code.
The report name is Report1. The chart name is Chart0.
I would like to start by leaning how to change the color of the "Chart
Area", the "Plot Area" and the "Data Series" with VBA code.
I have surfed the web trying to find an example, but no luck after many
tries.
An example of how to do this would be most appreciated.
Thanks,
Brad
------------------------------
Message: 10
Date: Sat, 4 Sep 2010 11:00:33 -0400
From: Arthur Fuller <fuller.artful at gmail.com>
Subject: Re: [AccessD] OT Friday Experience: Rocket Science and
submarines
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Message-ID:
<AANLkTikJPqUcNGh5L4fg=AeJSyXWxDWXJPCcOC8=m7E=@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1
IIRC, the first actual Nautilus was named after the sub in Jules Verne's
"20,000 Leagues Under the Sea.".
Arthur
On Sat, Sep 4, 2010 at 5:01 AM, Gustav Brock <gustav at cactus.dk> wrote:
> Hi all
>
> As if it isn't enough to build your own spacecraft, these guys
(previously)
> built a submarine (which is not as easy as you may think). Nautilus it is
> proudly named after the famous USS nuclear sub passing the North Pole
years
> back .
>
>
------------------------------
Message: 11
Date: Sat, 4 Sep 2010 10:52:46 -0500
From: "Dan Waters" <df.waters at comcast.net>
Subject: Re: [AccessD] How to Change Access 2007 Chart Colors with VBA
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Message-ID: <3FB35EB53A1F43CFB2F17E366B498907 at danwaters>
Content-Type: text/plain; charset="us-ascii"
Hi Brad,
I've never tried this myself, but I did a search on 'ms graph vba', and got
many promising hits.
Good Luck!
Dan
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Saturday, September 04, 2010 8:29 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] How to Change Access 2007 Chart Colors with VBA
All,
I would like to learn how to change various Chart attributes with VBA.
I set up a new chart (Report Design Tab / Insert Chart).
I can use the built-in tools to change the Chart colors manually.
I would like to learn how to change things via VBA code.
The report name is Report1. The chart name is Chart0.
I would like to start by leaning how to change the color of the "Chart
Area", the "Plot Area" and the "Data Series" with VBA code.
I have surfed the web trying to find an example, but no luck after many
tries.
An example of how to do this would be most appreciated.
Thanks,
Brad
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
------------------------------
Message: 12
Date: Sat, 04 Sep 2010 18:40:03 +0200
From: "Gustav Brock" <gustav at cactus.dk>
Subject: Re: [AccessD] OT Friday Experience: Rocket Science and
submarines
To: <accessd at databaseadvisors.com>
Message-ID: <sc8292a4.051 at cactus.dk>
Content-Type: text/plain; charset=US-ASCII
Hi Arthur
You are of course right. And so is the present mini sub - silly me, I could
just have browsed the homepage:
http://www.uc3nautilus.dk/
For some reason the Wikipedia page seems more up to date:
http://en.wikipedia.org/wiki/UC3_Nautilus
/gustav
>>> fuller.artful at gmail.com 04-09-2010 17:00 >>>
IIRC, the first actual Nautilus was named after the sub in Jules Verne's
"20,000 Leagues Under the Sea.".
Arthur
On Sat, Sep 4, 2010 at 5:01 AM, Gustav Brock <gustav at cactus.dk> wrote:
> Hi all
>
> As if it isn't enough to build your own spacecraft, these guys
(previously)
> built a submarine (which is not as easy as you may think). Nautilus it is
> proudly named after the famous USS nuclear sub passing the North Pole
years
> back .
------------------------------
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
End of AccessD Digest, Vol 91, Issue 7
**************************************