Search:

Type: Posts; User: ChrisE

Page 1 of 13 1 2 3 4

Search: Search took 0.32 seconds.

  1. Re: Error : System.InvalidCastException: 'Conversion from string "Sheet1" to type 'In

    it really is quit simple to rename a Sheet



    Private Sub Button34_Click(sender As System.Object, e As System.EventArgs) Handles Button34.Click
    Try
    Dim xlApp As New...
  2. Replies
    53
    Views
    722

    Re: Unable to Access MySQL Remotely

    peterst is right with ...It is job of the network admin to setup port forwarding and to give you these details

    here a step by step sample with the Fritzbox just to show what "port forwarding"...
  3. Replies
    362
    Views
    36,270

    Re: Hamilton 5x World Champion ?

    I sure hope thy find the issue, I mean at thast speed the car could have gone anywhere.
    I can't remember which year or what Team it was (in Spa I think), but the Car took of like a plane into the...
  4. Re: Refining AutoComplete Search Combobox from VBA Excel to VB.Net 19 with 2 question

    Hi Sam,

    for filtering and searching Data I would use OLEDB, it's much less code and easy to adjust

    here a small sample, this is what the sheet looks like
    181619



    and here the code for...
  5. Replies
    362
    Views
    36,270

    Re: Hamilton 5x World Champion ?

    I'm just glad nobody was hurt, I mean a that speed the car could have gone anywhere.
    I wonder what Pirelli has to say about it, probably ...they picked up ..this or that.. and
    that was the...
  6. Replies
    20
    Views
    597

    Re: [RESOLVED] get part of string between ( )

    +1 to that
  7. Replies
    20
    Views
    597

    Re: [RESOLVED] get part of string between ( )

    using RegEx is probably an overkill



    With oRegex
    .Pattern = "\(((.*?))\)"
    .Global = True
    .MultiLine = True
    'etc.. more code
  8. Re: visual studio 2017 how can i store a pdf document in sql server?

    to get the file something along the lines

    "varFilePath" is for the File you want


    Dim file() As Byte
    Using stream = New FileStream(varFilePath, FileMode.Open, FileAccess.Read)
    ...
  9. Re: Creating a New Project in Vb.net 2019 for Excel

    the (1) has to be a (2)
    as it is the second sheet
  10. Re: Creating a New Project in Vb.net 2019 for Excel

    thanks Delaney,
    the Loop isn't need at all, that's what happens when you copy and Paste without double checking
    I would have "rep" you bit I get the message...you must spread around, which I find...
  11. Re: Creating a New Project in Vb.net 2019 for Excel

    what is Installed ?
    only Excel or Office(Word,Excel etc...)

    I tested the Code and it works, I have Office Pro 2010 Installed
  12. Re: Creating a New Project in Vb.net 2019 for Excel

    Hi,

    here a start, this sample will create a Excelfile,add Sheet(s), Name the Sheet(s), and add
    some Data to Cells


    Option Strict On

    'add Ref.
    Imports Microsoft.Office.Interop.Excel
  13. Replies
    8
    Views
    294

    Re: PROGRESSBAR until load form is finisshed

    Luca do some research on ...

    rs.AbsolutePostion
  14. Replies
    5
    Views
    315

    Re: Is it possible to do this sum?

    look's like he's back to square one.. see here...
    https://www.vbforums.com/showthread.php?891254-RESOLVED-Need-help-with-a-querry
  15. VS 2010 Re: HOW TO READ ALL DATA FROM weight scale INTO TEXTBOX visual basic 2010

    well you are in the wrong Forum for that, see the other Forum...Open Positions (Jobs)
    if you want Full Code you will have to pay, unless somebody will do it for free here
  16. Replies
    54
    Views
    1,383

    Re: The fastest StringRepeat algorithm

    Public Function StrRepeatChrisE1(ByRef Text As String, ByVal Count As Long) As String
    Dim lLength As Long
    If Count > 0 Then
    lLength = Len(Text)
    If lLength > 1 Then
    If...
  17. Replies
    9
    Views
    247

    Re: MS Access Replace in query Update

    you can use Replace in a Query



    SELECT tbl_Replace.ID, tbl_Replace.TestName, Replace([TestName],"to","with") AS AfterReplace
    FROM tbl_Replace;


    see Image before after
  18. Replies
    5
    Views
    196

    Re: SELECT record from to dates

    did you try the search or Codebank ?
    did you try a google search ?

    your here since 2005 and still end you questions with...

    i need ...
    or
    how to ?

    come on Luca, try and start programming...
  19. Replies
    9
    Views
    429

    Re: Create a DataTable from a txt file

    why don't you upload the text File ? cause it's just a guessing game
  20. Re: SQL Command adding Date parameter really DateTime

    have you tried to just replace/swap the first two digits with Left.....
    I know this is not SQL


    Dim s As String = "0220-11-20"

    Dim reformat = "20" & s.Substring(2)

    ...
  21. Re: Convert from 24hr time in db to 12hr time in program

    if you are using a DataAdapter then the field should be a Time or DateTime in the Database, be careful not to make
    a mess of your Table in the Database (don't know if you update that value ???)
    ...
  22. Re: placing shapes in excel using vb.net 2010

    well I don't know why it isn't working for you, what error message do you get?
    and show me the exact code you are using
  23. Re: placing shapes in excel using vb.net 2010

    well it works for me in VS2010 and Office 2010 Pro.
  24. Re: placing shapes in excel using vb.net 2010

    did you add the Ref.s



    Imports Microsoft.Office.Interop.Excel
    Imports Microsoft.Office.Interop
    Imports Microsoft.Office.Core

    this sample was done in VS2010
  25. Re: placing shapes in excel using vb.net 2010

    here a bit modified, you can add the color you want now



    Imports Microsoft.Office.Interop.Excel
    Imports Microsoft.Office.Interop
    Imports Microsoft.Office.Core

    Public Class Form3
  26. Re: Convert string to VB6 code,maximized characters

    that is just nonsense,for what purpose?
    I'm outa here
  27. Re: placing shapes in excel using vb.net 2010

    gvgbabu will have to answer that
  28. Re: placing shapes in excel using vb.net 2010

    the code in Post#1 doesn't look like .NET
    if you want to add/desing shapes in Excel you have to Import Office.Core

    here a sample


    Imports Microsoft.Office.Interop.Excel
    Imports...
  29. Re: how to intercept a string of a specified length by vb6?

    I can't follow what you want
    do you want to remove Characters? or ????

    did you try regex to split at the n Character


    Private Sub Command1_Click()
    Dim TXT As String
    Dim regSplit As Match
  30. Re: how to intercept a string of a specified length by vb6?

    my guess..



    Option Explicit

    Private Sub Form_Load()

    Dim s As String
    Dim i As Long
  31. Re: Reflection getting property names returns base class properties last

    nice Jmc :thumb::)
    any way to tell which User has those classes in use? probably just with a UserClass
  32. Replies
    12
    Views
    538

    VS 2019 Re: How to simplify and compress code?

    missed that part where he need's 2 Textboxes per checkbox, but I think the OP has enough to work with now
  33. Replies
    12
    Views
    538

    VS 2019 Re: How to simplify and compress code?

    I think using a Dictionary is better to read



    Public Class Form1


    Private Sub WireUpCheckboxesWithTextboxes()
    Dim kvps = New Dictionary(Of CheckBox, Control) From {{CheckBox1,...
  34. Replies
    18
    Views
    621

    VS 2019 Re: Create a List for multiple entries

    that's what I meant by Count afterwords.
    it would find files with one or all three search strings
  35. Replies
    18
    Views
    621

    VS 2019 Re: Create a List for multiple entries

    don't know what you mean, you see the found Files in the Listbox
  36. Replies
    12
    Views
    571

    Re: [MSDOS\VBDOS] Change font Symbol

    here a link
    http://www.antonis.de/faq/qbmonfaq-dateien/475794307.html

    and here for use of TT-Fonts (QBFonts.zip)
    http://www.antonis.de/qbdown/qbtext.htm
  37. Replies
    18
    Views
    621

    VS 2019 Re: Create a List for multiple entries

    I use a Powershell script to:
    1) read all the Filenames is a Folder
    2) create a .csv File from that
    3) read that .csv File to a Database Table
    4) perform SQL Query for my search

    I don't know...
  38. Replies
    18
    Views
    621

    VS 2019 Re: Create a List for multiple entries

    I would search the folder first for Files that contain any of the keywords and count later. I don't know how many Files you
    have in the folder.
    might be quicker that way, first the search and then...
  39. VS 2019 Re: Installment system with invoice dividing in VB.NET

    well if you solved it, you should show your solution, and then mark this thread as Resolved with the Thread Tools.

    your attachment doesn't work!
  40. Re: SharpDevelop 5.1 Visual form designer function is invalid ON VB.NET?

    I hoped he would never start .NET, but here we are...:rolleyes:
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width