Start New Discussion within our Software Development Community

Need help for creating an diary alphabetically...some doubts

1. Do i need to create separate recordset for each alphabet (A-Z) ?
2. How do i get the 1st letter of the name entered into a textbox ? (hav heard that "VB Controls" help...but couldnt find a control to help me..)
3. if answer to 1st question is "no" how do i store & Retrieve names of particular alphabet from database when user clicks a label of that alphabet?

Plz help...

Q 1. Do i need to create separate recordset for each alphabet (A-Z) ?
Ans: Why don't you create some labels or listbox, so that you can display the alphabets. When user clicks on the alphabet, use the database to fetch the data...

Q 2. How do i get the 1st letter of the name entered into a textbox ? (hav heard that "VB Controls" help...but couldnt find a control to help me..)
Ans: Try this code:

Dim strFirstLetter as string
strFirstLetter=left(trim(Text1.text),1)

)

Q 3. if answer to 1st question is "no" how do i store & Retrieve names of particular alphabet from database when user clicks a label of that alphabet?
Ans: Use a separate data Field in your table to store the Alphabets

Good luck :)

Comments
thanks
This question has already been answered. Start a new discussion instead.