Search:

Type: Posts; User: ChrisE

Page 1 of 13 1 2 3 4

Search: Search took 0.29 seconds.

  1. Replies
    4
    Views
    133

    Re: I need help, please.

    I need a Crystal Ball in order to Help, I can't read that.
    Posting a proper question would be a start, with Code not a Picture
  2. Replies
    27
    Views
    605

    Re: Using Visual Basic to update excel file

    try this way for adding a new row



    'Ref:
    Option Strict On
    Imports Microsoft.Office.Interop.Excel
    Imports Microsoft.Office.Interop
  3. Replies
    27
    Views
    605

    Re: Using Visual Basic to update excel file

    you got me there :confused:
  4. Replies
    27
    Views
    605

    Re: Using Visual Basic to update excel file

    if were to use a Hammer I would go with Powerpoint as a Database
  5. Replies
    27
    Views
    605

    Re: Using Visual Basic to update excel file

    you can manipulate the Data in a Database Table, much easier than in the spreadsheet.
  6. Replies
    282
    Views
    22,845

    Re: Hamilton 5x World Champion ?

    a razor margin :confused:

    what a joke
  7. Replies
    22
    Views
    874

    Re: Drawing on a Track Bar

    don't know if this is an option for you.
    If I want to show somthing that happens within a Daterange I allways go with a Calendar. The Image below
    shows the status of an Employee... Sick, Holiday...
  8. Replies
    282
    Views
    22,845

    Re: Hamilton 5x World Champion ? now for the 8th Title ?

    changed the Titel, I'm pretty sure the 8th Title is gonna happen.
  9. Replies
    282
    Views
    22,845

    Re: Hamilton 5x World Champion ?

    yeah my Vote,turkish gp is best Race of the Year

    Hamilton was great, I think he will crack the 8th Title also
  10. Re: Speichern (saving) / Öffnen (opening) einer CSV-Datei von und zu einer DataGridVi

    it was actually JMC in Post#4 that said ...If you do want to stick with a CSV format, use a TextFieldParser to read the data.

    using a Schema.ini is also an option for .CSV files
  11. Re: How to copy many sheets in excel workbook to another sheet in another workbook?

    @meho
    I allready gave you an example in your other thread how to open a Workbook and access a sheet (your welcome by the way)

    where in this part you select the range to copy



    ...
  12. Re: Function Works in Excel Macro But Does not Work in VB.Net

    here some basics for working with Excel and .NET




    Option Strict On
    Imports Microsoft.Office.Interop.Excel
    Imports Microsoft.Office.Interop

    Public Class Form1
  13. VS 2017 Re: How To Save and Load Text File From and To DataGridView

    take a look at the Textfieldparser then

    https://docs.microsoft.com/en-us/dotnet/api/microsoft.visualbasic.fileio.textfieldparser?redirectedfrom=MSDN&view=net-5.0

    and ...
    ...
  14. VS 2017 Re: How To Save and Load Text File From and To DataGridView

    I agree with JMC, try it out with XML

    here a small sample



    Public Class Form2

    Private dt As New DataTable("myUsers")
    Private bs As New BindingSource
  15. Re: Function Works in Excel Macro But Does not Work in VB.Net

    why don't you just explain what you want to do with the sheet, rather than people try to figure out what your VBA code
    is doing
  16. VS 2008 Re: [RESOLVED] Split Database data into label size

    @ Andy

    you should be using the Stringbuilder for that kind of stuff,
    here a small sample



    Option Strict On

    Public Class Form2
  17. VS 2017 Re: Flowlayoutpanel index out of range when using TabControl

    ahh.. got it

    thanks Man from down under
  18. VS 2017 Re: Flowlayoutpanel index out of range when using TabControl

    don't see that number on each post ?
  19. Replies
    12
    Views
    415

    Re: Form regaining focus

    try and use the 'TabControl1.SelectedIndexChanged'
    to do your actions

    here a sample

    Private Sub TabControl1_SelectedIndexChanged(ByVal sender As Object, _
    ...
  20. VS 2017 Re: Flowlayoutpanel index out of range when using TabControl

    see if this helps, scroll to Post#15 in this thread
    https://www.vbforums.com/showthread.php?888088-Results-rankings-database-Help-Windows-Forms-Application-VB-Net
  21. VS 2017 Re: Flowlayoutpanel index out of range when using TabControl

    what is the purpose of this program, adding/showing days of the month in labels and then...???
  22. VS 2019 Re: Write a program that prints 50 asterisks to the form one at a time

    I feel bad for 'dennis' now, what have I started:blush:

    he'll never be back
  23. VS 2019 Re: Write a program that prints 50 asterisks to the form one at a time

    thanks Tyson
  24. VS 2019 Re: Write a program that prints 50 asterisks to the form one at a time

    I've seen both your questions, they must be the worst asked(regarding a problem you have) I've ever seen


    @admins
    how can I add negative points to a reputation
  25. Replies
    5
    Views
    365

    Re: iterate table in access database

    excellent explanation for Luca, hope he will Post less ...how to?... now
  26. Re: colour for buttons on datagrid to change if sql record exists

    @AMJADJ75

    everything you need to go threw the rows/cells is in Post#2

    perhaps a small sample will make it more clear
    load your Data then check the Values


    Public Class Form1
    Dim tb As...
  27. Replies
    13
    Views
    565

    Re: Access(mdb) Performance Issue

    that is the way to go then
  28. Replies
    13
    Views
    565

    Re: Access(mdb) Performance Issue

    see Post#6 the Function ExecuteSQL
    it uses OleDb.OleDbTransaction



    Public Sub MakeTables()
    Dim sSQL As String
    'the Database 'Contacts.mdb' has to exist already
    Dim...
  29. Replies
    13
    Views
    565

    Re: Access(mdb) Performance Issue

    @adam
    sure looks funny the way you create a Index in the Table

    here a sample how to create Table(s) with Foreign Key and Index

    Note: the .mdb has to exist


    Public Sub MakeTables()
    ...
  30. Replies
    43
    Views
    1,504

    Re: Vb6: Winsock data arrival multiple packets

    why not ask the Mod's to close this Thread if your not Happy with the response you get.

    your response ....all what you do is just blablablabla..... to the
    People that are trying to help is just...
  31. Re: Setting header text in different column for .xls file

    you can execute a SQL Statement from the Database directly to Excel
    this uses OLEDB


    Dim Filename As String

    Filename = "E:\Berichte\TestExcel.xlsx"

    'Select Data from...
  32. Re: Setting header text in different column for .xls file

    where does the Data come from ?


    EDIT:
    I posted this a while back for sombody, I use a semicolon for the delimiter
    you will have to change that to your needs.

    it creates a .csv from a...
  33. Re: Programmatically Apply The Same Formula To Each Cell In A User Selected Range

    I think you are in the wrong Forum
    should it not be the ..Office Development Forum...


    when working with .NET to Excel
    here a few samples
    note I'm in Germany so the Formula is SUMME don't...
  34. Re: Programmatically Apply The Same Formula To Each Cell In A User Selected Range

    the text in Blue doesn't make any sence
    1) a User has a Excel workbook open and a certain sheet.. say sheet1
    2) you want to keep track with a .NET App. what Range the User selects to apply a...
  35. Re: Code to Display Data Matrix Barcode Reading With Separators

    try and use Substring
    is the lenght allways the same ?


    Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click
    Dim s As String =...
  36. Replies
    5
    Views
    299

    VS 2017 Re: Read XML Attribute

    well why not use the Attribute(s) then



    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
    Dim x As XElement =...
  37. Replies
    5
    Views
    338

    Re: Trying to make two lists alternate

    Enumerable.Zip Method is you friend

    https://docs.microsoft.com/en-us/dotnet/api/system.linq.enumerable.zip?view=netcore-3.1

    with a little more research you would have found that on your own
  38. VS 2019 Re: Help! updating DGV cells with values from another DGV

    well my sample was just a sample, I wanted you to rethink the design,
    looks like you have got it solved.
  39. VS 2019 Re: Help! updating DGV cells with values from another DGV

    you should rethink the design, I don't think that "Horario" should be a column
    and would put that as the HeaderCell

    here a sample
    you need 3 Checkedlistboxes
    1 DGV and a Button



    Public...
  40. Re: "Best fit" problem: Split one array (or list) of strings into 2 arrays (lists)

    I had a problem a while back to split a Datatable to 3 Datagridviews, not sure about the Split with *


    here was my approach with a small sample


    Imports System.ComponentModel


    Public...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width