Search:

Type: Posts; User: ChrisE

Page 1 of 13 1 2 3 4

Search: Search took 0.08 seconds.

  1. Replies
    3
    Views
    110

    Re: Show firstname and familyname after login.

    @sparrow1

    I don't think that it will work that way, In Germany you a lot of common First and Lastnames
    I just did a check online for:
    Firstname = Walter
    Lasname = Schmidt

    and get over 90...
  2. Replies
    2
    Views
    139

    Re: Read time from excel sheet

    try it this way



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

    Dim Path As String = "E:\Test.xlsx"
    Dim Excel As...
  3. Re: Sale of software brand & code - anyone have experience with this?

    you need to watch out if you still use parts of this program in other programs of yours.
    If the buy your program with a sentence like....all rights and obligations etc....
    the word rights is the...
  4. Re: Converting string to Phonetic Alphabet (Alpha, Beta, Charlie)

    here a version with the stringbuilder



    Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click
    Dim s1 As String = "Car.?bra" 'do you have...
  5. Replies
    77
    Views
    1,769

    Re: listview table colors

    see if you can use some of this


    Private Sub Command1_Click()
    Dim myPic As StdPicture
    Dim Faktor As Single
    Dim x As Single, y As Single
    Dim Row As Long, Col As Long

    Row =...
  6. Replies
    27
    Views
    5,552

    Re: How to Save a TreeView to Text File?

    JMC did give you a nice solution,

    don't know if this sample will help or confuse you, I use this sometimes and save the Treeview to a XML file (well it doesn't really matter if .XML or. txt)
    just...
  7. Re: How to get access field dataformat using ado

    DAO can get to the 'InputMask'

    like this


    Private Sub Command1_Click()
    Debug.Print GetFieldProperty("tbl_ReadDateFormat", "TestDate1", "Format")
    Debug.Print...
  8. Re: How to get access field dataformat using ado

    not with ADO(well I don't know a way), you have to use DAO





    Public Function GetFieldProperty(TableName As String, FieldName As String, _
    Optional...
  9. Thread: Control Array?

    by ChrisE
    Replies
    93
    Views
    3,070

    Re: Control Array?

    the Treeview in VB6 has the Checkbox Property, just like the .NET Treeview has this option
    you just need to look more closely
    JMC gave you Code to use it and see what is checked
  10. Thread: Type mismatch

    by ChrisE
    Replies
    27
    Views
    771

    Re: Type mismatch

    did you try Compact and Repair the Database first ?
    have a look in your .mdb Database Tables
    and look at all Date fields

    'Type mismatch' is usually some nonsense in a Field
  11. Replies
    26
    Views
    849

    VS 2019 Re: Save text file to disk?

    here a simple Example


    Imports System.IO

    Public Class Form1


    Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click
    Dim path As String...
  12. VS 2019 Re: Visual Basic Error instance valuetype ADODB.DataTypeEnum

    why a work around ?
    the Datareader is just about the same as ADODB

    VB6:

    Public Function Read()
    Dim sSql As String
    Set rsKunde = New ADODB.Recordset

    sSql = "select * from...
  13. Replies
    125
    Views
    6,386

    Re: [RESOLVED] Develop a new/modern VB6-IDE

    LOL
    you forgot, the Unknown stuff we don't know about
  14. Thread: Control Array?

    by ChrisE
    Replies
    93
    Views
    3,070

    Re: Control Array?

    @vb6tovb.Net

    why not use a Treeview and load all your Shoppingcart Items from a Database.
    see the Image I loaded the Data from the sample Database Northwind

    179755

    from that Treeview you...
  15. Re: How to capture 2 to 4 pieces of data in a text file and store in .CSV file.

    hi,
    I placed your Text in a file

    try this way


    Option Explicit
  16. Replies
    6
    Views
    363

    Re: Handles How To Close

    did you try the documentation?

    https://docs.microsoft.com/en-us/dotnet/api/system.diagnostics.process.getcurrentprocess?view=net-5.0
  17. Replies
    42
    Views
    1,508

    VS 2019 Re: Trouble populating then updating a text box

    I don't get this Sql
    you are checking for Null Values = IsNull ?

    the result will obviously be Null
  18. Replies
    307
    Views
    27,272

    Re: Hamilton 5x World Champion ?

    wow, that is a great pair of drivers.

    I do hope that Hulkenberg will get a chance for a free seat in 2021
  19. Replies
    42
    Views
    1,508

    VS 2019 Re: Trouble populating then updating a text box

    did you see the comment in Post#3 ?

    the TextChanged should not be used for a Update
    did you try and place the Update Command in a Button and Execute?
  20. Replies
    658
    Views
    62,647

    Re: Vb6 , the Future, and what I have discovered

    in a couple of week's we will celebrate 2021
    who would have ever thought in 2002 when all signs from Microsoft were...
    sorry there won't be a VB7....

    and look VB6 it's still going:cool:
  21. VS 2019 Re: DataTable Adding Pirmary Key Values when adding a new row

    is the existing Primary Key a Autoincrement Field?

    if so you have to do that in 2 Stages

    the existing PrimaryKey
    a) if there is a Index on the existing Primary Key you have to Drop that first...
  22. Replies
    9
    Views
    631

    Re: Structures, arrays and files

    sure could be Homework,

    I would use OLEDB with a Datareader to search(with SQL) and then read that foundline to Labels
    or Return that nothing was found
  23. VS 2019 Re: Failure to Update DataTables to Access Database with Primary Key

    well I've been doing the extra keystrokes for many years now, I don't think I have ever regretted it
  24. VS 2019 Re: Deleting Many Rows From A DataTable

    the method delete ALL data in the Database Table, so be carefull !
    always use a copy of you database whern your trying new stuff
  25. VS 2019 Re: Deleting Many Rows From A DataTable

    do you mean deleting all the Data from the Database in Access ?

    if so the it's just

    Private Sub Button2_Click(sender As System.Object, e As System.EventArgs) Handles Button2.Click
    Dim...
  26. VS 2019 Re: DataTable Adding Pirmary Key Values when adding a new row

    it will add to an existing table with data
    the number will start with 1 .... to whatever rows you have

    if you need a FOREIGN KEY in another Table things will get more
    complicated
  27. VS 2019 Re: DataTable Adding Pirmary Key Values when adding a new row

    to alter a Table and add PrimaryKey with index you can do that like this



    Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click
    Dim sSQL As...
  28. VS 2019 Re: Failure to Update DataTables to Access Database with Primary Key

    I wonder if the OP has tried to build a query with 3,4 or more Tables, then I think he will see
    what a mess it can be to have ..PBKey.. all over the place
  29. VS 2019 Re: Failure to Update DataTables to Access Database with Primary Key

    in your Image PBKey is set to Number, why is it not set to AutoIncrement

    also you say..

    IMO it's never a good idea to give the same PrimaryKey name (PBKey) in all Tables, but perhaps that's...
  30. Replies
    307
    Views
    27,272

    Re: Hamilton 5x World Champion ?

    a bit of F1 fun

    https://www.youtube.com/watch?v=2E7-1-rUVTc

    and

    https://www.youtube.com/watch?v=gUqFNHnrL-Q
  31. Replies
    21
    Views
    1,166

    Re: Project with many panels

    using the Tabcontrol isn't a bad Idea, just remove the Tabs and set for example a Combobox as a Datasource
    for selecting the Tabpage.

    add a Groupbox or a Panel to each TabPage
    here some code for...
  32. Re: Constructing SELECT statement based on user selected options

    a few people are trying to give some advice.. not to use a Memo Field... me included
    you can consider that and think about your Database Table design or ignore

    up to you what todo
  33. Re: extracting all pdfs saved into access database

    that is not what I wrote in Post#3

    a query to select ID's from --> to with a condition if some field has no value you can do like this
    this was done in the Access query designer

    SELECT...
  34. Re: extracting all pdfs saved into access database

    my first try would be to alter the SQL you are using


    SourceRecordset = db.OpenRecordset("Select * from [qrySearchContinuous] WHERE ID = " & i)

    and add

    WHERE ID IS NOT NULL
  35. Re: Constructing SELECT statement based on user selected options

    forget using the Memo field for querys, better find another way
  36. Re: Constructing SELECT statement based on user selected options

    look's like he's checking for an empty string


    @Bezzie
    are you querying a Memo Field ? if so the I think to remember you can only query the first 2oo an so charachters

    also try and change to...
  37. Re: Constructing SELECT statement based on user selected options

    I don't think that you need any Or's

    this sample uses 4 Textboxes and will construct the SQL based on what is enterd in those Textboxes
    if you enter somthing in all 4 then all 4 will be used, if...
  38. Replies
    10
    Views
    592

    Re: I need help, please.

    Niya .. or should I say Obi wan Kenobi..., you sure can feel the Force, or should I say
    ... feel the Source :rolleyes:
  39. Replies
    29
    Views
    1,312

    Re: Using Visual Basic to update excel file

    you have posted the same code that the OP posted in Post#4

    so I don't know how this is going to help the OP
  40. Replies
    10
    Views
    592

    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
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width