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

Rabu, 28 Oktober 2015

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

chr(97) is "a"

On 10/28/2015 8:42 AM, Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals] wrote:

It seems that a lot of the previous replies have not been included in your reply. Could you provide the significant table and field names as well as some sample data?

Do you really need to use a, b, c, ... or would 1, 2, 3,... work (it's easier to code).

Duane Hookom, MVP
MS Access

To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Wed, 28 Oct 2015 12:10:13 +0800
Subject: Re:RE: [MS_AccessPros] Re: Returning alphabet "a"

Duane,

The sequence is the PartID.

Best Regards,

Kevin

在 "Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>，2015年10月28日上午11:48写道：

Kevin,

You haven't provided any field or fields that determine the sequence of the different services so you may be stuck manually entering a, b, c,...

Duane Hookom, MVP

MS Access

To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Wed, 28 Oct 2015 07:16:29 +0800
Subject: Re:[MS_AccessPros] Re: Returning alphabet "a"

Bill-

I realized it. The reason I want an alphabet appearing automatically is that I want to divide a long travel Itinerary into parts according to different services booked, e.g. air ticket, coach, etc. So with the alphabet I can name the parts as a,b,c...etc. Is that possible to get this done? Thank you Bill.

Best Regards,

Kevin

在 "wrmosca@comcast.net [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>，2015年10月28日上午12:30写道：

Kevin

Perhaps you should clarify what business rule you are needing? One thing to keep in mind...double-click also triggers a single click event if one exists.