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

    regsvr32 command through VB

    Trying using the silent switch. Shell "Regsvr32 /s NameofComponent.dll"
  2. FRoeCassNet

    reading data from file... problems

    I'm not sure your problem is with a comma so much as it is that the string doesn't have a &quot;<&quot; in it. The way you use the loop: Do While character <> &quot;<&quot; will continue forever if your string doesn't have a &quot;<&quot; in it character.
  3. FRoeCassNet

    how to scan for a certain folder name

    A very quick and dirty approach is: Dim fso As FileSystemObject On Error Resume Next Set fso = New FileSystemObject fso.MoveFolder &quot;c:\test\Foo&quot;, &quot;c:\test\archive\&quot; Set fso = Nothing Then the MoveFolder method will fail (error 76, path not found) if the folder doesn't...
  4. FRoeCassNet

    extracting numbers from a string

    If you don't know how many numbers there are or where they are, you can do a simple loop: Dim s As String Dim sNum As String Dim i As Integer s = &quot;05hdmj09kj03&quot; sNum = &quot;&quot; For i = 1 To Len(s) If IsNumeric(Mid(s, i, 1)) Then sNum = sNum & Mid(s, i, 1) Next Debug.Print sNum
  5. FRoeCassNet

    overwrite file without prompt

    Try adding FOF_NOCONFIRMATION to the .fFlags property
  6. FRoeCassNet

    Evaluating recordset

    Try using the modulus operator (returns the remainder). If Qty Mod Pack = 0 Then 'Full packs Else 'There not all full packs End If
  7. FRoeCassNet

    Modifying columns in a datatable dynamically?

    You can use a DataTable object's DataColumnCollection to add/remove columns. However, if you're also using a dataset, then you'll have to update the schema also with something like WriteXmlSchema() Hopefully this will get you pointed in the right direction. Dim cols As DataColumnCollection =...
  8. FRoeCassNet

    VBA... Split -or- STRIKE!

    I believe split() was added to VBA in the office 2000 version.
  9. FRoeCassNet

    Incrementing a variable and retaining the format

    numbers don't have leading zeros, text strings that represent numbers can though. What you need to do is format the number as a string when outputting it. Since the length of the string changes, get that first. nLength = Len(strTmp(1)) Then format your number to that size Msgbox...
  10. FRoeCassNet

    determine if PRG was launched from drap/drop operation

    You are correct, but I believe mscott was looking for dropping an object onto his &quot;non-running&quot; shortcut, not dropping onto a currently running program.
  11. FRoeCassNet

    Greetings I have written a serie

    A lot depends on how you created your StrArray Class, but if like a normal array with an index and upper/lower bounds, why not just loop through it that way. For i = lbound(c.param) to ubound(c.param) set p = c.param(i) .... Instead of the For Each p In c.Param
  12. FRoeCassNet

    How to Yield Processor Time (ie, doevents)

    You're right about the doevents in the service, wasn't reading real close :/ Did you use the SetTimer() function to create the timer and if so, how long of a delay did you give it? Maybe the delay was too long, try setting it to a smaller delay and the use the datediff to determine the 10 minutes.
  13. FRoeCassNet

    determine if PRG was launched from drap/drop operation

    I hope this is embarrasingly simple.... I believe that by default if you &quot;drop&quot; a file onto an exe from Windows Explorer, it will pass the filename to the program as the first parameter. So, if you drag the file &quot;C:\Foo.txt&quot; and drop it onto myprog.exe, you'll get the...
  14. FRoeCassNet

    How to Yield Processor Time (ie, doevents)

    The DoEvents methods exists in: System.Windows.Forms.Application.DoEvents() I'm not sure this will take care of your CPU utilization since you'll still be in a tight loop though. Any idea what was causing the Timer to be flaky?
  15. FRoeCassNet

    Best Way to Add Hierarchical DataSet to TreeView

    Have you looked at the DataGrid? It has what may (may not) be what you're looking for. With hierarchical data, it'll display the top node records with a plus expand down to child rows and so on.
  16. FRoeCassNet

    Sorting a column in a Listview (numerically)

    Simplest way is to make sure all your values are the same length (pad to left with spaces to maximum length). So for the values of &quot;3&quot;, &quot;32&quot; and &quot;310&quot; you would insert them as &quot; 3&quot;, &quot; 32&quot; and &quot;310&quot;, etc. Then when it sorts them...
  17. FRoeCassNet

    Format textbox

    Text2.Text = Right(&quot;000000&quot; & Text1.Text, 6)
  18. FRoeCassNet

    ComboBox item selection by code

    If you keep your objects in something that supports the IList interface (like a Dataset or Array, etc.) then you can just simply bind the combobox to it. You would set the ValueMember of the combo to the number and the DisplayMember to the text.
  19. FRoeCassNet

    Help with basic SELECT statement

    ...txtDate field. Either use JohnYingling's example, or look into your database documentation to what it uses for a CDate() type of function. For instance, in SQL Server you could do something like SELECT * FROM vTestEditor WHERE convert( varchar(10),DatePerformed,101)=&quot; &...
  20. FRoeCassNet

    cryptography please help

    I haven't looked to closely, but at first glance.... You're writing to a (System.IO.MemoryStream), but you never move back to the start of the stream before trying to read it in again. a.Seek(0, IO.SeekOrigin.Begin) while rdlen < totlen len = a.Read(bin, 0, 100) encStream.Write(bin, 0...

Part and Inventory Search

Back
Top