isbn

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

1. l failed to enter ISBN number in my form. For details;
Field Name; ISBN number
Data type : Number
Field Size;Long Integer
Decimal places: Auto
Note; please tell me what should l do?

2. l'm using short date .when l enter 11/12/2006 it changes to 12- Nov-2006
but if l enter 23/12/2006 it's o.k (23-Dec-2006).l realise that all numbers
below than 12 give me headache for example 4/12/2006 will change to
12-apr-2004 or 3/5/2006 will change to 5-mar-2006. What should l do to
get input
4/12/2006 such as 4-dec-2006 automatically .l don't like to write month
before day.

thank you
 
1. I don't understand the question.

2. Access tries to guess dates when you enter them. As there is no 23rd
month, but a 12th month, Access guess correctly when you enter 23/12/2006.

However if the date can be interpreted more than one way, Access defaults to
the ANSII standard where A is for American. Therefore Access, and SQL, perfer
the MM/DD/YYYY format.

There's not much you can do except for put in the MM/DD/YYYY format; spell
out the month like "4-dec-2006", or use the YYYYMMDD format such as 20061204
which Access and SQL both like.
 
zila said:
1. l failed to enter ISBN number in my form. For details;
Field Name; ISBN number
Data type : Number
Field Size;Long Integer
Decimal places: Auto
Note; please tell me what should l do?
Click to expand...

You don't indicate what the problem is, however a ISBN # isn't really a
number. Make it a text field instead.
2. l'm using short date .when l enter 11/12/2006 it changes to 12-
Nov-2006 but if l enter 23/12/2006 it's o.k (23-Dec-2006).l realise
that all numbers below than 12 give me headache for example 4/12/2006
will change to 12-apr-2004 or 3/5/2006 will change to 5-mar-2006.
What should l do to get input
4/12/2006 such as 4-dec-2006 automatically .l don't like to write
month before day.
Click to expand...

Access uses the short date format as specified in the Regional Settings of
Control Panel on the computer. It is likely that your computer is set to
mm/dd/yyyy and therefore 11/12/2006 is indeed Nov 12, 2006. 23/12/2006 -
well that doesn't conform to the Regional settings as there is no 23rd
month.

So Access is being 'helpful' and spins around your entry until it does find
a valid date - in this case Dec 23, 2006.

If you prefer to enter dates as dd/mm/yyyy then change this setting in the
Control Panel. Note that this will affect all programs where you enter a
date. The format you've chosen is good, as it shows an unambiguous format
and you can tell right away whether your entry has been interpreted as you
meant.
 
Jerry said:
There's not much you can do except for put in the MM/DD/YYYY format; spell
out the month like "4-dec-2006", or use the YYYYMMDD format such as 20061204
which Access and SQL both like.
Click to expand...

You can use the ISO 8601 format yyyy-mm-dd. Access likes to muck about
with the dates and makes them 'US format', in which case they can be
text literals e.g.

CDATE('2006-12-04')

Jamie.

--
 
Back
Top