In a query I wrote the following in the 'Criteria' of a field called 'School':
 [Enter School name or leave blank for all] Or Is Not Null
At first this worked & gave me the information on all of the Schools if the
user left the 'enter parameter' box blank.

I need to find out what key stage pupils are at by reference to their
date of birth and it's got me stumped.
The key stages are in years running from 1st September to the
following 31st August and for example a child at key stage 1 will be 5

I would like to change the personel data about myself, but I can't figure out
how to get back to it.

I want to have my form set to sort by a particular field each time it opens.  
My reference book says to use Order by property in the table and
OrderByProperty in the form.  
Problem is book doesn't say how to use the Order by property and I can't

I'm trying to use a parameter query to show records which contain a specific
keyword - When I run the parameter query no records are selected.  The field
which I am querying is a memo field which contains a list of keywords.  Could
my problem lie with the format of the text in ...

Help...
I want to use one form to enter data into 2 tables.
One table called Car1
One called car 2

My multiple column combo-box in a form is based on a 10 column select query.  
In form view, the combo-box only returns 1 column.  How can I make it show
all 10?

I have text box with code in the after_update event.  The code is very
simple
   [txtWeekDay] = "Testing this event"
My problem is that if the form is set to AllowAdditions = False, then

Can someone explain to me what this message means and what causes it? It
seems to happen when I try to set focus to a control. This is on a form that
navigates among reords and allows adding new records.

How would I add a jpeg image into access for a splash screen?

I have a field with numbers like 12122000.  I need to format this into the
date format mm/dd/yyyy, 12/12/2000.  What is the best way to accomplish this?

Am relatively new to access, and am trying to set up an artifacts database
and I need to have several drop down menus involved - any advice will be
muchly appreciated hx

I would like to set up on my motor enthusiasts site, a free database for
users to add details for their vehicles for sale as in typical (obviously
very expensive) car classified type (user:enters own info/photo, search
make/model etc....)databases.  Before I embark on a huge ...

I am running a query based on dates.  I am using the between and operant.  My
problem is that the query does not include the end date.  If I put in
7/1/05-7/31/05, I only get the information up to 7/30/05.  How do I get the
query to include the end date?

Am I able to use access as a database  for my website.