473,321 Members | 1,622 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,321 software developers and data experts.

Built-In Functions in Access?

Anyone know of a good specific source (other than a standard VBA book) with
lots of examples for using just the MS Access 2002 Built-In Functions? I
find the "Expression Builder" and the help files a little lacking and less
than comprehensive. Any sources or Web links would be highly appreciated.

Denny G.
Nov 12 '05 #1
9 6218
On Mon, 22 Sep 2003 22:41:50 GMT in comp.databases.ms-access, "Dennys
G." <gi******@adelphia.net> wrote:
Anyone know of a good specific source (other than a standard VBA book) with
lots of examples for using just the MS Access 2002 Built-In Functions? I
find the "Expression Builder" and the help files a little lacking and less
than comprehensive. Any sources or Web links would be highly appreciated.


The help file?

--
A)bort, R)etry, I)nfluence with large hammer.
Nov 12 '05 #2
Thanks, Trevor. Unfortunately, I do not think much of the "help file;" it is only a start. I am sure you have noticed, the Built-In Function (BIF) examples offered by many, even in this newsgroup and others, are far more complicated--better examples than what are available in the "help file." Additionally, in the help file, you have to know what you are looking for before you start wading through it. What I would like to see is a handy single desk source report that can be quickly scanned for a likely candidate. It would contain BIFs only; brief summary descriptions; and several, good, comprehensive examples for each BIF (possibly collected from newsgroups). Sounds like a good database project. If I do not find something like this, perhaps I will go ahead, prepare one myself, and make it available for others.



Denny G.

"Trevor Best" <bouncer@localhost> wrote in message news:cq********************************@4ax.com...
On Mon, 22 Sep 2003 22:41:50 GMT in comp.databases.ms-access, "Dennys
G." <gi******@adelphia.net> wrote:
Anyone know of a good specific source (other than a standard VBA book) with
lots of examples for using just the MS Access 2002 Built-In Functions? I
find the "Expression Builder" and the help files a little lacking and less
than comprehensive. Any sources or Web links would be highly appreciated.


The help file?

--
A)bort, R)etry, I)nfluence with large hammer.

Nov 12 '05 #3
> "Dennys G." <gi******@adelphia.net> wrote in message news:dgZbb.2673
$Y**********@news3.news.adelphia.net...
Thanks, Trevor. Unfortunately, I do not think much of the "help file;"
it is only a start. I am sure you have noticed, the Built-In Function (BIF)
examples offered by many, even in this newsgroup and others, are far
more complicated--better examples than what are available in the "help file."
Additionally, in the help file, you have to know what you are looking for
before you start wading through it. What I would like to see is a handy
single desk source report that can be quickly scanned for a likely candidate.
It would contain BIFs only; brief summary descriptions; and several, good,
comprehensive examples for each BIF (possibly collected from newsgroups).
Sounds like a good database project. If I do not find something like this,
perhaps I will go ahead, prepare one myself, and make it available for others.


Denny G.

The Expression builder does a pretty good job of this. All of the functions listed by
category and instant help on the one where the cursor is positioned. (at least in
Access 97).

Nov 12 '05 #4
Rick, thanks. I'm also familiar with the "expression builder (EB)." Here
is the problem with the EB: For someone new to MS Access, it hard for him
to envision that this: "DCount («expr», «domain», «criteria»)" from the EB
really means this: DCount("*", "Offers", "([OfferDate] >= #" & strDate1 &
"#) AND (#" &> strDate2 & "# >= [OfferDate])").

Denny G.


My experience is if you've never built an expression for a built-in
function, it is a little hard
"Rick Brandt" <RB*****@Hunter.Com> wrote in message
news:bk************@ID-98015.news.uni-berlin.de...
"Dennys G." <gi******@adelphia.net> wrote in message news:dgZbb.2673
$Y**********@news3.news.adelphia.net...
Thanks, Trevor. Unfortunately, I do not think much of the "help file;"
it is only a start. I am sure you have noticed, the Built-In Function (BIF) examples offered by many, even in this newsgroup and others, are far
more complicated--better examples than what are available in the "help file." Additionally, in the help file, you have to know what you are looking for before you start wading through it. What I would like to see is a handy
single desk source report that can be quickly scanned for a likely candidate. It would contain BIFs only; brief summary descriptions; and several, good, comprehensive examples for each BIF (possibly collected from newsgroups). Sounds like a good database project. If I do not find something like this, perhaps I will go ahead, prepare one myself, and make it available for
others.
Denny G.

