Date: 2015-10-28 00:21Subject: 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
Posted by: "zhaoliqingoffice@163.com" <zhaoliqingoffice@163.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (16) |
Tidak ada komentar:
Posting Komentar