Search:

Type: Posts; User: ChrisE

Page 1 of 13 1 2 3 4

Search: Search took 0.05 seconds.

  1. Re: Any better method to incorporate particular Range from Excel Sheet to ListView

    I allready gave you a sample(s) to load and filter Excel Data with oleDB



    Option Strict On


    Public Class Form1
  2. Re: Any better method to incorporate particular Range from Excel Sheet to ListView

    SamD
    Thread 2: 892141 :
    15
  3. Re: An Ideal option required instead of Listbox. Coud you suggest

    I gave you a sample with OLEDB .. here ..
    ...
  4. 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...
  5. Replies
    53
    Views
    782

    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"...
  6. Replies
    363
    Views
    36,706

    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...
  7. 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...
  8. Replies
    363
    Views
    36,706

    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...
  9. Replies
    20
    Views
    637

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

    +1 to that
  10. Replies
    20
    Views
    637

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

    using RegEx is probably an overkill



    With oRegex
    .Pattern = "\(((.*?))\)"
    .Global = True
    .MultiLine = True
    'etc.. more code
  11. 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)
    ...
  12. Re: Creating a New Project in Vb.net 2019 for Excel

    the (1) has to be a (2)
    as it is the second sheet
  13. 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...
  14. 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
  15. 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
  16. Replies
    8
    Views
    311

    Re: PROGRESSBAR until load form is finisshed

    Luca do some research on ...

    rs.AbsolutePostion
  17. Replies
    5
    Views
    328

    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
  18. 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
  19. Replies
    54
    Views
    1,467

    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...
  20. Replies
    9
    Views
    255

    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
  21. Replies
    5
    Views
    213

    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...
  22. Replies
    9
    Views
    446

    Re: Create a DataTable from a txt file

    why don't you upload the text File ? cause it's just a guessing game
  23. 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)

    ...
  24. 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 ???)
    ...
  25. 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
  26. Re: placing shapes in excel using vb.net 2010

    well it works for me in VS2010 and Office 2010 Pro.
  27. 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
  28. 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
  29. Re: Convert string to VB6 code,maximized characters

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

    gvgbabu will have to answer that
  31. 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...
  32. 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
  33. 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
  34. 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
  35. Replies
    12
    Views
    548

    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
  36. Replies
    12
    Views
    548

    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,...
  37. Replies
    18
    Views
    623

    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
  38. Replies
    18
    Views
    623

    VS 2019 Re: Create a List for multiple entries

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

    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
  40. Replies
    18
    Views
    623

    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...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width