An aftetthought on my journey into VS/C#. After a restful night's sleep , awaking to a sunny and cold Sun. AM, I still have the lingering thoughts: me to myself: " I developed this entire Bible application that does everything I want it to and even better than Logos or other tradition BIble applications, why would I want to even consider trying to move this to VS in C#, if it were not for the lingering one thing that keeps bugging me at 2:00 AM most every night: VBA does not allow displaying red text substrings in a Textbox, be it a regular Textbox1 or a Rich Textbox on a userform, given that the Rich Textbox control in is inferior it its ease of programming red text substrings for the 3,000+ Words of Jesus Christ?
And, do I even need a database to do this in VS ? So, following one YT tutorial, I installed MAMP and MySQL Workbench. The point I'm at is to create a schema of the relationship structure. From what little I know about DB's this would look like: Book to Chapter (1-M) ->? Chapter - Verse(1-M) and Verse to Verse Note(1-1) . That would define the ID as the Primary key.
Once that's done, and that seems pretty easy, the next step is to do what I did in the userforms in my VBA app: Textbox1 displays the results of a 5 column database query of the entire 31,103 rows in the db, be it Access or some other db that plays well with VS and C#. The Listbox Rowsource in VBA is the Excel sheet. To me, the Listbox Rowsource in a VS app would be a database.
Once that's done, the last task in telling VS/C# when to begin and end displaying red text in the Textbox.
OI know there are people out there that are light years ahead of me in their experience realm who's probably laughing at my editorial here that could imagine this done with their eyes closed. But I'm not there - yet. Readers of this post would ask "so what's your question, cr ?" - Answer: can VS/C# be used to display red text substrings in a userform textbox, using something like "markers" or displaying red tex from the db that already has red text embedded in its data ? Then all it would be, if that's possible, is just a matter of changing the text color in 3,000+ words in the db.
If hard coding such as
linktext is the name of an RTF textbox
needs to be done to accomplish this, then it would not be timewise to try to replicate this in VS/C#.
Thanks to all for help, guidance and criticisms. I have no problem abandoning learning VS/C# if this won't
help me accomplish this. The thing is, though, others have done this many times, as was Wordsearch 12 developed in C#, so why can't I ?
And, do I even need a database to do this in VS ? So, following one YT tutorial, I installed MAMP and MySQL Workbench. The point I'm at is to create a schema of the relationship structure. From what little I know about DB's this would look like: Book to Chapter (1-M) ->? Chapter - Verse(1-M) and Verse to Verse Note(1-1) . That would define the ID as the Primary key.
Once that's done, and that seems pretty easy, the next step is to do what I did in the userforms in my VBA app: Textbox1 displays the results of a 5 column database query of the entire 31,103 rows in the db, be it Access or some other db that plays well with VS and C#. The Listbox Rowsource in VBA is the Excel sheet. To me, the Listbox Rowsource in a VS app would be a database.
Once that's done, the last task in telling VS/C# when to begin and end displaying red text in the Textbox.
OI know there are people out there that are light years ahead of me in their experience realm who's probably laughing at my editorial here that could imagine this done with their eyes closed. But I'm not there - yet. Readers of this post would ask "so what's your question, cr ?" - Answer: can VS/C# be used to display red text substrings in a userform textbox, using something like "markers" or displaying red tex from the db that already has red text embedded in its data ? Then all it would be, if that's possible, is just a matter of changing the text color in 3,000+ words in the db.
If hard coding such as
C#:
Private Sub UserForm_Activate()
Dim firstpos As Integer, lastpos As Integer
Inktext.Text = "And Jesus Said to him," & Chr(34) & _
"therefore when you see the abomination of desolation standing in the Holy Place." & Chr(34) &
(therefore when you see the abomination of desolation standing in the Holy Place. display in red text)
linktext is the name of an RTF textbox
needs to be done to accomplish this, then it would not be timewise to try to replicate this in VS/C#.
Thanks to all for help, guidance and criticisms. I have no problem abandoning learning VS/C# if this won't
help me accomplish this. The thing is, though, others have done this many times, as was Wordsearch 12 developed in C#, so why can't I ?