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 :)
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.