isbn

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

zila - 24 Jul 2006 17:08 GMT

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

Reply to this Message

Jerry Whittle - 24 Jul 2006 17:27 GMT

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.

Signature

Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> 1. l failed to enter ISBN number in my form. For details;
> Field Name; ISBN number
[quoted text clipped - 12 lines]
>
> thank you

Reply to this Message

onedaywhen - 25 Jul 2006 12:40 GMT

> 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.

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.

--

Reply to this Message

Joan Wild - 24 Jul 2006 19:52 GMT

> 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?

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
[quoted text clipped - 3 lines]
> 4/12/2006 such as 4-dec-2006 automatically .l don't like to write
> month before day.

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.

Signature

Joan Wild
Microsoft Access MVP

Reply to this Message