Alphabet Button With Dropdown Letters

[forskare]

HAs anyone attempted to create an alphabet button that when clicking on a letter, the letter opens as a dropdown. I realize a browse can be used but the real estate is a bit short and if the browse can be avoided, so much the better. If you have, was it a success? If so would you please share the code?

Thank you,

[Ted Giles]

Re: Alphabet Button With Dropdown Letters

Ken, have you thought of a Dynamic Tree on Letter Click?
Or have I misunderstood?

[Tom Henkel]

Re: Alphabet Button With Dropdown Letters

Kenn,

I just created 3 buttons on an empty form associated with a single table. I defined a varoiable on the form "vLetter". Under each button, I set the value of the variable to the button letter. I have a record list box showing first and last names, filtering the list by the 1st initial of the last name. I specified that the box should repopulate if the variable changes. Is this what you want to do?

abc.jpg

I obviously didn't get the "C" copied, but you get the idea...

Code under the Buttons:

'Date Created: 08-Nov-2013 10:54:25 AM
'Last Updated: 08-Nov-2013 10:54:25 AM
'Created By  : Thomas Henkel
'Updated By  : Thomas Henkel
Dim shared vLetter as C = "A"

'Date Created: 08-Nov-2013 10:54:25 AM
'Last Updated: 08-Nov-2013 10:54:25 AM
'Created By  : Thomas Henkel
'Updated By  : Thomas Henkel
Dim shared vLetter as C = "B"

'Date Created: 08-Nov-2013 10:54:25 AM
'Last Updated: 08-Nov-2013 10:54:25 AM
'Created By  : Thomas Henkel
'Updated By  : Thomas Henkel
Dim shared vLetter as C = "C"

Tom

[forskare]

Re: Alphabet Button With Dropdown Letters

I would think using individual buttons should work. I'll give it a try.

Thank You,

[Ray in Capetown]

Re: Alphabet Button With Dropdown Letters

Ken I have done this using far less real estate than alphabet button.
A single button - "lookup" can create a dialog of all first letters in the field. Clicking on the letter sets the filter
I won't write one for you but I'm sure you can follow from this example - I commented for you.

'OnPush button Prompt for a value using a list box dialog box.
DIM Shared  vfgroup as c ' variable for the group - in your case first letter
DIM choice_list as c 
'-------------- replace a pre-entered list with a dynamic one with these lines
DIM tbl as p
tbl=table.open("invh_saved") 'could be table.current() - my preference is to open a second instance momentarily
choice_list = "All"+crlf()+upper(tbl.RECORD_CONTENT_GET( "group" , "group" ,"unique_key_value()")) 'I Added "All", use same button to clear the filter
'in the above line use left(field,1 for first letter  - replace "group" with the name of your field
tbl.close()
'-------------- replace the entered list with a dynamic one in these lines
dim defaultValue as c 
defaultValue = ""
vfgroup = ui_get_list2("Grp",defaultValue,choice_list,1,.t.)
grpttl="Grp "+vfgroup
if vfgroup="all" ' in my case this will be the user selection to clear filter
	vfgroup=""
end if
'----------------the following is just what I do upon selection
vfreprint=.f. 'set off the reprint items filter
filter = " (left(group,len([varC->vfgroup])) = [varC->vfgroup] )"
qfilter = replace_parameters(filter,local_variables())
Result = parentform:browse2.QueryRun(qfilter)

I didn't pay too much attention to cosmetics getting this job done for myself as it is a tiny support button of my form - but please share back, if you can use it, what improvements you suggest. I have very basic functionality in dialog design.

[forskare]

Re: Alphabet Button With Dropdown Letters

If I understand correctly, you have a button which opens a dialog containing individual alphabet buttons. In this situation, I would rather have the buttons displayed from the gitgo.

Thanks for suggestion and it may come in handy later on. If my understanding is incorrect, please correct my thinking.

[Ted Giles]

Re: Alphabet Button With Dropdown Letters

Gitgo?

[Al Buchholz]

Re: Alphabet Button With Dropdown Letters

Gitgo?

That's Minnesota(also upper midwest US) talk.

'From the gitgo' translates to 'from the beginning' or 'from the start'

[Ray in Capetown]

Re: Alphabet Button With Dropdown Letters

Ken you are correct.
In many cases I use the alphabet supercontrol and filter it to reflect only first alpha chars that exist in the table.

This example I use for listing only existing unique user entered category groups to select from. May have more than one character.

Since you mentioned a shortage of real estate it was a suggestion, as opposed to having 26alpha + perhaps 10num buttons.

[Ray in Capetown]

Re: Alphabet Button With Dropdown Letters

Ted, not to be confused with the British pronoun - you git

(Edit : I don't mean YOU)

[forskare]

Re: Alphabet Button With Dropdown Letters

Ken you are correct.
In many cases I use the alphabet supercontrol and filter it to reflect only first alpha chars that exist in the table.

This example I use for listing only existing unique user entered category groups to select from. May have more than one character.

Since you mentioned a shortage of real estate it was a suggestion, as opposed to having 26alpha + perhaps 10num buttons.

Hi Ray,

By shortage of real estate, I meant all the room a browse would take to view the results, not the space the super control will take. I could simply create the buttons, each with their own query but then that may not be the best way to do it. Tom's approach bears some looking into.

[Ted Giles]

Re: Alphabet Button With Dropdown Letters

Bloody colonials!
Language of their own!
Joke. I am married to an Anglo Saxon with a wonderful turn of phrase when she is unhappy.
Would make Dave Mason - Car Man since banned and ex Navy - blush.