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:

    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, 
        [TestInteger] Is Null,"Null") AS TestSwitch, 
    SYD([TestDouble],[TestDouble]/10,[TestLong],[TestLong]\2) AS TestSYD
FROM tblTest

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):

Brendan Reynolds
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.

Mr. Reynolds;

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


Brendan Reynolds


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
using them.

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.

Michelle Abogado
I read over your blog, and i found it inquisitive, you may find My Blog interesting. My blog is just about my day to day life, as a park ranger. So please Click Here To Read My Blog
I read over your blog, and i found it inquisitive, you may find My Blog interesting. So please Click Here To Read My Blog
Get any Desired College Degree, In less then 2 weeks.

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.
Hi there to all, it's genuinely a fastidious for me to pay a visit this web page, it includes valuable Information.

My website:
What's up, its fastidious piece of writing regarding media print, we all understand media is a impressive source of information.

Feel free to surf to my blog post :: weight loss forum
I'm really impressed together with your writing abilities and also with the layout for your blog. Is this a paid subject or did you customize it yourself? Anyway keep up the nice quality writing, it's uncommon to
see a nice weblog like this one nowadays..

My weblog signs and symptoms of rheumatoid arthritis
Thankfulness to my father who informed me concerning this webpage, this website is really awesome.

Also visit my blog; Dental Implant Costs
You ought to be a part of a contest for one of the greatest sites on the net.
I most certainly will recommend this site!

Feel free to surf to my homepage: cheap dental implants
If some one desires to be updated with most up-to-date technologies therefore he must be visit this site and be up
to date every day.

Feel free to surf to my web site;
I have learn a few good stuff here. Certainly price
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
Fastidious answers in return of this difficulty with real arguments and describing the whole thing on the topic of that.

Feel free to visit my blog cost of dental implant
[url=]Replica Oakley Sunglasses[/url] We've got to do something about the neighbor's dog!Don't cry over spilt milk.Lying and stealing are immoral. Is it okay to smoke in the office?I love this game.No wonder you can't sleep when you eat so much.No wonder you can't sleep when you eat so much.He has a sense of humor.I'm not sure I can do it.I really think a little exercise would do you good.

[url=]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=]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.
The petty hat is 100% brushed cotton with our unique design the front.This light soft hat can be packed away easily making it the ideal hat for vacation travel and all times when you want to keep the sun off of your beautiful face
petty hat | petty hat| petty hat
Keep it up!
Post a Comment

<< Home

This page is powered by Blogger. Isn't yours?