The Expression builder does a pretty good job of this. All of the functions listed by category and instant help on the one where the cursor is positioned. (at least in Access 97).

Nov 12 '05 #5
In (EB) single click the DCount function then click on the HELP button on
the (EB) dialog box. This will show the Help file listing for DCount.

"Dennys G." <gi******@adelphia.net> wrote in message
news:YZ********************@news3.news.adelphia.ne t...
Rick, thanks. I'm also familiar with the "expression builder (EB)." Here
is the problem with the EB: For someone new to MS Access, it hard for him
to envision that this: "DCount («expr», «domain», «criteria»)" from the EB
really means this: DCount("*", "Offers", "([OfferDate] >= #" & strDate1 & "#) AND (#" &> strDate2 & "# >= [OfferDate])").

Denny G.


My experience is if you've never built an expression for a built-in
function, it is a little hard
"Rick Brandt" <RB*****@Hunter.Com> wrote in message
news:bk************@ID-98015.news.uni-berlin.de...
"Dennys G." <gi******@adelphia.net> wrote in message news:dgZbb.2673
$Y**********@news3.news.adelphia.net...
Thanks, Trevor. Unfortunately, I do not think much of the "help file;" it is only a start. I am sure you have noticed, the Built-In Function (BIF) examples offered by many, even in this newsgroup and others, are far
more complicated--better examples than what are available in the "help file." Additionally, in the help file, you have to know what you are looking for before you start wading through it. What I would like to see is a handy single desk source report that can be quickly scanned for a likely candidate. It would contain BIFs only; brief summary descriptions; and several, good, comprehensive examples for each BIF (possibly collected from newsgroups). Sounds like a good database project. If I do not find something like this, perhaps I will go ahead, prepare one myself, and make it available for

others.

Denny G.

The Expression builder does a pretty good job of this. All of the

functions listed by
category and instant help on the one where the cursor is positioned. (at

least in
Access 97).


Nov 12 '05 #6
rkc

"Dennys G." <gi******@adelphia.net> wrote in message
news:YZ********************@news3.news.adelphia.ne t...
Rick, thanks. I'm also familiar with the "expression builder (EB)." Here
is the problem with the EB: For someone new to MS Access, it hard for him
to envision that this: "DCount («expr», «domain», «criteria»)" from the EB
really means this: DCount("*", "Offers", "([OfferDate] >= #" & strDate1 & "#) AND (#" &> strDate2 & "# >= [OfferDate])").


There's also the object browser. Load up the VBA Library, browse, and
hit F1 when you want details.

You said you didn't want a book, but VB &VBA In a Nutshell from O'Reilly
is exactly what you are looking for.

Take a look here:

http://safari.oreilly.com/?XmlId=1-56592-358-8
Nov 12 '05 #7
"Dennys G." <gi******@adelphia.net> wrote in news:dgZbb.2673$YO5.2362837
@news3.news.adelphia.net:
Thanks, Trevor. Unfortunately, I do not think much of the "help file;" it
is only a start. I am sure you have noticed, the Built-In Function (BIF)
examples offered by many, even in this newsgroup and others, are far more
complicated--better examples than what are available in the "help file."


Gee, I never noticed that.

--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)
Nov 12 '05 #8
Thanks, rkc. Sounds as though this book may be just what I want. I have
many books, but only one of O'Reilly's named "Access Cookbook." I shall
investigate your suggestion further.

Denny G.

"rkc" <rk*@yabba.dabba.do.rochester.rr.com> wrote in message
news:4E****************@twister.nyroc.rr.com...

"Dennys G." <gi******@adelphia.net> wrote in message
news:YZ********************@news3.news.adelphia.ne t...
Rick, thanks. I'm also familiar with the "expression builder (EB)." Here is the problem with the EB: For someone new to MS Access, it hard for him to envision that this: "DCount («expr», «domain», «criteria»)" from the EB really means this: DCount("*", "Offers", "([OfferDate] >= #" &
strDate1 &
"#) AND (#" &> strDate2 & "# >= [OfferDate])").


