[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
RE: [ProgSoc] Another Access Q
I'm not sure you have had a reply but another one won't matter.
On Fri, 12 Apr 2002, Simon Hirshbein wrote:
> > -----Original Message-----
> > From: Jay Banyer [mailto:Jay.Banyer@nospam.jcu.edu.au]
> > Sent: Friday, 12 April 2002 4:56 PM
--- Snip, Snip (throughout) ---
> > Simon Hirshbein wrote:
> > >
> > > Each entry has a enquiry number. How can I get a form to
> > display the
> > > enquiry number of the PREVIOUS entry? I suspect I can do
> > it with 'Dlookup',
> > > but am not 100% sure how.
> > The word 'previous' implies a sort order. The sort order should be
> > defined by the recordset you are using, ie table or query.
> Data is kept in a simple table in record number order and
> will stay that way. Therefore, 'previous' refers to the previous record in
> record number order. I'd prefer to keep queries out of it if possible.
> Essentially, I want it to be like in Excel where you type =<cell above
> record number of current record>.
You are right that you can use DLookup. It is
NameOfVariable = DLookup("[FieldToGetValue]", "Table", & _
"FieldID = " & CurrentID - 1)
The "& _" is just there if you write it on two lines. Remove it if you put
it on one.
> Being an engineer (with little interest or skills in database development)
> and designing the database for other engineers and people with even poorer
> computer skills, I'm keeping it really simple (as I hate doing this kind of
> thing anyway).
You can always hire me :). I'm an engineer who doesn't mind a little part
time programming work.
You are subscribed to the progsoc mailing list. To unsubscribe, send a
message containing "unsubscribe" to email@example.com.
If you are having trouble, ask firstname.lastname@example.org for help.