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!

  • Congratulations Mike Lewis 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. Griffinator

    --extended-insert not working properly

    Thank you for your reply, KarveR I tried the command line syntax as you suggested, and unfortunately the problem is the same. Do you have any other suggestions?
  2. Griffinator

    --extended-insert not working properly

    Sorry, I also should have mentioned that I am using MySQL 5.0.18-nt. Hope this helps...
  3. Griffinator

    --extended-insert not working properly

    Hi, I am having a problem with using the --extended-insert option when using mysqldump. As I understand it, this option creates multiple insert statements within the .sql file for tables that contain more than 1 row of data. According to documentation I have found, this substantially speeds...
  4. Griffinator

    Looking for winsock guidance on multiple client - server app

    Thank you Borvik!! That is the type of functionality I was looking for. A start for you!
  5. Griffinator

    Looking for winsock guidance on multiple client - server app

    Hi all, I am attempting to write an application using vb.net 2003 that will have multiple clients connect to a server application using winsock. I have found many examples of how to connect one client to a server application, but I am unsure of how to create a server application that is...
  6. Griffinator

    When compacting an Access DB, why does the table size increase?

    Thank you for your insight, dilettante. I will look into this utility as well, I was not aware it existed.
  7. Griffinator

    When compacting an Access DB, why does the table size increase?

    Thank you, bjdrjc! That's just the explanation I was looking for. Now it makes sense. A star for you!
  8. Griffinator

    When compacting an Access DB, why does the table size increase?

    Hi, I have a question regarding compacting and repairing an Access DB: My original DB contains 1000 records, and currently its original size on disk is 152 KB. However, when I compact and repair the DB (using a snippet contained on this site), the size of the DB on disk increases to 232 KB...
  9. Griffinator

    How to use an ActiveX dll to store program data

    Hi BobRodes, Thanks for your suggestion. Like you had mentioned, I do not believe that the values I need to update can be altered and stored at runtime, short of recompiling the dll file on the fly and replacing the existing one. So, in the end I decided to use an obscure part of the registry...
  10. Griffinator

    How to use an ActiveX dll to store program data

    Never mind, after a little poking around I have come to the conclusion that I cannot do what I want with a dll file. If I am wrong on this, please let me know Thanks anyways!
  11. Griffinator

    How to use an ActiveX dll to store program data

    Hi, I am looking to use an ActiveX dll to store information about my program such as whether or not the program is a Trial version, if it has been activated, the date it was first run, and the date it was last run. I realize that there has been much discussion in this forum regarding securing...
  12. Griffinator

    pushing a button lists a word in a text field

    I think this is maybe what you are looking for, I am not at my computer, cannot test.... You will need to set the Multiline property of Text1 to True, then modify your code as follows: Private Sub Check2_Click() If Check2 = 1 Then Text1.text = Text1.text & "Bicycle" & vbCrlf End Sub And...
  13. Griffinator

    Need help importing date into Excel file

    Hi SeanGriffin, I tried as you suggested. Unfortunately when I do this it creates a format of 12/24/03 10:00. It completely truncates the seconds, as well as the AM/PM part. However, when I select any one of the date cells within the Excel spreadsheet, the value displayed in the current cell...
  14. Griffinator

    Need help importing date into Excel file

    I have "sort of" solved my own problem. The format is as follows: objExcel.Application.Cells(i, 1).Value = Format(strExportDate, "yyyy-mm-dd h:mm:ss:ampm") However, this will produce the following output: 2003-12-27 10:00:00:PM Is there another way to do this so that...
  15. Griffinator

    Need help importing date into Excel file

    I have a problem that I hope someone can help me with. I am exporting a CSV file into an Excel spreadsheet, and I am having problems importing the date for the current entry in the CSV file. The date in the CSV file is in yyyy-mm-dd h:mm:ss tt format (where tt is either AM or PM). The problem...
  16. Griffinator

    trap key press in MDI window

    Sorry, I also forgot to mention to set the KeyPreview = True in the form's properties!
  17. Griffinator

    trap key press in MDI window

    Hi, You could try trapping the keypress in the Form_KeyDown() Event Example: Private Sub Form_KeyDown(KeyCode as Integer, Shift as Integer) If KeyCode = vbKeyF1 Then 'write your code for the event here.... End If End Sub Good luck!
  18. Griffinator

    How to create multiple subfolders at one time

    For interests sake, I am posting my slightly modified version of strongm's previous post. The one minor glitch that I found was that it was prompting me to create each sub folder on each recursive call. The following code corrected this: Private Function ff_CreateSpecifiedPath(ByVal strPath...
  19. Griffinator

    How to create multiple subfolders at one time

    Thank you strongm!!! That works beautifully! A star for you. This place is awesome. You have no idea how many times this forum has pulled my behind out of the fire!
  20. Griffinator

    How to create multiple subfolders at one time

    vbkris, Yes, there is a FolderExists() function for the FileSystemObject which I am currently using to determine if the path the user has specified currently exists. If it doesn't, I need to be able to create the necessary subfolders that don't exist. This works fine using the CreateFolder()...

Part and Inventory Search

Back
Top