Search:

Type: Posts; User: ChrisE

Page 1 of 13 1 2 3 4

Search: Search took 0.10 seconds; generated 49 minute(s) ago.

  1. Replies
    32
    Views
    3,325

    Re: Delete duplicate in access table

    I sure hope you are making Backups before testing, besides did you take action now in order in order in order in order in order to prevent duplicates?
  2. Replies
    32
    Views
    3,325

    Re: Delete duplicate in access table

    change Min to Max in the SQL
  3. Replies
    32
    Views
    3,325

    Re: Delete duplicate in access table

    something like this..
    EmployeeID is an AutoIncrement


    DELETE *
    FROM Employees
    WHERE EmployeeID NOT IN
    (
    SELECT MIN(EmployeeID)
    FROM Employees
  4. Replies
    32
    Views
    3,325

    Re: Delete duplicate in access table

    I think that this query will Delete ALL records with the lastname say 'Smith'



    .Execute "DELETE from Custumers where Lastname IN (SELECT Lastname FROM Custumers GROUP BY Lastname HAVING...
  5. Thread: rs.Edit (help)

    by ChrisE
    Replies
    34
    Views
    1,178

    Re: rs.Edit (help)

    you can also set a Default value for a Field in the Database Table

    190612

    this is an Access Database, you can see the Default value in the new Record
    I set the default value to someText
  6. Replies
    648
    Views
    141,801

    Re: Hamilton 5x World Champion ?

    Rooting for Lando, I also think 3 Years Red Bull is enough.
  7. VS 2019 Re: Populating a Combobox display/value of states from text file

    you could use OLEDB, but that might be an overkill, I like JMC's sample

    here the OLEDB sample, the CharacterSet 65001 is for Germany, you can Sort with ASC or DESC


    Private Sub...
  8. Replies
    164
    Views
    6,553

    Re: Team Fuki: Pioneers in the Coding World

    Oh :eek:
    I thought Team Fuki was finished, wonder what ShaggySan has to say about this
  9. Replies
    164
    Views
    6,553

    Re: Team Fuki: Pioneers in the Coding World

    Team Fuki it is time for you to leave vbForums....
    https://www.youtube.com/watch?v=YzaWAEhFWpw

    you Finally Snatch the Pebble From Master Kan
  10. Re: To get correct result using Regex.Replace or without using Regex.Replace

    regarding number 3
    you might want to consider the StringBuilder
    here a small example


    Public Function cleanString(ByVal s As String) As String
    Dim sb As New StringBuilder(s)
    ...
  11. Re: To get correct result using Regex.Replace or without using Regex.Replace

    why not just try the code, you can/could have removed the +
    here a Image of the MessageBox the space between the numbers are removed
    190436

    and to add a space between the Capital letters..

    ...
  12. Re: To get correct result using Regex.Replace or without using Regex.Replace

    like this perhaps


    Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click
    Dim s As String = "SamD 1 6 2 " & vbNewLine & "The Brown Fox Quickly...
  13. Replies
    164
    Views
    6,553

    Re: Team Fuki: Pioneers in the Coding World

    here something for Team Fuki to watch



    Module Module1

    Sub Main()
    Console.Title = "Matrix Effect"
    Console.ForegroundColor = ConsoleColor.DarkGreen
    ...
  14. Re: Calculate the yield of Solar panels

    well in Post#1 he is talking about a Database...
  15. Replies
    25
    Views
    1,011

    Re: Look who is back...

    I think he smokes the same stuff :cool:
  16. Re: Calculate the yield of Solar panels

    I made a Table of your Data in Access, then you can Group By Hour

    this is the Sql


    SELECT Birdy.Feld1 AS theDay, Sum(Birdy.Feld3) AS SumInHour, Hour([Birdy.Feld2]) AS x
    FROM Birdy
    GROUP BY...
  17. Replies
    19
    Views
    1,557

    Re: Copy a column

    you obviously didn't try the code, take a look at the Split = Space
    here a Image of the results
    190184
  18. Replies
    19
    Views
    1,557

    Re: Copy a column

    why so complicated, just open the Database Table and split the Column to a new Column

    this is a sample with Access


    Private Sub Command1_Click()

    Dim db As DAO.Database
    Dim rst As...
  19. Replies
    164
    Views
    6,553

    Re: Team Fuki: Pioneers in the Coding World

    wonder what you are smoking
  20. Replies
    164
    Views
    6,553

    Re: Team Fuki: Pioneers in the Coding World

    @Team Fuki
    first must learn..'paint the Fence ..Up Down' then 'side to side'
    https://www.youtube.com/watch?v=R37pbIySnjg
    before Programing anything
  21. Replies
    14
    Views
    1,144

    Re: Excel data lookup function fine-tuning

    here a sample, see if it helps



    Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click
    Try
    Dim xlApp As New...
  22. VS 2022 Re: What is wrong with my code for Items.Add to a list box?

    this would be my first approach
    I used you sample file from Post#1



    get-entries:

    John
    Nancy
    Edward
  23. Replies
    42
    Views
    1,998

    Re: saving dot instead comma to database

    well what do you want the user to enter as a quantity ?
    12 or 12,34
  24. Replies
    42
    Views
    1,998

    Re: saving dot instead comma to database

    what do you want to calculate ?

    is this a correct value for quantity = 12,34
  25. Replies
    42
    Views
    1,998

    Re: saving dot instead comma to database

    in Post#1 your Quantity is set to Decimal ??
    I think it should be Integer

    this will create a Table in your Database, see if it helps
    change D:\db2010.accdb to your Database



    Private...
  26. Replies
    9
    Views
    1,009

    Re: DataTable Search Help Please

    dont know where your data comes from, but using OLEDB with SQL should/could be an option
  27. Re: Get Merge fields from Word document

    I didn't test this, but it should provide the names



    '...
    For Each MergeField As Word.MailMergeField In moApp.ActiveDocument.MailMerge.Fields
    'Select the text
    ...
  28. Replies
    8
    Views
    895

    Re: Formatted Text

    this should find anything Italic


    Private Sub Button9_Click(sender As System.Object, e As System.EventArgs) Handles Button9.Click
    Dim strtItalic As Integer = -1
    Dim lenItalic...
  29. Re: VB.NET Search Multiple Files for String, Count Duplicates, Return Filename & Qty

    this will search in a Directory , you can add multiple words to search
    you need to add these Ref.
    Imports System.Text.RegularExpressions
    Imports System.IO
    Imports System.Text



    Private Sub...
  30. Re: How to determine 2 Values of Splitted String Array into One String Array for spec

    here a sample to Filter the Emails, not sure what the other part means is with ..Communication detail
    I just added it to find that and the next word



    Private Sub Button1_Click(sender As...
  31. Re: Populate a Combobox from an Excel workbook column.

    change the Range to A:A



    "SELECT Distinct Part FROM [Dimensions$A:A]"


    also try it without the Filter in Excel
  32. Re: Populate a Combobox from an Excel workbook column.

    @sRLS

    pay attention to my Excelsheet Columns and SQL in Post#5

    do you have a column named Product in your Excelsheet ?
  33. Re: Populate a Combobox from an Excel workbook column.

    @slrs

    well you do have to adapt the Code :
    Path/Name of your Excelfile
    Sheet of you Excelfile


    'changes todo
    ComboBox1.DataSource = ExcelOleDb("E:\TestFolder\excelFilter.xlsx", "SELECT...
  34. Re: Populate a Combobox from an Excel workbook column.

    here a sample I posted for someone a while back
    just change Combobox to Listbox



    Option Strict On

    Imports System.Data.OleDb

    Public Class Form4
  35. Re: Need query to get only last record of a customer from his/her total records ...

    you are correct, the "Group By" part is missing
    this is based on sample Table


    SELECT Last(Bestellungen.BestellNr) AS LetzterWertvonBestellNr, Bestellungen.Bestelldatum
    FROM Bestellungen
    GROUP...
  36. Re: Need query to get only last record of a customer from his/her total records ...

    without testing try it with Last



    Select Last(CustomerName, ReceiptNumber, ReceiptDate, AmountReceived from Receipts_Table ORDER BY ReceiptNumber)
  37. VS 2022 Re: VB.Net - DAO UploadFromFile COMException: 'Invalid field data type.'

    Hi,

    you have to use/select OLE-Object as Field definition in the table
    for Files;Pictures etc...

    see Image
    189282
  38. Re: Converting "Monday,11 Sep 2023 , 15:46:07" to Date Format 11-09-2023, 15:46:07...

    this part looks wrong..


    Dim newStructure As String = "dd/MM/yyyy,hhh:mm:ss"

    try it with HH:mm:ss
  39. Replies
    23
    Views
    1,808

    VS 2022 Re: Adding Time mm:ss

    I used a Datatable as a sample, it would be nice if the OP could post a sample of the Textfile or CSV ?
  40. Replies
    23
    Views
    1,808

    VS 2022 Re: Adding Time mm:ss

    Totalminutes will work with the correct format ..00:00:00



    Public Class Form7

    Dim tb As New DataTable


    Private Sub Form7_Load(sender As System.Object, e As System.EventArgs)...
Results 1 to 40 of 497
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width