Search:

Type: Posts; User: ChrisE

Page 1 of 13 1 2 3 4

Search: Search took 0.34 seconds.

  1. Replies
    8
    Views
    494

    VS 2019 Re: Need help converting VBA to VB.Net

    here you go...with DAO
    it won't work with Option Strict On, but I'm not going to try further with DAO an resolve that also



    'Option Strict On
    Imports Microsoft.Office.Interop.Access.Dao

    ...
  2. Replies
    8
    Views
    494

    VS 2019 Re: Need help converting VBA to VB.Net

    try this way



    Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click
    Using cnn As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;data...
  3. Replies
    6
    Views
    296

    VS 2019 Re: Changing excel cell color using vb.net

    do some research on then WorkBook Save method

    here a sample



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

    Public Class Form1
  4. Replies
    6
    Views
    296

    VS 2019 Re: Changing excel cell color using vb.net

    well like paul I am unsure what you want.

    do you want to change the color and then Save? because there is no Save statement in your code anywhere
  5. Re: Why is VB.Net/C#/XAML + VS2019 is better than VB6? Here's why.....

    the point here is that it was not possible to just change the LED, everything else was fine.
  6. Re: Why is VB.Net/C#/XAML + VS2019 is better than VB6? Here's why.....

    I understand your point..
    I was trying to make a point that we don't seem to care about resources

    look at a DVD-Player for instance, that is the technology you are talking about right ?...
  7. Replies
    38
    Views
    1,404

    Re: [RESOLVED] Why can't Enum of VB6 be a string?

    use the proper tool for the Job

    in a Modul


    'Module1

    Option Explicit

    Private Col As Collection
  8. Re: Why is VB.Net/C#/XAML + VS2019 is better than VB6? Here's why.....

    that's the main problem in this World right now. Nobody seem's to care ....:
    As "bloated" as these modern tools and frameworks might be, they do exactly etc....
    or
    For all the extra mega-bytes of...
  9. Re: I think VB6 is much a better tool/language than VB.NET

    I have to agree with Post#5

    but perhaps it is just faith what we do and use.... and it's all down to our zodiac sign
    182161

    a Oracle User is Taurus the Bull
    a Vb6 User is ?????
    a .Net User...
  10. Replies
    154
    Views
    5,580

    Re: Some thoughts on VB6 forum

    lucky you,
    I've got another year or two
  11. Replies
    2
    Views
    347

    VS 2017 Re: Open Excel and avoid dialog boxes

    well you can use..


    xlsApp.DisplayAlerts = False


    but are you sure that you want to disable warnings?
  12. Replies
    154
    Views
    5,580

    Re: Some thoughts on VB6 forum

    just Program the way you need to, don't try and please somebody else. I took up .Net
    in 2017 mostly because I needed it for Office (Outlook and Excel) automation.

    I really can't see any Database...
  13. Replies
    154
    Views
    5,580

    Re: Some thoughts on VB6 forum

    that is true,it's like a Builder becoming a Poledancer
    https://www.youtube.com/watch?v=kCJMGOkq_ss
  14. Replies
    2
    Views
    380

    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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. Re: Would like to convert Few VBA-Excel subroutines to VB.Net19

    OK
    good luck
  21. 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
  22. Replies
    12
    Views
    779

    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.
  23. 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
  24. 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...
  25. 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)...
  26. Replies
    37
    Views
    19,558

    Re: [RESOLVED] Remove trailing NewLines from string

    the Function might work, but ever heard of replace
  27. Replies
    25
    Views
    1,457

    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) =...
  28. 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...
  29. Replies
    3
    Views
    458

    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")...
  30. Replies
    5
    Views
    418

    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...
  31. Replies
    12
    Views
    977

    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...
  32. 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
  33. Re: Any better method to incorporate particular Range from Excel Sheet to ListView

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

    I gave you a sample with OLEDB .. here ..
    ...
  35. 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...
  36. Replies
    53
    Views
    2,979

    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"...
  37. Replies
    411
    Views
    53,231

    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...
  38. 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...
  39. Replies
    411
    Views
    53,231

    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...
  40. Replies
    20
    Views
    1,217

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

    +1 to that
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width