Re: HOVER TECHNIQUE
anonymous_at_discussions.microsoft.com
Date: 05/26/04
- Next message: Jasmine: "Main form and subform"
- Previous message: Wayne Morgan: "Re: Code Help"
- In reply to: Albert D. Kallal: "Re: HOVER TECHNIQUE"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 26 May 2004 07:29:39 -0700
Yes it is true. Many actions you deem as ordinary can
convey things that you really don't mean. It is kind of
funny. Thank you for responding and helping!
>-----Original Message-----
><anonymous@discussions.microsoft.com> wrote in message
>news:1248701c44292$192dd8f0$a001280a@phx.gbl...
>
>> Oh, my apologies to everyone if this is what they
>> thought. It is a habit of mine to type in uppercase.
It
>> was not meant to insinuate that I was shouting, and I
>> definitely didn't mean to be rude. So, again I
apologize.
>
>You are most welcome. Not a big deal that you did type in
upper case. Funny
>how just typing on a keyboard can kind of convey things.
>
>> named "Rownumber". So, say you are the first contact
>> record entered, your "Rownumber" will be 1. This way
the
>> currentrecord works. But if I query a recordsource, the
>> currentrecord may be row#1 in the filtered source, but
>> my "Rownumber" field is a number 12. It also disrupts
the
>> code if a contact is deleted.
>
>If you query a reocrdsouce..you want to always use the
key id of the record
>(not some position). Note that you DO NOT have to include
those additional
>fields on the form (but, that key id field MUST however
be part of the
>query, or in the table that the form is attached to).
>
>So, you can grab the key id, and use that for your query.
>
>dim strSql as string
>dim rstRec as dao.recordset
>
>strSql = select CustomerName from tblCustomers where id
= " & me.Id
>
>set rstRec = currentdb.OpenRecordSet(strSql)
>
>msgbox "customer name of id is " & rstRec!CustomerName
>
>The above would display a customer name based on the ID,
but NOT the
>position in the list. Thus, deletions etc. should not mix
things up.
>
>--
>Albert D. Kallal (Access MVP)
>Edmonton, Alberta Canada
>pleaseNOOSpamKallal@msn.com
>http://www.attcanada.net/~kallal.msn
>
>
>.
>
- Next message: Jasmine: "Main form and subform"
- Previous message: Wayne Morgan: "Re: Code Help"
- In reply to: Albert D. Kallal: "Re: HOVER TECHNIQUE"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
