Error Message: Function isn't available in expressions in query expression.
I have run into this issue in a couple old applications created in Access
97, and each query uses the Date() function. One query is as simple "Select *
From MemberEvents Where [begindate]<(Date()-90)".  ...

I have recently upgraded from Office 2000 Devloper to Visual Studio Tools for
MS Office 2003 and I am missing some thing basic in the operation of the
Package Wizard.  In the old Office 2000 Developer, dependant controls and
libraries were automatically included and registered ...

I have written a small app which helps with producing invoices and
shipping documentation for Ebay.  I can package this up as an MDE but I
am going to want to make changes to the table structures in the future,
both new tables and new fields on existing tables.

In my company we use differents versions of Office 2003, 2002 SP3,..
and I would like to use web service reference in my projects.
I installed Microsoft Office XP Web Services Toolkit 2.0 and Soap
Toolkit 2.0 . And the option 'Web Reference' appears under Reference

I would like to create a small program for switch my WEP key each day.
(or each hour, minute, ... following my variable)
It is a personnal project, I think that it is a good idea, but I would
like more information about it because I don't know how I must to

I've noticed there is no Dev. Toolkit for Access2003.  Are there plans to
phase Access out and replace it with another app?
-Larry

I have a situation were I'd like to install the runtime components and a
shortcut on the desktop that refers to an already existing mdb on the group
server.
I've been toying around with Orca but I'm not smart enough to figure out

after creating the vb package and including the access db file, i
wanted to check that if i remove the access db file from its source,
would it affect execution of the packaged application. i can clearly
see the access file in the package folder but, the application gives an

I was told that with the 2003 ADE one could use the package or setup wizard
to "turn off or hide" the access application window. Does anyone know if this
is true and where in the ade is this set. I know that mvp has code but it
requires too much attention when showing forms ...

I'm going to be distributing an Access application that I created with
Access 2003.  Some of my clients are still running Windows 98.  How can I
create a version that will work on those machines?  Can I simply include an
older version of the Access Runtime (where do I get one if ...

I keep getting the above error message when trying to run actions on my DB
in MS Access. I am using the VBA code editor to create the code and one
example is listed below.
If anyone has any idea what I am doing wrong I would welcome some help

I know about MSKB article 837150 "You may get error message when you install
an Access 2002 runtime deployment package on a computer that is running
Windows XP SP2 or Windows Server 2003"
The workaround for this is to remove a line from Ospfilelist.txt in the

not sure if this is the right place to post this, but hopefully someone
sees it who can help.
I would like to track the users of a database I have. To do this, I
have a function which finds their net id, and i would like to run this

I cannot locate the Setup.exe file, or the other MSI files,  so I can cache
the install files for a selected language. I have installed Access Developer
Extensions twice, read all the KB and other articles I can find. My Access
2003 was installed from MSDN Office Professional ...

Hello,
I have been using access for a while but have never used VBA.  I am very
interested in learning this programming language and was wondering if anyone
could direct me to a good starting point, (books, websites, articles, etc.).