Search:

Type: Posts; User: ChrisE

Page 1 of 13 1 2 3 4

Search: Search took 0.26 seconds.

  1. Replies
    2
    Views
    100

    RansomWare ..WannaDrive...

    I thought that this is an article everyone should read

    https://www.escrypt.com/sites/default/files/documents/Ransomware-against-cars.pdf

    just think if your sitting in your car and the next...
  2. Re: [RESOLVED] VB6: Question - Databases, where do I start?

    I would like to add to the List

    6. I still have my 190 2.5 Liter Mercedes Diesel bought in 1991, it's got 965.000Km on the Clock, I'm going for the 1 Mio.Km

    other List
    6. I know I should buy a...
  3. VS 2019 Re: Access DB and Timer not running tasks when its time - Conversion from string too

    use a query and narrow it down to an hour perhaps?

    this is what the query could look like


    SELECT tbl_Ticket.TicketBought, Format([tbl_Ticket].[TicketBought],"hh:nn:ss") AS MyTime, *
    FROM...
  4. Re: Would like to convert Few VBA-Excel subroutines to VB.Net19

    @Sam

    well I am not here to Breastfeed, did you lookup what that means


    it would be like me asking....where can I buy the best crossiants in Paris...
    I'll let Sam look or just wait for...
  5. Re: Would like to convert Few VBA-Excel subroutines to VB.Net19

    this is a good place to start then learning SQL....
    https://www.w3schools.com/sql/


    here a sample with Image, I created a new Sheet for this named Sheet2


    Private Sub Button1_Click(sender...
  6. Re: Would like to convert Few VBA-Excel subroutines to VB.Net19

    @Sam

    like Paul said, the DGV is the better option.

    what are you filling anyway from the Excel sheet?

    Private Sub CmdAddSelectedItems_Click(sender As Object, e As EventArgs) Handles...
  7. Re: Would like to convert Few VBA-Excel subroutines to VB.Net19

    OK
    good luck
  8. Re: Would like to convert Few VBA-Excel subroutines to VB.Net19

    @Sam

    why does it have to be a Listview?
    As I have shown you before the way to go is to use OLEDB



    Option Strict On
  9. Replies
    12
    Views
    525

    Re: Month calendar

    I started a Monthcalender a while back it uses a Datagridview. I didn't finish it because I went with a YearView rather than just the Month.
    I can dig it out if you want to continue and finish it.
  10. Re: VISUAL STUDIO 2017 how can i to get specific number or name from a long string?

    Oh Salsa31 what should I comment?

    you joined in 2011, and have over 5000 post's
  11. Re: Retrieving the correct Identity number during an Add and cascade to child dataada

    Hi,

    I am just guessing because I don't use the "BindingSource" stuff.

    but perhaps for Adding records you have to declare a "New" ?

    I took JMC's code


    Data.Relations.Add(New...
  12. Re: VISUAL STUDIO 2017 how can i to get specific number or name from a long string?

    I had somthing similar the other day and used RegEx

    the Patern works on you Json also, I put your Json in a Textfile


    Private Sub Button1_Click(sender As System.Object, e As System.EventArgs)...
  13. Replies
    37
    Views
    18,312

    Re: [RESOLVED] Remove trailing NewLines from string

    the Function might work, but ever heard of replace
  14. Replies
    24
    Views
    651

    Re: VB6 Won't Update mdb database

    what record do you want to edit ?
    the first
    the last


    Set SYS1 = DBASE.OpenRecordset("SYSTEM", dbOpenTable, dbSeeChanges, dbPessimistic)

    SYS1.Edit
    SYS1(1) = Year(Date)
    SYS1(2) =...
  15. VS 2019 Re: Possible? Using VB to interrogate large amounts of data in Excel

    if the Data is a CSV File then query the CSV, why pass the CSV to Excel and then
    work with the Data?

    you can use a Schema.ini to define each element in the CSV ..Integer,Date ..etc..

    you can...
  16. Replies
    3
    Views
    269

    Re: Read XML file and insert into ListBox

    give this a try



    Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click
    Dim xelement As XElement = xelement.Load("D:\Testfolder\Ange1992.xml")...
  17. Replies
    5
    Views
    325

    VS 2013 Re: How to Increase line spacing

    don't know if this is an option, but you can use Regex with character count.
    here a sample, place a Richtexbox on the form.



    Private Sub Button14_Click(sender As System.Object, e As...
  18. Replies
    12
    Views
    807

    Re: Few questions on Listview VS2019

    your code makes no sence, here you define a Range to load ..

    With wKsSht1
    xlRange = .Range("B3:E9")
    End With

    which is 4 columns

    but you only add one column to your...
  19. 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
  20. Re: Any better method to incorporate particular Range from Excel Sheet to ListView

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

    I gave you a sample with OLEDB .. here ..
    ...
  22. 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...
  23. Replies
    53
    Views
    1,578

    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"...
  24. Replies
    385
    Views
    41,824

    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...
  25. 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...
  26. Replies
    385
    Views
    41,824

    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...
  27. Replies
    20
    Views
    935

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

    +1 to that
  28. Replies
    20
    Views
    935

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

    using RegEx is probably an overkill



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

    the (1) has to be a (2)
    as it is the second sheet
  31. 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...
  32. 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
  33. 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
  34. Replies
    8
    Views
    468

    Re: PROGRESSBAR until load form is finisshed

    Luca do some research on ...

    rs.AbsolutePostion
  35. Replies
    5
    Views
    470

    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
  36. 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
  37. Replies
    54
    Views
    2,050

    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...
  38. Replies
    9
    Views
    395

    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
  39. Replies
    5
    Views
    292

    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...
  40. Replies
    9
    Views
    530

    Re: Create a DataTable from a txt file

    why don't you upload the text File ? cause it's just a guessing game
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width