There's also the object browser. Load up the VBA Library, browse, and
hit F1 when you want details.

You said you didn't want a book, but VB &VBA In a Nutshell from O'Reilly
is exactly what you are looking for.

Take a look here:

http://safari.oreilly.com/?XmlId=1-56592-358-8

Nov 12 '05 #9
Thanks Paii. I have done what you are suggesting. The help file is OK, but
not quite comprehensive enough for what I had in mind.

Denny G.
"paii" <pa**@packairinc.com> wrote in message
news:vn************@corp.supernews.com...
In (EB) single click the DCount function then click on the HELP button on
the (EB) dialog box. This will show the Help file listing for DCount.

"Dennys G." <gi******@adelphia.net> wrote in message
news:YZ********************@news3.news.adelphia.ne t...
Rick, thanks. I'm also familiar with the "expression builder (EB)." Here
is the problem with the EB: For someone new to MS Access, it hard for him to envision that this: "DCount («expr», «domain», «criteria»)" from the EB really means this: DCount("*", "Offers", "([OfferDate] >= #" & strDate1
&
"#) AND (#" &> strDate2 & "# >= [OfferDate])").

Denny G.


My experience is if you've never built an expression for a built-in
function, it is a little hard
"Rick Brandt" <RB*****@Hunter.Com> wrote in message
news:bk************@ID-98015.news.uni-berlin.de...
> "Dennys G." <gi******@adelphia.net> wrote in message news:dgZbb.2673
> $Y**********@news3.news.adelphia.net...
> Thanks, Trevor. Unfortunately, I do not think much of the "help

file;" > it is only a start. I am sure you have noticed, the Built-In
Function (BIF)
> examples offered by many, even in this newsgroup and others, are far
> more complicated--better examples than what are available in the
"help file."
> Additionally, in the help file, you have to know what you are
looking for
> before you start wading through it. What I would like to see is a handy > single desk source report that can be quickly scanned for a likely

candidate.
> It would contain BIFs only; brief summary descriptions; and several,

good,
> comprehensive examples for each BIF (possibly collected from

newsgroups).
> Sounds like a good database project. If I do not find something

like this,
> perhaps I will go ahead, prepare one myself, and make it available
for others.

Denny G.

The Expression builder does a pretty good job of this. All of the

functions listed by
category and instant help on the one where the cursor is positioned.
(at least in
Access 97).



Nov 12 '05 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: JimmyT | last post by:
I just configured and installed 2.3.4 and noticed there is no datetime module. I noticed there is a datetimemodule.c file that did not get built (ie no object file). Is there something I need to...
1
by: Alex Elbert | last post by:
Hi I have built dynamic HTMLTable. Now I want to attach it directly to the Email Body - it is already built, so why not to use a ready table. However, I cannot find the way of getting plain HTML...
0
by: Andrew Crook | last post by:
does MYSQL have a quota built into it! I need it limit the size of each database AndiC
1
by: Mark | last post by:
Is there a way to execute a statement that is built dynamically by a .NET application. For example I have a loop that is reading values from a database and I want to do something like the...
4
by: Yasutaka Ito | last post by:
Hi, Is there a way to determine which version of .NET Framework any given assembly is built with? thanks! -Yasutaka
1
by: William | last post by:
Looking for a pre built dotnet corporate or small business website template.
1
by: William | last post by:
Looking for a pre built dot net website for consulting business. I am trying to put up a quick business web for a dot net frame work. I have a provider already. I am trying to save time. Any...
1
by: Daniel | last post by:
is there any way to get to a unique build verion of an assembly at runtime? e.g. a version that is unique to the time that the assembly was built?
48
by: meyer | last post by:
Hi everyone, which compiler will Python 2.5 on Windows (Intel) be built with? I notice that Python 2.4 apparently has been built with the VS2003 toolkit compiler, and I read a post from Scott...
3
by: drewj840 | last post by:
I built a Windows service that sweeps a set of folders every 60 seconds and puts the files into a SQL Server database. I am creating a second service that will delete this set of folders and recreate...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.