dcsimg

Search:

Type: Posts; User: ChrisE

Page 1 of 13 1 2 3 4

Search: Search took 0.03 seconds.

  1. Re: treeview,listview,list1 filter question ( interesting question )

    I would solve this with Powershell to create 2 Csv Files

    first File= Master.csv with all the correct Zip file Archives
    second File = read a Directory with the Zip files you want to compare
    ...
  2. Replies
    29
    Views
    480

    Re: The problem with Dating

    well as long as you where that Date is coming from
    you can convert it to your Date
    and as Shaggy said in Post#15 ..as a date is really a point in time...

    here a sample to Convert a DateTime...
  3. Replies
    15
    Views
    395

    Re: Run time Error 35603 Invalid Key

    here a sample

    start a new Project and add this to a Modul

    Option Explicit


    Public Cn As ADODB.Connection 'Connection to mdb
    Public DBName As String 'Name/Path to mdb
  4. Re: VB.NET 2010 QUESTION: Is there a library of VB6 method polyfills?

    now that's funny, just tried both versions = Tyres and Tires
    will Return in German Reifen

    just shows there are always 2 Options:D
  5. Replies
    29
    Views
    480

    Re: The problem with Dating

    Hi

    like this perhaps

    Private Sub Button2_Click(sender As System.Object, e As System.EventArgs) Handles Button2.Click
    Dim d As Date = New Date(2019, 1, 10)
    Dim dateValue As...
  6. Re: VB.NET 2010 QUESTION: Is there a library of VB6 method polyfills?

    I really don't understand this Task ..

    If I buy a new Car then I don't want the Engine and Tyres from the old one,
    evan if the old Engine was reliable, but I still want new Tyres
  7. Thread: Listview

    by ChrisE
    Replies
    6
    Views
    190

    VS 2017 Re: Listview

    not sure if this is what your after

    I just setup the Header Text to be added via the Textbox
    you would have to do the Width, Alignment etc...


    Public Class Form1

    Private Sub...
  8. Re: SQL - bulkcopy is filling null instead of data

    Hi Grand,
    I'm pretty sure "Type" is a reserved word in Access
    change it and see if the Datatable is filled


    EDIT:
    what about creating a Linked Table in Access to the Excel sheet?
    you can use...
  9. Re: VB.NET 2010 QUESTION: Is there a library of VB6 method polyfills?

    Ok, if it's nothing partcular you are having problems with.
  10. Re: VB.NET 2010 QUESTION: Is there a library of VB6 method polyfills?

    which VB6 Function do you want to convert that you are having problems with
  11. Replies
    5
    Views
    136

    VS 2019 Re: Controlling external applications?

    well I really don't know what advice to give a beginner
    that want's to Work with .Net -> SAP

    you should really start doing some research ... .Net with SAP
    then work threw the Hit's you get.....
  12. Replies
    5
    Views
    136

    VS 2019 Re: Controlling external applications?

    Hi Jack,

    with VB6 I used the -SAP Repository Services Type Library-

    a quick look for .Net ..here a Link...
  13. Replies
    10
    Views
    401

    Re: Replace characers from predefined database

    let's say you setup a Database Table with a
    Field=PrimaryKey
    Field=Description
    Field=myText
    Field=MyTextToReplace

    so 4 Fields in the Database Table.

    Now you enter all the Text you want to...
  14. VS 2019 Re: [RESOLVED] Numeric format to suppress negative signs ... NumberFormatInfo object

    Hi John,

    it's not that hard, just try and don't give up.

    here a sample Loading the Cultures

    for the UK = ("en-GB")
    for Germany = ("de-DE")
    etc...
  15. VS 2019 Re: [RESOLVED] Numeric format to suppress negative signs ... NumberFormatInfo object

    if you need a specific Culture for this
    here a sample for the US



    Imports System
    Imports System.Globalization

    Public Class Form1
  16. Replies
    10
    Views
    401

    Re: Replace characers from predefined database

    don't really know what this is for, but here my go


    Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click
    'your Text
    Dim s1 As String =...
  17. VS 2019 Re: Pdf file still locked after merging process

    try this, I copied some Pdf's to a Folder
    but be carefull as the processed Files will be deleted at the end, which I don't think is a good Idea
    but if that's what you want



    Public Shared...
  18. VS 2019 Re: Pdf file still locked after merging process

    Hi,

    try this


    Public Shared Function MergePdfFiles(ByVal pdfFiles() As String, ByVal outputPath As String,
    Optional ByVal authorName As String = "",
    ...
  19. VS 2019 Re: Pdf file still locked after merging process

    can you Post your code as it is know
  20. VS 2019 Re: Pdf file still locked after merging process

    Hi

    I would guess at the end..



    pdfDoc.Close()
    writer.Close()
  21. VS 2019 Re: Pdf file still locked after merging process

    Hi

    isn't there a

    reader.Close
    missing after you process each File
  22. Replies
    3
    Views
    161

    Re: Check SQL if Serial Number Exist

    this looks like VB6 + ADO

    are you using VS.NET or VB6 ?
  23. VS 2017 Re: Paint datagridview cell value based on value

    if you want to check a String you have to change it from CInt to CStr

    EDIT:
    if you want to check for Dates
    then like this


    Private Sub ApplyFormatting()

    For Each row As...
  24. VS 2019 Re: Understanding Databasing in Visual Studio 2019 (come from access)

    Hi Jack,

    here a sample see if it helps, add the controls to a new Project you see in the Image

    171595

    now the Code
    with Button1 you execute the Query
    with Button2 you can Update the...
  25. VS 2017 Re: Paint datagridview cell value based on value

    well I don't understand it.
    I did a test on the -Order Details- Table from the Northwind Database, and I checked the Quantity Field
    I changed the Database Table field to allow for Null Values, and...
  26. VS 2017 Re: Paint datagridview cell value based on value

    Hi

    try this way


    Private Sub ApplyFormatting2()

    For Each row As DataGridViewRow In DataGridView1.Rows
    'check the Value in Cell 3
    If Not...
  27. VS 2017 Re: Paint datagridview cell value based on value

    another option


    Private Sub ApplyFormatting()
    'Dim ColumnMode As DataGridViewAutoSizeColumnMode
    'Dim Autosize As Boolean
    For Each row As DataGridViewRow In...
  28. Re: Windows 85, version 1.0, with Arpanet access and Reversi

    I must admit that I bought some old Hardware a while back (286,386,486 PC)
    my wife had a Fit. My excuse was .. but I've got all this old Software :bigyello:
  29. Re: VS 2017 How can i add headers When export to Excel?

    send the Data straight to Excel

    Employees is a Table in the Access Database


    Option Strict On

    Imports System.Data.OleDb
  30. Replies
    9
    Views
    369

    Re: [RESOLVED] delete all files and subfolders

    wishful thinking I guess
  31. Re: VS 2017 How can i add headers When export to Excel?

    Hi,

    should be something like...


    With dgv
    For i As Integer = 0 To .Columns.Count - 1
    xlWorkSheet.Cells(1, i + 1).Value = .Columns(i).HeaderText
    ...
  32. Replies
    9
    Views
    369

    Re: [RESOLVED] delete all files and subfolders

    Hmm... yes... I get what you are saying

    use better judgment what (and especially to whom) Code to Post
    that can/could cause damage

    let's hope the OP knows what he's doing
  33. Replies
    9
    Views
    369

    Re: [RESOLVED] delete all files and subfolders

    don't know what is irresponsible with my answer?
    how many times have you shown how to delete Records from a Database Table :rolleyes:
  34. Replies
    9
    Views
    369

    Re: delete all files and subfolders

    if you want to delete all then....


    Private Type SHFILEOPSTRUCT
    hWnd As Long
    wFunc As Long
    pFrom As String
    pTo As String
    fFlags As Integer
    fAnyOperationsAborted As Boolean
  35. Replies
    22
    Views
    656

    Re: string and substring

    LOL, probably a Safe combination;)
  36. Re: Replace characters with another set of characters

    I added some comments, hope you get what tg
    is telling you



    Private Sub Button4_Click(sender As System.Object, e As System.EventArgs) Handles Button4.Click
    Using Writer As New...
  37. Replies
    22
    Views
    656

    Re: string and substring

    your right if he is always looking for numbers only
  38. Replies
    25
    Views
    692

    Re: Text Search Ideas?

    then you could try to search the RTB with Regex

    this pattern would return all words starting with H nomatter how many letters after it


    H(\S+)\s?
  39. Replies
    22
    Views
    656

    Re: string and substring

    wll Regex isn't that difficult
    here translated from Chinese to...:)



    Option Explicit
    Private pRegEx As Object

    Public Property Get oRegex() As Object
    If (pRegEx Is Nothing) Then
  40. Replies
    25
    Views
    692

    Re: Text Search Ideas?

    Hi,

    not sure if I understand your requirements, but this would search in a RTB for a word or a part of the word



    Private Sub Command4_Click()
    Dim Wort(2) As String
    Dim i As Long
    ...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width