Search:

Type: Posts; User: ChrisE

Page 1 of 13 1 2 3 4

Search: Search took 0.25 seconds.

  1. Replies
    1
    Views
    85

    VS 2017 Re: Need Help With Importing .CSV Files

    well I can't see anything in that Image.

    the place to start would be to read a few Lines of the CSV

    Step 1.
    does the CSV have a Header?


    Dim CsvHeader =...
  2. Replies
    35
    Views
    1,107

    Re: Need help with a querry

    do some research on For Each....


    For Each xx In nn
    If someCondition Then
    GotID = True
    Exit For
    End If
    Next
  3. Replies
    35
    Views
    1,107

    Re: Need help with a querry

    I'm confused just like Sam, so I made a sample
    see if it helps

    you have to create the tables, I only made the Update routine to show the calculations

    here the code


    Option Explicit
  4. Replies
    35
    Views
    1,107

    Re: Need help with a querry

    well here a query done in access with just the one Table you have, but I think it really hurt's doing what your doing
    I called the Table 'Trans' with your sample Data

    the query in the Access...
  5. Replies
    36
    Views
    809

    Re: .txt files

    @AccessShell
    if you want to do this with pure VB6 you have to isolate the Column you want first and Format that number



    Private Function FormatColumnNumber(sCsv As String) As String
    Dim...
  6. Replies
    1
    Views
    221

    VS 2019 Re: Add Sort Combined TextFiles

    you forgot to add 'Order By'

    something like this

    Dim query = From line In combinedfiles
    Let state = Split(","c)(1)
    Let name = Split(","c)(0)
    ...
  7. Replies
    35
    Views
    1,107

    Re: Need help with a querry

    I've looked at your table for the last 10min, and I think you should be using 2 Tables
    the first Table for your items (price)
    the second Table for your Transactions (Deposits; Payments)

    well...
  8. Thread: LINQ question

    by ChrisE
    Replies
    9
    Views
    313

    VS 2017 Re: LINQ question

    this isn't my Code
    I found this sample but can't remenber where, I was looking at the time for 'Linq Join'

    see if it helps


    Public Class Form1

    Public Class Student
    Public...
  9. VS 2019 Re: Using arrays to add information to radio buttons/checkboxes on a form

    not sure what you mean, do you have to create the controls dynamic?
    this would add a GroupBox to a form



    Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles...
  10. Re: Unable to connect to any of the specified MySQL hosts

    try the ODBC Driver

    here an article
    https://www.c-sharpcorner.com/uploadfile/yougerthen/connect-to-mysql-database-via-odbc-without-using-dsn-part-ii/
  11. Replies
    322
    Views
    31,595

    Re: Hamilton 5x World Champion ?

    I bet that is why Bottas got another Contract for this season:rolleyes:

    I was impressed with Perez, wonder where he would have been if he didn't have that issue (what was it ?) at the start of the...
  12. Replies
    24
    Views
    739

    Re: Join two datatables

    I think you have to add Group Join


    Dim query = From CountedRow In acc.GetDataTable("STOCK").AsEnumerable()
    Group Join InventoryRow In...
  13. VS 2013 Re: DatagridView cell color to be changed to RED if the status is "Pending" else GREE

    I would use the...DataGridView1_CellFormatting


    Public Class Form1

    Dim tb As DataTable = New DataTable

    Private Sub Form1_Load(sender As System.Object, e As System.EventArgs)...
  14. Re: How to start exporting data to an excel file from a particular row of excel sheet

    you have some kind of Format(color in alternate row) in the sheet, add the Data first and then do the formatting to the rows
  15. Replies
    13
    Views
    776

    Re: RC6.CSV ignores blank lines

    just check it yourself

    Dim TR As String
    Dim s1 As String
    If InStr(1, s1, vbCrLf) > 0 Then
    TR = vbCrLf
    ElseIf InStr(1, s1, vbCr) > 0 Then
    TR = vbCr
    ...
  16. Replies
    322
    Views
    31,595

    Re: Hamilton 5x World Champion ?

    I had to get Sky in order to watch F1, since it's not on FreeTV anymore in Germany.
    I just hope that Red Bull and others can make this season a little more difficult for
    Mercedes.
  17. Replies
    18
    Views
    691

    VS 2010 Re: Character insertion process is very slow

    here a real simple replace



    Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
    TextBox1.Text = "welcome to vbForums, don't use a Timer if you...
  18. Replies
    9
    Views
    546

    Re: Offline Support for Database Operations

    well ADO did support Offline Recordsets, but I don't think that you want to use ADO

    did find this https://docs.microsoft.com/en-us/sql/ado/reference/ado-api/filtergroupenum?view=sql-server-ver15
  19. Replies
    12
    Views
    473

    VS 2019 Re: Not able to read cell data from Excel

    well I showed you how to read, this will write to cell's
    you just need to name the Cell



    Private Sub Button2_Click(sender As System.Object, e As System.EventArgs) Handles Button2.Click

    ...
  20. Replies
    12
    Views
    473

    VS 2019 Re: Not able to read cell data from Excel

    what do you actually want to read? is it a Range from Excel say... A1:G100

    you speak of Cell Property what does that mean ? a Value or ????
  21. Replies
    12
    Views
    473

    VS 2019 Re: Not able to read cell data from Excel

    see if this helps



    Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click
    DataGridView1.Columns.Add("Test", "Test")
    Try
    ...
  22. Replies
    12
    Views
    473

    VS 2019 Re: Not able to read cell data from Excel

    don't see how that work's?
    if rowcount is 4, it will add a 4 to the Datagridview, not the value that is in A2 in Excel
  23. Replies
    3
    Views
    330

    VS 2019 Re: Zero value problem in datagridview

    I put your Min/Max in Function's



    Option Strict On

    Public Class Form1
    Private dt As New DataTable()

    Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles...
  24. Replies
    18
    Views
    691

    VS 2010 Re: Character insertion process is very slow

    if you want to speed up the process, then answer the question(s) you were asked
    if you want to speed up the process, then don't use a Timer
    if you want to speed up the process, ......

    sorry I'm...
  25. Replies
    18
    Views
    691

    VS 2010 Re: Character insertion process is very slow

    :confused::confused:

    dday asked...
  26. Replies
    18
    Views
    691

    VS 2010 Re: Character insertion process is very slow

    using a Timer seem's strange if you want to replace character/string?
  27. Replies
    13
    Views
    484

    Re: Adding an item to a CheckedListBox control

    not sure what you mean with clear
    do you mean the item(s) Checkedstate ?

    if so you can use the 'CheckedListBox1.CheckedIndices'

    something like this


    Private Sub Button1_Click(sender As...
  28. Replies
    27
    Views
    855

    Re: open excel and add values to cells

    try and change the Com Ref. to a diffrent version 16.0 or 14.0
    don't know what is avalible on your system
  29. Replies
    27
    Views
    855

    Re: open excel and add values to cells

    don't do that, see if sombody else will chip in that is using VS 2019. It really is strange that it won't work
  30. Replies
    27
    Views
    855

    Re: open excel and add values to cells

    I use VS 2010, the selection in VS 2019 is diffrent
    but if you say it's there for selection then somthing else is wrong.
  31. Replies
    27
    Views
    855

    Re: open excel and add values to cells

    I just checked
    ->Assembiles
    -->Extensions

    It is just a guess that if you can't find/see Excel there, that Office/Excel isn't Installed properly
  32. Replies
    27
    Views
    855

    Re: open excel and add values to cells

    well I don't have VS 2019 so somebody else will have to chip in.
  33. Replies
    27
    Views
    855

    Re: open excel and add values to cells

    add the Ref. but select from .NET
    see image

    180575
  34. Replies
    27
    Views
    855

    Re: open excel and add values to cells

    which Office Version do you have Installed ? perhaps the Office need's a new Install
  35. Re: DataTableAdapter.Fill Error: Command is missing required clause

    this look's like a typo


    Dim csPhoto As String = ""
    csPhoto = "Provider=vfpoledb;Data Source=" & UserFolder & "csphoto.udb;Extended PropELerties=dBASE IV;User...
  36. Replies
    27
    Views
    855

    Re: open excel and add values to cells

    well I just tried your code without Option Strict On
    and it created the Excelfile



    Private Sub Button2_Click(sender As System.Object, e As System.EventArgs) Handles Button2.Click
    Dim...
  37. Replies
    27
    Views
    855

    Re: open excel and add values to cells

    looks like a Ref. to Office.Interop is missing

    like Delany said...





    Option Strict On
    Imports Microsoft.Office.Interop.Excel
  38. Re: Data Grid Replaces the next File Data instead of copying after the first file

    I wonder how Meho is going to handle which Data came from which Excel File/Sheet
    if some Data is "wierd" or "what a funny Value" if put all in one File.

    I don't think he has thought this threw...
  39. Re: Data Grid Replaces the next File Data instead of copying after the first file

    you have been guided twice to the problem/issue, once in red and once in blue

    perhaps I explain crap, so I will let other's give it a try

    good luck
  40. Re: Data Grid Replaces the next File Data instead of copying after the first file

    I can't see any change, looks just like Post#1
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width