From a form I want to check a date field in a table to see if there is a date
there.  I'm using the following code.  I'm confident of the null check but
I'm not sure about the empty string.  It seems like it should be ## instead
of "", but the compiler expects an expression when ...

Im using db.queryDefs(x).Fields.count and db.queryDefs(x).Fields(x).Name to
return information on fields within database queries.
It seems to only be able to "see" the fields in Select and Crosstab queries.
The queryDef object can not "see into" Make Table, Update or Append queries

When using AddNew in DAO to add a new record to a Recordset it remains the
last record although the table is indexed and if the table is opened the new
record is positioned correctly.

I'm trying to install a Access 2002 Runtime db on a Office XP sp2 pc. I 'm
useing the Access package wizard to create the setup file and it works fine
on other pc's.
The error message is "The Office system Pack cannot be installed on this

I am really stuck and have gone around in ciricles.
I have code which once a button is clicked will request the user to select a
folder.
What I cannot work out is how to add the path to a string but only from the

The problem is that combos within one of the forms stoped doing search for
existing data, but the data is visible within the combo list.  When you type,
it just doesn't give you marked on screen alphabetically next close to it
line.

What is the equivalent ADO code to open the ODBC dialog which allows a user
to  select or create and then select the DSN of an ODBC data source.
In earlier versions of Access, using DAO the following code is used.
public function fnGetODBCConnect () as string

I have a field in my table called "Web Site" with a data type of Hyperlink for
the purpose of storing and opening web pages from my customer form.  On my
form when I click a web site that has been entered into this field nothing
happens.

Access 2003 issue......
My current form has a field that makes a calculation based on the value of
another field, multiplies it by a fixed number and displays the results in
currency.  Basically - # of hours times an hourly rate = total dollar amount.

I am getting the following error:
Run time Error 13
Type Mismatch
When I use this function in a query.

I absolutely KNOW I saw something here only a couple days ago, a command you
can insert into a VBA procedure that will release control to the system so it
can finish whatever you've told it to do up to that point, rather than going
immediately on to the next line of your code.  I ...

Hey!!
Right, i have a SendObject button that opens up an email that wilol be sent
to my client.  (Its a confirmation voucher of their booking)
Anyway, so i have two questions:

In Access, how do I open word docs in order to populate a table (in a db)
with the contents of specific cells, contained in a table in the word docs?
There would be multiple files, of same format, contained in a specific
folder. All docs in that folder will have the contents of ...

Some unknown person has an Access program open, preventing me from installing
new changes.  How can I kill their session so I can install something?
EarlCPhillips
Volunteer Ex-Mainframe Programmer

I'm using the following code to create a DSNLessLink to several tables in my
SQL 2005 DB.  I have 2 UID's in the SQL 2005 DB, and I want to link the files
initially to the Read Only ID, and when I want to add a particular routine, I
want to relink the tables to the Read Write ID ...