Recent content by ceyhorn

Ok, I figured out how to add to the end of the file: Public Sub WriteTextFile(ByVal FileName As String) Dim objStreamWriter As StreamWriter objStreamWriter = New StreamWriter("c:\textfile.txt",True) objStreamWriter.WriteLine(FileName + " " + Date.Now)...

RiverGuy, Thanks for the link, but the code on that page does not give an example of how to open the same file and add lines. I also am trying to figure out how to search to see if a filename has been added. Chris

I am creating a text file that stores a list of file names so that I know what files have been processed. I have figured out how to write a file to the .txt file, but have run into two problems. 1) each time i write the file name it just overwrites the previously inserted name and 2) how can i...

Miners47, Did you ever figure out a solution to this problem. I am experiencing the same. I can not drag and drop directly into my vb app. I have to drag/drop onto my desktop and then go to my app. Thanks, Chris

Any ideas?

I have an excel file with a few textbox's on it. They text boxes have autowrap and vertical scrollbars. When I do a print preview the textbox only shows a few lines of text. Is there a way to show all the text in the textbox when doing a print? The autoresize property just covers up the rest...

What about using the % in front and behind the text search?

I am trying to create a search for a grantee, currently i am just passing it in as a parameter, but the drawback is that it has to be an exact match. How can I use the LIKE in my WHERE clause so that it looks for the words in the database? SELECT ApplicationID, GrantCountID, GranteeName...

Thanks for the help, The selected cell could be x amount of cells below or above the personnel or the contractual cell. Personal x x x selected cell x x Contractual x x y Travel I want to make sure that "selected cell" is in the right budget section and not between "contractual" and "travel"...

How would I check to see if the selected cell is under a certain cell called "personnel" and above a cell called "contractual"? They are all in the same column "B". thanks in advance, Chris

Thanks Beck, but the expression is always failing even with the correct format. Any ideas? Thanks again, Chris

I'm trying to check to make sure the text box has a number in the format of: #####-##, or five digits a dash and then two digits. How would i do this. Thanks in advance, Chris

I have a file viewer control which came with the VbPowerPack. I'm trying to get the drag and drop functionality going for files, but everytime I drop it in, it just shows up as the full file string and not an image. Has anyone had experience with this? Do I need to do somekind of refresh...

We have an audit log table with hundreds of thousands of entries tracking everyone's actions. We are currently working on a way to backtrack to see the state of the file on x date.

SELECT dbo.AUDIT_LOG.AuditID, dbo.AUDIT_LOG.AuditType, dbo.AUDIT_LOG.TableName, dbo.AUDIT_LOG.UniqueFields, dbo.AUDIT_LOG.UniqueId, dbo.AUDIT_LOG.FieldName, dbo.AUDIT_LOG.OldValue, dbo.AUDIT_LOG.NewValue, dbo.AUDIT_LOG.AuditDate, dbo.AUDIT_LOG.AuditDate_NoTime...