Weird. I don't know where my signature goes.
----- Liz -----
;-)
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, October 08, 2015 9:07 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Doesn't allow longer digits in the number field
you're welcome, Kevin ;) happy to help
> "love the adding a negative number bit trick."
thanks, Liz ~
warm regards,
crystal
Do you have a song, poem, speech, story, photo, art, or other creative work about peace and love? Please, help the world by sharing your gifts ~
http://www.WakeUpHearts.com
~ have an awesome day ~
On 10/8/2015 9:07 AM, 'zhaoliqingoffice@163.com' zhaoliqingoffice@163.com [MS_Access_Professionals] wrote:
Crystal-
Such a relief. Thanks a lot.
Regards,
Kevin
Regards,
Kevin Zhao
Date: 2015-10-08 22:59
Subject: Re: [MS_AccessPros] Doesn't allow longer digits in the number field
Hi Kevin,
I would suggest using text if you run out of possibilities with Long Integer. While decimal can handle bigger numbers, VBA does not support that data type except with a variant.
To extend the AutoNumber possibilities ... when you start reaching the limit for positive numbers, use the negative numbers
Use an append query to add a record with value = -2,147,483,648 then compact and repair the database. This should make Access use the negative numbers automatically.
warm regards,
crystal
~ have an awesome dayOn 10/8/2015 8:12 AM, 'zhaoliqingoffice@163.com' zhaoliqingoffice@163.com [MS_Access_Professionals] wrote:
John-
What if the auto key number reach this limit? What do you normally do for handling this problem? As a tour company, we have many requests to send to the suppliers every day, I am afraid this limit will be reached in few years... Thanks.
Regards,
Kevin
From: John Viescas JohnV@msn.com [MS_Access_Professionals]
Date: 2015-10-08 22:05
Subject: Re: [MS_AccessPros] Doesn't allow longer digits in the number field
Yes.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Oct 8, 2015, at 3:59 PM, 'zhaoliqingoffice@163.com' zhaoliqingoffice@163.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
John-
Does this mean the largest auto key number is the same as 2,147,483,647? Thanks
Kevin
Regards,
Kevin Zhao
From: John Viescas JohnV@msn.com [MS_Access_Professionals]
Date: 2015-10-08 21:53
Subject: Re: [MS_AccessPros] Doesn't allow longer digits in the number field
Kevin-
The largest number you can store in a Long Integer is 2,147,483,647. If you need to store bigger integers, use Decimal.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Oct 8, 2015, at 3:38 PM, 'zhaoliqingoffice@163.com' zhaoliqingoffice@163.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Dear All,
I have a number filed in Long Integer. My problem is that this field doesn't allow me to input more than 10 digits. What I have to do? Thanks in advance.
Regards,
Kevin Zhao
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (12) |
Tidak ada komentar:
Posting Komentar