A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

negative autonumber



 
 
Thread Tools Display Modes
  #1  
Old July 29th, 2004, 09:33 PM
external usenet poster
 
Posts: n/a
Default negative autonumber

I have an ID field set to autonumber.
The table has a primary key combined of three other fields, ID is not one of
them
The table is being populated via a form where the ID filed is filled
automatically.

I have been adding records for several days and everything was OK untill
today I noticed, that all the records I added today have been assigned the
same negative ID -02
And even one of the records I enetered time ago, changed its ID to -2

What is going on and how do I fix it?

a


Ads
  #2  
Old July 30th, 2004, 02:47 AM
Laurie Eaton
external usenet poster
 
Posts: n/a
Default negative autonumber

Hi aa,

It a long shot - but try expanding the width of that column in your view, since the presentation of numbers changes when the width is too small and the '2' may be coming from 1E+02 when you have more than 100 entries. You mention the number is negative which does not align with this theory, but I suggest check it anyway.

Regards - laurie Eaton
"aa" wrote:

I have an ID field set to autonumber.
The table has a primary key combined of three other fields, ID is not one of
them
The table is being populated via a form where the ID filed is filled
automatically.

I have been adding records for several days and everything was OK untill
today I noticed, that all the records I added today have been assigned the
same negative ID -02
And even one of the records I enetered time ago, changed its ID to -2

What is going on and how do I fix it?

a



  #3  
Old July 30th, 2004, 03:23 AM
Jay Vinton
external usenet poster
 
Posts: n/a
Default negative autonumber

You may find this helpful.

http://allenbrowne.com/ser-40.html

Jay
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
autonumber Deepak General Discussion 3 June 18th, 2004 09:07 PM
multiplying a negative time value by a monetary rate apogee General Discussion 1 June 13th, 2004 12:37 AM
Negative numbers in formulas Bob Phillips Worksheet Functions 5 January 13th, 2004 06:13 PM
Negative dates or times are displayed as #### John Sheakley Worksheet Functions 1 September 30th, 2003 03:38 AM


All times are GMT +1. The time now is 06:03 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 OfficeFrustration.
The comments are property of their posters.