Below is the code, but basically the code snippet compares a server
and local version of the database....  Note that the user has neither
the server or local versions of the database open when this code is
executed; it is executed from a third, separate database file that

When I enter 01/02/2006 the system assumes that it means 02/Jan/2006 only
when I enter 22/06/2006 the system reads dd/mm/yyyy.
How can I make sure it reads the day first regardless
Thank you,

If I state in my VB:
Dim blah DAO.Database, does that make it a DAO Database, or is it DAO
anyway?
Stapes

Please could someone take the time to answer a few beginners
questions.
I'm a teacher with responsibility for monitoring our school's progress
nationally and reporting to parents on their child's attainment.

Here's a tough one:
For the US among others the decimal symbol is a dot. Many countries, mine
with them, is using a comma instead. Now, when performing an SQL query with
a decimal number as an argument with the decimal symbol being a comma, the

I have a query that has the fields; ID, DATE and QUANTITY all from
same table. What I want to do is to display the total for each ID when
I run the query i.e. what I have currently is
ID          DATE          QUANTITY

I want to enter the year in a number field as 07, but it displays as 7. I
tried putting the format 00, which does what I want in Excel, but it doesn't
do it in Acess when I switch to datasheet view.
Can someone help?

I am trying to create a Booking System for a client renting a number
of cottages.
I have three Tables:
1. Diary Dates.

I created a combo box in a form that shows records with 2 fields  but when I
choose the record, only 1 field is chosen to fill the box.   What am I
missing to choose the record and have both fields fill the box so when I
print it, all info is there?

I want to display the contents of a memo field on a form based on the users
selection on three selections.  The problem I am running into is that there
is no "row source" or "row source type" for me to put the select statement in
for a memo field in the properties section.  If I ...

I have a form that has a field that is a drop down with 5 values in it.  Is
it possible to lock the field from update if they select one of the values,
but leave it open for update if they select the other 4?  
Ex:

I want to create an Evaluation database for employees based on their numbers
of courses and rating (annul evaluation). Can any body give me a website or
idea about it?
Your help is highly appreciated

I have a datasheet with a list of sales numbers and multiple invoice
dates (stored as text) for each sales number (there are duplicate
sales numbers, and distinct invoice dates). I need to compress the
list so I have only one (any one) invoice date for each sales order.

I am linking to a Lotus Approach (dbf) file that contains fields with
the ½ character.  The font used in Lotus Approach is simply the Arial
font.  Nothing special.  However, in Access, the ½ character displays
as ╜.  Interestingly enough, the ½ character can be created using ALT

I have a 3 y/o Dell running XP and I run an Access97 database.  Recently
upgraded the memory on the Dell from the factory 256 to add a 512 from
Kingston based on the memory configurator from Dell (and verified my findings
using tigerdirect's memory configurator).  All tools and ...