Prev: Equipment Database
Next: Error "wizard is unable to create your data access page"
From: BruceM via AccessMonster.com on 3 Mar 2010 11:25
Hmm???

a a r o n _ k e m p f wrote:
>Dont delete records??? For any reason, period!?!?!
>
>On Mar 3, 6:46 am, RacheleP <Rache...(a)discussions.microsoft.com>
>wrote:
>> Ive searched high and low in this group and have learned that Autonumber is
>> not the best way to assign a unique (PrimaryKey) number.  What I havent been
>[quoted text clipped - 4 lines]
>> to assign the next RGA number when my user goes into the Form to enter the
>> data?  I need the database to start with 3642 as the next RGA number.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access/201003/1

From: RacheleP on 3 Mar 2010 13:11
Thanks Ken and Daniel. It took some trial and error but its working
perfectly now. Thanks again!

Rachele

"KenSheridan via AccessMonster.com" wrote:

> Roger Carlson has a simple solution, which avoids conflicts in a multi-user
> environment, at:
>
> http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=395&SID=83z7c11zc7b721d2a1e51989c53d7ffb
>
>
> A slightly more complex solution, which allows the next number to be used to
> be 'seeded' is at:
>
> http://community.netscape.com/n/pfx/forum.aspx?nav=libraryMessages&tsn=1&tid=23839&webtag=ws-msdevapps
>
>
> Ken Sheridan
> Stafford, England
>
> RacheleP wrote:
> >Daniel,
> >
> >Thanks so much for your help and fast response.
> >
> >I prefer the RGA numbers to stay in sequential order. I am unfamiliar with
> >the DMax function and how to use it. Would you please walk me through it? I
> >have a table in which the primary key is the field RGANumber. There are
> >other tables that are related by that primary key. I have a data entry Form
> >where the information is entered. Let me know if you need any other info.
> >
> >Thanks!
> >Rachele
> >
> >> There is nothing wrong with using an AutoNumber! It depends on what you are
> >> trying to do. Typically, Autonumbers will be sequential and will show you
> >[quoted text clipped - 17 lines]
> >> > to assign the next RGA number when my user goes into the Form to enter the
> >> > data? I need the database to start with 3642 as the next RGA number.to start with 3642 as the next RGA number.
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access/201003/1
>
> .
>
From: Larry Linson on 3 Mar 2010 16:22
>> a a r o n _ k e m p f wrote:

>>Dont delete records??? For any reason, period!?!?!

> "BruceM via AccessMonster.com" <u54429(a)uwe> wrote

> Hmm???

Mr. Kempf is quick to issue edits, but not so quick to explain why and what
to do instead.

There can be good reasons for not deleting records and there can also be
circumstances in which there is nothing to be gained by saving inactive
information. If Mr. Kempf is as knowledgeable as he seems to think himself,
perhaps now he will explain some of those circumstances and the differences
between them.

Larry Linson
Microsoft Office Access MVP



From: BruceM via AccessMonster.com on 4 Mar 2010 07:21
I have noted Mr. Kempf's past postings, and was disappointed to see he is
back. Maybe it's just some drive-by ranting, after which he'll disappear
again.

I agree that there are perfectly valid reasons for deleting records, but
perhaps more to the point there will almost certainly be gaps in an
autonumber sequence even if records are never deleted. Of ocurse you know
this, but I wondered if he was going to contend that gaps can be prevented,
and wanted to head off any misdirection on the point.

Larry Linson wrote:
>>> a a r o n _ k e m p f wrote:
>
> >>Dont delete records??? For any reason, period!?!?!
>
> > "BruceM via AccessMonster.com" <u54429(a)uwe> wrote
>
> > Hmm???
>
>Mr. Kempf is quick to issue edits, but not so quick to explain why and what
>to do instead.
>
>There can be good reasons for not deleting records and there can also be
>circumstances in which there is nothing to be gained by saving inactive
>information. If Mr. Kempf is as knowledgeable as he seems to think himself,
>perhaps now he will explain some of those circumstances and the differences
>between them.
>
> Larry Linson
> Microsoft Office Access MVP

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access/201003/1

From: Debra on 10 Mar 2010 10:32

"RacheleP" <RacheleP(a)discussions.microsoft.com> wrote in message
news:59421E35-96E2-416A-B716-5BB5F637FA1D(a)microsoft.com...
> Ive searched high and low in this group and have learned that Autonumber
> is
> not the best way to assign a unique (PrimaryKey) number. What I havent
> been
> able to figure out is the best way to accomplish my goal.
>
> I am issuing Returned Goods Authorizations (RGA's) to customers. I dont
> want my user to have to find the next RGA number to use. How do I get
> Access
> to assign the next RGA number when my user goes into the Form to enter the
> data? I need the database to start with 3642 as the next RGA number.

First  |  Prev  |  Next  |  Last
Pages: 1 2 3
Prev: Equipment Database
Next: Error "wizard is unable to create your data access page"