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. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
Autonumbers [WAS: How can we have a field assign a num.automaticly starting with 29]
Philip Herlihy wrote:
John Spencer wrote: Well, even if you could have more than one, they would probably be identical. Like you I can not really envision any good reason for having two autonumbers in one table. John Spencer Access MVP 2002-2005, 2007-2008 The Hilltop Institute University of Maryland Baltimore County Klatuu wrote: Thanks, John. I was not aware of that. As I did say, I can see no reason to have more than one, so I guess I have never even tried. Thanks for the correction. "John Spencer" wrote in message ... Pardon me, but as far as I know, you can only have ONE autonumber field in a table. I just tried adding a second one in Access 2003 (JET db engine) and got an error message saying I was only allowed one autonumber field in the table. John Spencer Access MVP 2002-2005, 2007-2008 The Hilltop Institute University of Maryland Baltimore County Klatuu wrote: You can have multiple Autonumber fields is a table, but I can't, at the moment, think of a useful purpose to do so. Not surprised you can't have more than one. The point I was making is that an autonumber gives you a value which is guaranteed to be unique, and that's pretty much all you need for an account number. Even if there was some reason not to use the PK as an account number (I do use it for Invoice Number in one application) then I was speculating whether you could have a second Autonumber field to generate arbitrary Account Numbers. If you look on your gas bill and study your account number - what is it, if not a primary key? Phil US readers note - what you call "gas" is properly called "petrol". The "gas bill" referred to is for domestic heating supply! Anyway, these differences should diminish now that you are to have an Irish president. We all wish Senator O'Bama all the best. Phil, London |
#12
|
|||
|
|||
[OT] Autonumbers [WAS: How can we have a field assign anum. automaticly starting with 29]
Philip Herlihy wrote:
[snip] Not surprised you can't have more than one. The point I was making is that an autonumber gives you a value which is guaranteed to be unique, and that's pretty much all you need for an account number. Even if there was some reason not to use the PK as an account number (I do use it for Invoice Number in one application) then I was speculating whether you could have a second Autonumber field to generate arbitrary Account Numbers. If you look on your gas bill and study your account number - what is it, if not a primary key? Phil US readers note - what you call "gas" is properly called "petrol". The "gas bill" referred to is for domestic heating supply! Anyway, these differences should diminish now that you are to have an Irish president. We all wish Senator O'Bama all the best. Phil, London Well, I had been joking, but it's true! http://news.bbc.co.uk/1/hi/northern_ireland/6617779.stm Good grief... PH |
#13
|
|||
|
|||
Autonumbers [WAS: How can we have a field assign a num. automaticly starting with 29]
The Irish were really puzzled about why we were even bothering to have an
election. One the one hand we had a pant suit wearing lawyer married to a lawyer what can't keep his pants on supporting a lawyer who is married to a lawyer who doesn't even like the country her husband wants to be president of and on the other a fellow with a name start starts with Mc married to a beautiful rich lady who owns a brewery distributorship. So why, they wonder, is there even a question. You are confusing gas with gas. The qas you put in your car is gasoline The gas bill refers to natural gas used for heating. domestic heating supply is too ambiguous. It could be gas, electricity, oil, coal? "Philip Herlihy" wrote in message ... Philip Herlihy wrote: John Spencer wrote: Well, even if you could have more than one, they would probably be identical. Like you I can not really envision any good reason for having two autonumbers in one table. John Spencer Access MVP 2002-2005, 2007-2008 The Hilltop Institute University of Maryland Baltimore County Klatuu wrote: Thanks, John. I was not aware of that. As I did say, I can see no reason to have more than one, so I guess I have never even tried. Thanks for the correction. "John Spencer" wrote in message ... Pardon me, but as far as I know, you can only have ONE autonumber field in a table. I just tried adding a second one in Access 2003 (JET db engine) and got an error message saying I was only allowed one autonumber field in the table. John Spencer Access MVP 2002-2005, 2007-2008 The Hilltop Institute University of Maryland Baltimore County Klatuu wrote: You can have multiple Autonumber fields is a table, but I can't, at the moment, think of a useful purpose to do so. Not surprised you can't have more than one. The point I was making is that an autonumber gives you a value which is guaranteed to be unique, and that's pretty much all you need for an account number. Even if there was some reason not to use the PK as an account number (I do use it for Invoice Number in one application) then I was speculating whether you could have a second Autonumber field to generate arbitrary Account Numbers. If you look on your gas bill and study your account number - what is it, if not a primary key? Phil US readers note - what you call "gas" is properly called "petrol". The "gas bill" referred to is for domestic heating supply! Anyway, these differences should diminish now that you are to have an Irish president. We all wish Senator O'Bama all the best. Phil, London |
#14
|
|||
|
|||
Autonumbers [WAS: How can we have a field assign a num.automaticly starting with 29]
Klatuu wrote:
The Irish were really puzzled about why we were even bothering to have an election. One the one hand we had a pant suit wearing lawyer married to a lawyer what can't keep his pants on supporting a lawyer who is married to a lawyer who doesn't even like the country her husband wants to be president of and on the other a fellow with a name start starts with Mc married to a beautiful rich lady who owns a brewery distributorship. So why, they wonder, is there even a question. You are confusing gas with gas. The qas you put in your car is gasoline The gas bill refers to natural gas used for heating. domestic heating supply is too ambiguous. It could be gas, electricity, oil, coal? US readers note - what you call "gas" is properly called "petrol". The "gas bill" referred to is for domestic heating supply! Anyway, these differences should diminish now that you are to have an Irish president. We all wish Senator O'Bama all the best. Phil, London I think we should let the ambassadors work this one out... :-) |
#15
|
|||
|
|||
Autonumbers [WAS: How can we have a field assign a num. automaticly starting with 29]
No, I think military action is required
We haven't had a good tussle with you guys since 1812. Hey, but don't burn the White House again. That was really inconvenient. Oh, wait. That was actually the Canadians "Philip Herlihy" wrote in message ... Klatuu wrote: The Irish were really puzzled about why we were even bothering to have an election. One the one hand we had a pant suit wearing lawyer married to a lawyer what can't keep his pants on supporting a lawyer who is married to a lawyer who doesn't even like the country her husband wants to be president of and on the other a fellow with a name start starts with Mc married to a beautiful rich lady who owns a brewery distributorship. So why, they wonder, is there even a question. You are confusing gas with gas. The qas you put in your car is gasoline The gas bill refers to natural gas used for heating. domestic heating supply is too ambiguous. It could be gas, electricity, oil, coal? US readers note - what you call "gas" is properly called "petrol". The "gas bill" referred to is for domestic heating supply! Anyway, these differences should diminish now that you are to have an Irish president. We all wish Senator O'Bama all the best. Phil, London I think we should let the ambassadors work this one out... :-) |
#16
|
|||
|
|||
Autonumbers [WAS: How can we have a field assign a num. automaticly starting with 29]
"Klatuu" wrote:
No, I think military action is required We haven't had a good tussle with you guys since 1812. Hey, but don't burn the White House again. That was really inconvenient. Oh, wait. That was actually the Canadians Glad you figured that one out. Tony (Canadian) -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ |
#17
|
|||
|
|||
Autonumbers [WAS: How can we have a field assign a num. automaticly starting with 29]
"Tony Toews [MVP]" wrote in message
... "Klatuu" wrote: No, I think military action is required We haven't had a good tussle with you guys since 1812. Hey, but don't burn the White House again. That was really inconvenient. Oh, wait. That was actually the Canadians Glad you figured that one out. picky In 1812, we weren't officially Canadians. That didn't happen until 1867. /picky -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) |
|
Thread Tools | |
Display Modes | |
|
|