Search results for query: *

InertiaM, many thanks for your help - much appreciated!! Sorry for the delay in replying... Royal Weddings, Bank Holidays and the like I'm afraid!

Hi, I wonder if somebody could point me in the right direction. I have an 'In' folder that users drop all different types of files into (.doc, .xls, .rtf, .pdf etc.). Each file that gets dropped into the 'In' folder should have a matching .pdf file (i.e. abc123.doc and abc123.pdf) I have a...

Hi, I wonder if someone can help me. I have an application that loads a dll. This dll that is loaded calls and loads other dll's as it sees fit based on the filetype my apllication is dealing with. One of these DLL's 'PDFFILT.dll' (Adobe PDF IFilter dll) is not unloading itself after it has...

Hi KSteed, You need to add reference to Microsoft Excel at the top of your code. For example:..... Option Strict Off Option Explicit On Imports VB = Microsoft.VisualBasic Imports Microsoft.Office.Core Imports Microsoft.Office.Interop Imports System.Text.RegularExpressions I originally...

Hi ggunter , No, I hadn't released the COM object, thanks for pointing me in the right direction. I have now added this to my code. I still get the error, but I have noticed it does not matter whether Excel has been open or not, so I shall keep digging as I'm guessing it is related to...

Hi there, I have a problem that I hope somebody can help with. I have a button on my form which creates an instance of Excel and exports a ListView to an Excel Workbook - This all works perfectly. Occasionally when I exit my application I get the following error 'The instruction at...

Hi Cjard, Thank you for looking at the problem for me. Yes, that's where I was falling over.... using the old connection string. Thanks again.

I have got it to work, although I am sure there are more efficient ways... strDBAseName = "C:\Temp\NewDBase.mdb" If System.IO.File.Exists(strDBAseName) = True Then '======================================================================= '== Set DataSource DataGridView to nothing and Refresh...

Hi there, I wonder if somebody could please point me in the right direction. I have a form which has a DataGridView on it. The DataGridView is populated with data from an MS access database on 'form load' with no problems. I have another form (frmSettings) which allows a user to modify...

David 84, The code I originally posted was from another application (Microstation Basic), which uses dollar symbols after the string parameters. I have modified the pervious post code and removed the dollar symbols. Does this resolve your errors? If not, try using...

No... sorry, TAG_NUMBER is the name of one of my columns. I only wish to search the 'TAG_NUMBER' column in my DataGridView. Thanks

Hi Arg81, Thanks for your reply. I wonder if you could help me a little bit more? if I wanted to only search through the column "TAG_NUMBER", do you know how I could apply this to your code example?

Hi there, I think this is what you are after... (from the msdn website) How to wait for a shelled application to finish by using Visual Basic 2005 or Visual Basic .NET It is code to call a shelled application (i.e. Notepad, Excel, etc.) and then wait for that application to finish or close...

Hi there, I wonder if somebody could please help me. I am looping through a column in a DataView. What I would like to do is to change the default BackColor of the row if my criteria is met (i.e. the current cell contains a particular string). I can loop through the DataView without any...

rcombs4, Thanks for your reply. I wondered if that might be the case as it was stopping the exact matches being added to my new arraylist. I dismissed that thought as I was also using 'contains' on a string search which was working fine. Like you say - "The Contains function works a little...

Hi there, I wonder if somebody could please help.... I have an arraylist (arrFirstArry) which I use to populate another arraylist (arrNoDuplicates) preventing any duplicates from being added. This works fine. What I would also like my code to do is prevent adding any partial values which may...

demausdauth, Thanks - your answer was exactly what I was looking for, thanks for the tip about formatting the coding too.

Hi there, I wonder if anybody can help me.... I am looping through a DataGridView and checking the returned string value (strTag) against another string I have (strMyString). My problem is that I have several columns, but I only want to iterate through the Column Named 'TAG_NUMBER'. Here is...

John, I was being blasé and asssumed that because I had used the same format in other programs it would work in vb.net / regex. Thanks for your comments, some useful bits in there.

Solved I found the answer..... I discovered that I cannot use '#' to search for numeric characters. I have had to revise the search as shown below..... From [a-z]###-[a-z]-###-* to [a-z][0-9][0-9][0-9]-[a-z]-[0-9][0-9][0-9]-* Thanks to anybody who looked into this.