Hello Forum Members:
I have many strSQl lines as follows:
~ ~ ~ ~ ~ ~ ~ ~
strSQL = "SELECT * FROM Declension where Preposition_I like " & strCriteria

I would like to find out whether a field has a value i.e. is it null.
What is the syntax to do that?
Samuel

I have a new database and I want to give the user a chance to exit the form
without the info they have entered into the controls being added to the
table.  There are 5 controls but when they select the exit button, anything
that they have entered still gets saved to the table.  ...

From: "CatQM" <CatQM@discussions.microsoft.com>
Subject: Time format: 0###
Date: Friday, January 18, 2008 10:10 AM
I have imported data into Access with 24 hr clock times (just numbers, no

I have 2 lookup tables - one for Cost Codes and the other for Expense Account
Numbers.  I have two combo boxes on the same form - cbxCostCodes and
cbxExpenseAccountNumber. Depending on what the user selects in the first
combo box (cbxCostCodes), then I want the second combo box

I am synchronising one access db with its master via the below code;
Dim dbSynch As DAO.Database
Set dbSynch = DBEngine(0).OpenDatabase(<path local>)
dbSynch.Synchronize <path remote>

There seems to be some problem between the replica master and its replicated
copies. What is the method to set the db back to normal and re-replicate?
Thanks
Regards

I am using Access 2003
I have a subform that lists employees by  name.  The data source for that
subform is from an "Index" table that lists all employees.  There are usually
a total of at least 14 employees in the Index, and every day a new entry is

Can someone please explain to me how to create a data entry form based on a
many to many relationship?  I know how to create the relationship but can't
figure out how to create the form to populate my tables.  I know how to
create a one to many relationship and display the many ...

The computer connects to the internet and my messengers connect but when i
pull up IE7 and type in an address the page comes up to connection error. How
do i fix this?

I am doing some experimenting and I am having problems displaying images with
a relative path. In the Northwind sample database (Access 2003), there is an
Employees table that has a field named Photo. The external photos are in the
same folder as the database so just the file ...

http://support.microsoft.com/kb/237377
The script in this example does not work. It will work with just one country
but that is it. The countries seperated by a ; does nothing. It will find
the first country in the semi-colon delimited list but the rest of the

I have Windows Vista and am having trouble opening e mail attachments in
Windows Mail. I am novice so any help would be appreciated.

I am using Access 2003. In the Northwind sample database, there is a table
named Categories and it has a field named Pictures. In Datasheet view, the
Picture field for all the records have the words "Bitmap image." Each record
has a different picture. I cannot figure out how to ...

Hi, I have two time fields within each record of the database. Is it possible
to interleave the times  from each recordso they are sequential.
e.g.
Record1, Time1 = 12.00 Time2 = 13.00 and Record2 Time1 = 12.30 Time2= 14.00