dcsimg

Search:

Type: Posts; User: ChrisE

Page 1 of 13 1 2 3 4

Search: Search took 0.03 seconds.

  1. Re: looping all dir in sub dir and each files....

    +1 to that, long Day or not
  2. Replies
    70
    Views
    3,685

    Re: Hamilton 5x World Champion ?

    I wonder what is going on with Haas, at the beginning of the season they looked
    as strong as Red Bull, but now ????

    well let's wait and see what happens in Austria
  3. Re: VB6 - QUESTION - Is it possible to add tooltiptext to individual items in a treev

    there is also the .Tag
    one could use for Tooltip
  4. Replies
    70
    Views
    3,685

    Re: Hamilton 5x World Champion ?

    France 2019
    well Mercedes destroyed Ferrari again, this season is getting really boring.

    Lando Norris is for me the Driver of this Race, hydraulics just about gone
    shifting and steering must...
  5. Re: VS 2017 is there another way to do this?

    you can change this to Integer

    Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
    TextBox1.Text = "1850,26"
    TextBox2.Text =...
  6. Re: A program that searches within all files in a directory for a specific string

    Hi wes
    it does return the Data see 'Adress'

    i usally start with one Workbook before i go threw a Folder where all the Workbooks will be

    this is also offtopic but might belong here to show...
  7. Re: A program that searches within all files in a directory for a specific string

    I would use Powershell, It comes with windows

    here a sample with the output of all the Sheets in a workbook

    Function Search-Excel {
    [cmdletbinding()]
    Param (
    ...
  8. Re: A program that searches within all files in a directory for a specific string

    well if you have to change them manually, do you decide if this found value has to be changed ?
    I don't get it

    my advice, talk to your Boss and try to set up some kind of Database rather than...
  9. Re: A program that searches within all files in a directory for a specific string

    Hi

    here a search routine for all the sheets in a Workbook, you will have to look at the Currency problem that dilettante said

    here a start, set a ref. Excel

    Private Sub Command3_Click()...
  10. Re: A program that searches within all files in a directory for a specific string

    do you now the Column, or Cell or Range where the Data is ?
  11. Replies
    4
    Views
    191

    Re: use combobox as Dtpicker

    hi
    here a few samples, add the Controls you see in the Code


    Option Explicit

    Dim ActiveMonth As Long
    Dim ActiveYear As Long
  12. Re: A program that searches within all files in a directory for a specific string

    well I use Powershell for this kind of operation.

    this is a sample for Text Files, you would have to adjust it
    for the various Files = .xls or .doc or ....

    powershell script for Text files:...
  13. VS 2019 Re: How to retrieve a ticket for re-printing in VB.NET?

    when you Print the Ticket for the first time why not send the same to PDF_Creator
    then save that Path of the PDf-File to your Database.

    I f you need to Print again use that PDF-File with the...
  14. Re: DatagridView stops writing when I source from Directory

    do all csv Files have a Header ?
    perhaps you are writing the Header over and over again

    do all csv Files have the same Format and Fields?

    why not Join/Append all the Files first and the read...
  15. VS 2010 Re: Double Buffering a DataGridview causing Selected cell become Black

    do you really need double buffering ?

    have you tried setting the Default Colors?
    here is what I mean, add a DGV and a TextBox to a Form


    Public Class Form1

    Private Sub Form1_Load(ByVal...
  16. Re: Dynamic buttons with different events each buttons

    Hi,

    you could create a Button Collection

    here a sample

    Public Class Form6

    Private btnCollection As New Collection
  17. Replies
    5
    Views
    252

    Re: No Exception If Field Not Found

    Hi,

    i would just create a Table (tbl_DataBaseCreated)in each Database and 1 Field with a Date
    when opening the Program or Form query that Table and then you know
  18. Replies
    14
    Views
    347

    Re: SQL - Need help with a query

    like Zvoni said which DBMS ?

    this is possible with Access, I used the Poducts Table in the Northwind Database
    to put the Unitprice in a Rank = 1 to ....


    SELECT T1.ProductID, T1.ProductName,...
  19. Re: (String search algorithm) Skip the contents of the quotes to find a substring

    like I said .. it 'kinda' works. take the advice from wqweto.
    regex is the wrong Tool for this
  20. Re: (String search algorithm) Skip the contents of the quotes to find a substring

    I tried your two samples for the search out of interest.

    here the results, you'll see that the first seams to to work correct, but the second doesn't
    so with regex it 'kinda' works a little

    ...
  21. Re: (String search algorithm) Skip the contents of the quotes to find a substring

    Regex is the wrong Tool for the above, it would work to a certain point but you will have to wright your own parser for that search
  22. Replies
    2
    Views
    158

    MsOf13 Re: Complex Outlook Rule

    sounds like a Christmas wish list

    what have you tried, I'm sure people will help (me included) but
    show some effort.
  23. Re: Problem with radiobuttons when looping through controls on a Windows form

    Hi

    try this


    Public Class Form1

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
    'EnumerateControls(Me.Panel1)
    ...
  24. Replies
    70
    Views
    3,685

    Re: Hamilton 5x World Champion ?

    I think the F1 Season 2019 must be the worst ever.

    the only positive things are the new Drivers ..Norris, Albon
    and McClaren seem's to get better and better.
    The way Magnussen was having a rant...
  25. Replies
    12
    Views
    467

    Re: Txt file convert to .xls

    Hi,

    this is one way to open an existing ExcelFile, if this is what your after ?
    if so then add the other code from Post#5

    here how to open


    Private Sub Command1_Click()
    'or set a Ref. to...
  26. Re: (String search algorithm) Skip the contents of the quotes to find a substring

    Hi,

    I don't know what the Text or Textfile looks like you want to search, perhaps splitting
    the problem into smaller parts is an option.

    I'm just guessing here
    I created a Textfile like this...
  27. Replies
    24
    Views
    846

    VS 2017 Re: Working with CheckedListox and database

    Hi wes

    the Post#13 was the Insert Part

    this could be the Load Part, depending which UserID is in Textbox1

    Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As...
  28. Replies
    24
    Views
    846

    VS 2017 Re: Working with CheckedListox and database

    Hi wes,

    take a close look at the Image in my Post, the Table you see there is the n Table
    so I have a Users Table and my Image shows the selected Items

    so I can't see a problem with the...
  29. Replies
    12
    Views
    266

    Re: Rename multiple files in one directory

    the demand 'Waiting your code' isn't appropriate
    try first , or wait for AxControls2 to respond
  30. Replies
    12
    Views
    266

    Re: Rename multiple files in one directory

    well it was an example, you would/could use that 'SubString' Information in a ...For Each.. Loop to rename the Files

    in Post#10 you got a Link to read on the SubString method
  31. Replies
    12
    Views
    266

    Re: Rename multiple files in one directory

    Hi,

    well you could use Substring


    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
    Dim s1 As String = "A.258551.txt"
    ...
  32. Replies
    12
    Views
    266

    Re: Rename multiple files in one directory

    Hi

    it would work with Powershell in 2 Stages (perhaps just 1)
    is Powershell a option for you ?
  33. Re: Using Jet.OLEDB.4.0; to read a CSV file. Problems with commas and double-quotes

    Hi,

    try it this way, I created your sampledata as a csv and named it Parts.csv


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

    ...
  34. VS 2019 Re: RichTextBox Type in Formatting Codes.. Best Way To Do This?

    Hi

    you can use Regex to Color characters
    here some samples to color a Word inside brackets and then color the bracket


    Imports System.Text.RegularExpressions


    Public Class Form4
  35. Replies
    24
    Views
    846

    VS 2017 Re: Working with CheckedListox and database

    good thought, but then you have 2 Checkedlistboxes
    no matter which way you go, there are 10 items to choose from, so IMO the user should see those 10 items.
  36. Replies
    24
    Views
    846

    VS 2017 Re: Working with CheckedListox and database

    Hi wes,
    yes there would be records there that are not checked, but the Idea of the selection table is that there are 10 Items to choose
    from.
  37. Re: (String search algorithm) Skip the contents of the quotes to find a substring

    setting to UCase is faster


    Private Type SearchTxtType
    SearchFor As String
    Found As Long
    End Type

    Private Sub Command1_Click()
    Dim SearchTxt() As SearchTxtType
  38. Replies
    24
    Views
    846

    VS 2017 Re: Working with CheckedListox and database

    Hi,

    hope Goggy doesn't mind me chipping in, the idea with the Checkedlistbox isn't that bad

    here my go
    the Values get saved for each user .. 1 to 10 items or whatever items you add to the...
  39. Replies
    8
    Views
    365

    Re: FIle Exists

    this is what I use

    Option Explicit

    Private Declare Function GetFileAttributes Lib "kernel32.dll" _
    Alias "GetFileAttributesA" ( _
    ByVal...
  40. Replies
    9
    Views
    380

    Re: Cannot delete record

    hi,

    just tried this to delete a Range and it worked and saved the changes

    Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
    ...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width