Re: Incrementing on a form
- From: "Lynn Trapp" <ltrapp_NOSPAM@xxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 13 Sep 2005 07:17:47 -0500
Tracy,
Let me suggest that you start by looking for information in Help on the DMax
function. This will allow you to select the maximum value of some field
based on a criteria, which can be the value of your row field.
--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html
"Tracy PM" <TracyPM@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D6C49105-D03F-4E8E-8AD4-78387713AC84@xxxxxxxxxxxxxxxx
> Hello, first poster. My question is this:
>
> I am working on a cemetery database, I have only one table and one form at
> this point. On my form, I want to auto-increment the number in the Grave
> field based on the number in the Row field.
>
> For example, There are 50 graves in the first row, instead of having to
> manually keep up with what grave I'm on I'd like the form to autoinsert
> the
> next number as long as the row didn't change. When the row goes to 2, I'd
> like the grave number to start over again at 1.
> I am new to VBA, but used to working with Access. Any help or advice to
> where I can find some learning material online for VBA would be a great
> help
> also, as I would like to become proficient in the VBA language. Thanks!
>
>
>
.
- Prev by Date: Re: Line spacing in text box
- Next by Date: RE: Emailing from Access
- Previous by thread: Form/Subform problem
- Next by thread: Re: Tab control Caption
- Index(es):
Relevant Pages
|
