Search:

Type: Posts; User: ChrisE

Page 1 of 13 1 2 3 4

Search: Search took 11.53 seconds.

  1. Replies
    13
    Views
    343

    Re: Access(mdb) Performance Issue

    that is the way to go then
  2. Replies
    13
    Views
    343

    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...
  3. Replies
    13
    Views
    343

    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()
    ...
  4. Replies
    43
    Views
    1,071

    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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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 =...
  10. Replies
    5
    Views
    197

    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 =...
  11. Replies
    5
    Views
    247

    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
  12. 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.
  13. 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...
  14. 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...
  15. Replies
    18
    Views
    887

    Re: [RESOLVED] Problem with Color.FromName

    nice one
  16. Re: How to get data from multiple databases to a master database

    the way I see it you need two loops
    one for the Database(s) and the other for the Tables
    so one Database after another

    D:\N_Backup.accdb would be the Database where you store everything
    not...
  17. Re: rows in incorrect order when inserting into SQL database

    I've took 2 Job's over the last 10 year's (still don't know why I took the second one) trying
    to reconstruct Database from Backup's... and it was a nightmare....
    the person(only 1 Person) had...
  18. Re: rows in incorrect order when inserting into SQL database

    still sounds like a nightmare to me
  19. Re: rows in incorrect order when inserting into SQL database

    I'm always amazed that Data is deleted completly, what if you have to reconstruct Data ?

    the way I handle this, is that in the Database Table there are 2 extra Fields:
    DeletedBy = here I save the...
  20. Replies
    27
    Views
    760

    VS 2015 Re: Calculations not calculating? VBS 2015

    you were just deep undercover and checking if you should join or not:bigyello:
  21. Replies
    27
    Views
    760

    VS 2015 Re: Calculations not calculating? VBS 2015

    you need to Debug your Text, because you calculation is wrong
    joined 2002
    now 2020

    but 20+ around here :confused:

    sorry couldn't resist
  22. Replies
    17
    Views
    497

    VS 2017 Re: Importing CSV Strings as numbers

    hi,

    in this String you have 'DialogDirect'

    Dim txtCon As OleDb.OleDbConnection = New OleDb.OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;Data Source='" & DialogDirect & "';Extended...
  23. Replies
    21
    Views
    605

    VS 2015 Re: ClosedXML Export Import Datagridview

    I think you are making this far to complcated

    create a new Project and try this....
    it will save whatever is in the DGV to a CSV File that you can open with Excel,
    or execute the next Part also...
  24. Replies
    21
    Views
    605

    VS 2015 Re: ClosedXML Export Import Datagridview

    the way I filter the Data from the Database Table and send it directly to Excel is more efficient to me.

    I can filter as many times I want and send the results to a new Sheet in the Excel...
  25. Replies
    21
    Views
    605

    VS 2015 Re: ClosedXML Export Import Datagridview

    well that was helpful Information... I mean that you are using a Access DB
    here one way to filter and export directly to a Excel .xlsx



    Option Strict On
    Imports System.Data.OleDb

    ...
  26. Replies
    21
    Views
    605

    VS 2015 Re: ClosedXML Export Import Datagridview

    sorry but I don't download Files from people I don't know
  27. Replies
    21
    Views
    605

    VS 2015 Re: ClosedXML Export Import Datagridview

    you could use a Schema.ini to Export the DGV to a Excelsheet

    what do you mean by this ?

    is the data in a Database, and you are loading this to a Datagridview
    if so what Database are you using
  28. Replies
    2
    Views
    229

    VS 2019 Re: Required support to code a application

    I think there's another Forum for this...Open Positions...
    where you can Hire somebody

    this Forum is to Help if you have a Problem not to write Software for you
  29. Re: Import from .csv file into MySQL

    JMC beat me

    I'll post anyway



    With cmd.Parameters
    .Add("@Vessel", MySqlDbType.VarChar, 50, "vessel")
    End With
  30. Replies
    7
    Views
    469

    Re: Parameter Issues

    I think that's the issue
    if you create the ParmeterQuery with Code you have to pass the Type



    Set qdf = dbs.CreateQueryDef("myQuery")
    strSQL = "PARAMETERS Param1 TEXT, Param2...
  31. Replies
    7
    Views
    469

    Re: Parameter Issues

    I havn't done this for a long time, but the way you pass the parameter looks wrong

    should look something like this


    Dim qd As QueryDef
    Set qd = db.QueryDefs("QueryName")...
  32. Re: [RESOLVED] SQL - Query to list all year-to-date weeks and sum up occurrences of t

    I was board,
    sitting here on a 5 week Job with a 2-3 hour workday (a Bank in Frankfurt)
    seem's everybody is in Homeoffice, creepy sometimes
    this must be the most boring, but well paid Job in the...
  33. Re: [RESOLVED] SQL - Query to list all year-to-date weeks and sum up occurrences of t

    don't be lazy
    here a start


    Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click
    Dim nYear As Integer
    Dim nMonth As Integer
    ...
  34. VS 2019 Re: Reading only one field from CSV file using TextFieldParser.ReadFields Method

    this should help

    Private Sub Button5_Click(sender As System.Object, e As System.EventArgs) Handles Button5.Click
    Dim Dateiname As String = "D:\TestFolder\Users.txt"
    Using...
  35. Replies
    43
    Views
    1,281

    VS 2017 Re: Advice On Storing Member Data in Text Files

    follow the Instructions you got from Wes

    1) did Wes add a | at the end to make it neat ?
    2) well what did you do wrong then= see 1)
  36. VS 2017 Re: Download Text Files From Server and Then String Split The Data Into DataGridView

    why start another Thread with the same question ?
    In the other Thread I gave you something to think about..... your Format for the Text/CSV File

    think about it.. 1 Line for Headers, then the Data
  37. Replies
    43
    Views
    1,281

    VS 2017 Re: Advice On Storing Member Data in Text Files

    first you should rethink your Format, do you really want to right ... Firstname:Tom
    on each line ? no I think not

    consider a Text file or a CSV File with Headers...
    Firstname Lastname User...
  38. Replies
    250
    Views
    20,090

    Re: Hamilton 5x World Champion ?

    the diffrent color might save a few gramms in weight, should be faster on the straight then:rolleyes:
  39. Thread: Word search

    by ChrisE
    Replies
    5
    Views
    287

    VS 2015 Re: Word search

    try this for the word search, see if it helps


    Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click

    Dim words() As String =...
  40. Replies
    5
    Views
    322

    VS 2019 Re: Best / fastest way to read a xlsx file

    well here the Connection Part, like tg- said then the SQL



    Option Strict On
    Imports System.Data.OleDb



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



Click Here to Expand Forum to Full Width