flynn

Given this database structure: table InvItem table InvItemDetails where the InvItem has many InvItemDetails records linked by a the ItemID, is there an SQL statement that will combine all of the InvItemDetails.Desc fields into a single string and return that string to me? tia, flynn

I am successfully reading Outlook messages with this code: MsgItem = DirectCast(FolderAlertsIn.Items(1), Outlook.MailItem) However, these messages have HTML in them that I am NOT seeing. If I go to Outlook and right-click on the message, select "View Source", I can see the embedded HTML (this is the stuff I need). Does anyone know how to get Outlook to give me the text just as it appears when selecting "View Source"? Thanks in advance, flynn

Intellisense only works for certain things for me in the command window. When I type "Debug." intellisense will display a list to choose from. But if I type in "Date.", "System." or any of my class names, Intellisense does not work. I couldn't find any settings that affect this. Is anyone using the 2.0 beta? Does it work any better?

1) In VB6, while the code was stopped in the debugger, the form and controls were visible. In .Net, the non-title bar area of the form is completely white while debugging. Is this normal? If so, will .Net 2.0 fix this? 2) Does Intellisense not work in the command window?

I am writing a string parser and wondering how efficient it is to call the Is* and .Char() methods? Performance is an issue in this case since I need to make multiple passes through the string to 1) remove HTML tags , 2) remove CR-NL's and 3) parse the string for multiple combinations of characters. The strings can be up to 100k in size. In C, I can compare characters using: if str[x] = '\n' ... and it is very fast since there is no function call overhead. At the moment, I am using this type of code. Relatively speaking, how fast is the .Chars() method? I'm assuming I can't view the assembly source like I could with VB6. if (s.chars(x) = "5") then ... Should I be worried about the performance of the Is* methods?

Is there a way to display a context-sensitive menu after the user has clicked on a listview item and entered into the label edit mode? I can capture the "BeforeLabelEdit" event and display the menu there, but that is too soon to show the menu. I need the menu to show when they are actually editing the text. The purpose for this is that I would like to be able to let the user select from items on the menu to place at the location of the insertion bar/cursor. Example: the user clicks on a list view item that has this text: "Windows is great". They place the focus bar after the letter "s" in the word "Windows", right click and a menu pops up that has the choices of "NT", "2000" and "XP". The user selects the "XP" item and the code would insert the selected text at the insertion point so that the listview text would now read "WindowsXP is great"

I have a listview that I populate with file names from a folder that is being watched (using FileSystemWatcher via "AddHandler FileWatch.Created, AddressOf FileWatchNewFile"). When a new file is created in the folder, it is added to the listview from the FileWatchNewFile function. Processing each file could take up to a minute or two, so the listview could contain dozens of entries that are waiting to be processed. Once a file is processed, it is flagged/removed. It's possible that all the files could be processed so that the listview becomes empty. My question is this: What is the best way to watch the listview in order to process the entries (filenames) as they show up? Should I use a timer that would fire every 10 seconds to see if the file processing code is waiting to be called? What if the file processing code is still processing a file? Hopefully you get the idea. tia flynn

Given this text: I am having trouble trying to break the string into "words". The problem I'm having is that split doesn't accept multiple delimiters and even if it did, I couldn't split using the "." character because that would split the "2.6" into 2 different words. I'm not too familiar with regex. It allows multiple delimiters but can it differentiate for a "." that ends a word (or sentence) and one that is embedded in a number ("2.6")? Or is there another way to break string data into individual words to be processed? tia, flynn

I haven't had any luck finding a solution to this problem: Given an MDI app, the user opens a new document window. In the ID text field, they type an ID (say "123"). They open another child document and type the ID "123" again. What I need to do is close the most recent child document and give focus back to the document that already had "123" as the ID. The code I am trying to use: Private Sub txtFolioNumber_LostFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles txtFolioNumber.LostFocus Dim frm As frmDocument For Each frm In Me.MdiParent.MdiChildren 'no need to check myself (the current form) If (Me.Handle.ToInt32 <> frm.Handle.ToInt32) Then 'if the number just entered is already used on another form, switch to that form If (frm.txtFolioNumber.Text = txtFolioNumber.Text) Then frm.TopMost() = True Me.Close() End If End If Next frm End Sub I also posted this problem at VisualBasicForum.com (in the .Net section) but haven't found a solution yet. http://www.visualbasicforum.com/showthread.php?t=232374 tia, flynn