ACCESS FEED: Re: Re: [MS_AccessPros] Returning alphabet "a"

Kamis, 29 Oktober 2015

Re: Re: [MS_AccessPros] Returning alphabet "a"

Duane,
Thank you very much. I will try it today.
Best Regards,
Kevin

Regards,

Kevin Zhao

From: crystal 8 strive4peace2008@yahoo.com [MS_Access_Professionals]
Date: 2015-10-28 00:21
To: MS_Access_Professionals
Subject: Re: [MS_AccessPros] Returning alphabet "a"

as long as you won't have more than 26 records, you can use:

1. the form CurrentRecord property, which returns the order from the top
2. Chr function to convert a number to a character. "a" is 97

'~~~~~~~~~~~~~~~~~~~~~~~~
   Dim nCurrentRecord As Long
   Dim sChar As String
   nCurrentRecord = Me.CurrentRecord
   sChar = Chr(nCurrentRecord + 96)
   MsgBox sChar
'~~~~~~~~~~~~~~~~~~~~~~~~

but, as Duane asked, is there something you use to determine order? Obviously, users can sort by something ~

warm regards,
crystal

Tool: Document Query Calculated Fields: Access to Excel. Music by JD Live (cc)
https://www.youtube.com/watch?v=vS8KfHU6L90
- SQL to show calculated fields in queries, use CopyFromRecordset to put in Excel and then format

~ have an awesome day ~

On 10/27/2015 9:04 AM, Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals] wrote:

Kevin,

How much progress have you made on this? Have you tried doing something with the double-click event of the control?

What is your full context/requirement? Are you attempting to create an auto-incrementing value for a field? Can we assume the "a" is for the first record? Is there any stored value that determines the order?

Duane Hookom, MVP
MS Access

To: ms_access_professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Tue, 27 Oct 2015 22:35:21 +0800
Subject: [MS_AccessPros] Returning alphabet "a"

Dear All,

Is that possible to double clicking on an empty text field in continuous form, it returns an alphabet "a,", when clicking on the next record, and it returns "b", etc.?

Thanks in advance,

Best Regards,

Kevin