Friday, September 17, 2004
Functions With Names Beginning With S
Of the VBA functions with names beginning with the letter 'S', there are two which are blocked in 'sandbox' mode, and two which raised an 'undefined function' error when used in a query within the Microsoft Access environment.
The two functions that are blocked in 'sandbox' mode are 'seek' and 'shell'. The two that failed with 'undefined function' errors are 'Spc' and 'Split'. It is no surprise that these two failed, as the Spc function is intended for use with the VBA 'Print' statement, and the Split function returns an array.
The remaining functions with names that begin with the letter 'S' and executed without error in a query executed within the Microsoft Access environment are: Second, Sgn, Sin, SLN, Space, Sqr, Str, Str$, StrComp, StrConv, StrReverse, String, String$, Switch, and SYD.
Here's the SQL for the query I used to test these functions within the Microsoft Access environment:
SELECT Second([TestDate]) AS TestSecond, Sgn([TestInteger]) AS TestSgn, Sin([TestDouble]) AS TestSin, SLN([TestDouble],[TestDouble]/10,[TestLong]) AS TestSLN, Space([TestLong]) & "|" AS TestSpace, Sqr(Abs([TestDouble])) AS TestSqr, Str([TestDouble]) AS TestStr, Str$([TestDouble]) AS TestStrS, StrComp([TestText],"m") AS TestStrComp, StrConv([TestText],1) AS TestStrConv, StrReverse([TestText]) AS TestStrReverse, String([TestLong],[TestText]) AS TestString, String$([TestLong],[TestText]) AS TestStringS, Switch([TestInteger]>0,"Positive", [TestInteger]<0,"Negative", [TestInteger]=0,"Zero", [TestInteger] Is Null,"Null") AS TestSwitch, SYD([TestDouble],[TestDouble]/10,[TestLong],[TestLong]\2) AS TestSYD FROM tblTest WITH OWNERACCESS OPTION;
Just one function, the StrReverse function, failed when the query was executed outside of the Microsoft Access environment, via our C# JetTest utility (see earlier posts). The removal of that column enabled the query to execute without error via JetTest also. So we can now add the following functions to our list of VBA functions that can be used in Jet queries executed outside of the Microsoft Access environment:
Second, Sgn, Sin, SLN, Space, Sqr, Str, Str$, StrComp, StrConv, String, String$, Switch, and SYD.
Send feedback on this post to (change the obvious):
bwnnfb at hotmail dot com
(For the insatiably curious, "bwnnfb" is an acronym for "Blog With No Name Feed-Back")
Copyright © 2004 Brendan Reynolds. All rights reserved.
I found your contact info through a post you made on the MS’s Office discussion board. I was hoping you could perhaps offer some wisdom. I am not much of a computer tech person, however, I need to create a simple database for my company. I already have the forms and tables made and am interested in figuring out how I can post these forms on some sort of website so that our employees can access them and input and view live data. We do not have a server; our employees across the nation make use of Sharepoint and we all use the internet as a sort of server for sharing documents and the like. I was hoping you could explain a little more about the options you outlined in your post below:
Subject: Re: Online Collaboration, Input, & Editing
10/14/2004 5:18 AM PST
There are many ways to provide users with remote access to data in a Jet
(MDB) database, but the only method I know of that uses your existing Access
forms is Terminal Services. Other methods, including Sharepoint, ASP,
ASP.NET, ColdFusion and others, involve creating a new interface to your Jet
database. Even data access pages, which can be created with Access, involve
the creation of a new interface if your Access application is not already
If you could just explain what I need to do in order to get my simple Access form available for everyone to view and input information into our database, it would be very much appreciated.
Thank you for your time and I hope to hear from you soon.
Call this number now 24 hours a day 7 days a week (413) 208-3069
Get these Degrees NOW!!!
"BA", "BSc", "MA", "MSc", "MBA", "PHD",
Get everything within 2 weeks.
100% verifiable, this is a real deal
Act now you owe it to your future.
(413) 208-3069 call now 24 hours a day, 7 days a week.
My website: Www.pikavippii.com
Feel free to surf to my blog post :: weight loss forum
see a nice weblog like this one nowadays..
My weblog signs and symptoms of rheumatoid arthritis
Also visit my blog; Dental Implant Costs
I most certainly will recommend this site!
Feel free to surf to my homepage: cheap dental implants
to date every day.
Feel free to surf to my web site; http://www.thiguten.de/sixo-forum/profile.php?mode=viewprofile&u=115892
bookmarking for revisiting. I surprise how a lot effort you set to make this type
of fantastic informative web site.
Feel free to visit my website root canal
Feel free to visit my blog cost of dental implant
[url=http://www.timhelmen.com/]Replica Oakley Sunglasses[/url] The sight of the dead body scared him stiff.He paused for a reply. I love you!They employed him as a consultant.Love me love my dog.Ice cream is popular among children.Ice cream is popular among children.Control yourself!He is in his everyday clothes.Tom's birthday is this week
[url=http://www.premiumcorporateawards.com/]Fake Oakley Sunglasses[/url] The price includes postage charges.I'll see to it. He can hardly speak.Nothing but death can part the couple.This pen doesn't write well.He usually drops in at my place on his way home.He usually drops in at my place on his way home.I meet the boss himself.I'm very proud of you.Betty and Susan are talking on the telephone.
petty hat | petty hat| petty hat