Max Wanadoo
max.wanadoo at gmail.com
Thu Mar 18 08:50:23 CDT 2010
Are you saying:-
A. mine doesn't
B. mine is 20th century too.
Co'mon now. Don't beat about the bush...out with it...
Answers:
A. Mine does UNCs better than yours. Stamps foot and sticks tongue out. So
there!
C. Mine adheres to the CRAB principle invented by yours truly (Clear,
Relevant, Accurate and Brief).
There we go...over and out....
Max
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert
Sent: Thursday, March 18, 2010 1:42 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] CurrentProject.Path syntax?
My function handles UNC paths from the get go. And UNCs are very much 20th
century. :-)
Lambert
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
Sent: Thursday, March 18, 2010 9:12 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] CurrentProject.Path syntax?
But the sample below works a lot better and handles UNC :
str = "\\svr\c\"
strL = Left(str, 2)
strR = Replace(Mid(str, 3) & "\", "\\", "\")
str = strL & strR
Go on. Be a Devil. Move to the 21st Century!!
Max
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert
Sent: Thursday, March 18, 2010 12:55 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] CurrentProject.Path syntax?
Good point from Stuart. I think I'll stick with my little function. :-)
Lambert
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
Sent: Wednesday, March 17, 2010 5:46 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] CurrentProject.Path syntax?
Bit more complicated.
str = "\\svr\c\"
strL = Left(str, 2)
strR = Replace(Mid(str, 3) & "\", "\\", "\")
str = strL & strR
Max
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Wednesday, March 17, 2010 9:07 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] CurrentProject.Path syntax?
And what happens when it is a UNC path?
Str = "\\Server\Share\"
:-(
--
Stuart
On 17 Mar 2010 at 15:49, Max Wanadoo wrote:
> Str = str & "\"
> Str = replace(str,"\\","\")
>
--
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
--
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
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com