Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ceyhorn

    StreamReader and StreamWriter

    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)...
  2. ceyhorn

    StreamReader and StreamWriter

    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
  3. ceyhorn

    StreamReader and StreamWriter

    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...
  4. ceyhorn

    Copy File Not On Disk

    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
  5. ceyhorn

    Resize textbox to show all text during print in excel?

    Any ideas?
  6. ceyhorn

    Resize textbox to show all text during print in excel?

    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...
  7. ceyhorn

    Using Like with Parameters

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

    Using Like with Parameters

    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...
  9. ceyhorn

    Check to see if selected cell is between two others?

    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"...
  10. ceyhorn

    Check to see if selected cell is between two others?

    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
  11. ceyhorn

    How do check a string format?

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

    How do check a string format?

    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
  13. ceyhorn

    How to drag and drop using a File Viewer?

    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...
  14. ceyhorn

    tracking old values

    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.
  15. ceyhorn

    Combine two fields as one for the ON statement

    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...
  16. ceyhorn

    Automatic file deletion in a directory

    Excellent, thank you, Chris
  17. ceyhorn

    Automatic file deletion in a directory

    I currently have a web application that generates reports as excel files and then emails them out. All of the excel files get put into a temp folder on my server. How would I create an app that will sense when the directory has been changed and then delete all of the files in that folder...
  18. ceyhorn

    Need help on populating the data dynamically

    Amorous, The first thing that I noticed is that the changes you tried to make are writen in vb.net, the rest of the code is c#. Your changes should look like: string connString = @"Data Source = STJSQL\STJDB; Database=STJData; User ID=XXXX; Password=XXXXX" ; if (ReaderObj.Read) { int i...
  19. ceyhorn

    Runtime Error due to null

    Use my null function to check. It is posted above.
  20. ceyhorn

    Runtime Error due to null

    Use an If statement to check for an empty string using this function by passing in your dbvalue. Public Function FixNull(ByVal dbvalue) As String If dbvalue Is DBNull.Value Then Return "" Else 'NOTE: This will cast value to string if 'it...

Part and Inventory Search

Back
Top