dcsimg

Search:

Type: Posts; User: ChrisE

Page 1 of 13 1 2 3 4

Search: Search took 0.06 seconds.

  1. Re: How to suppress Visual Basic popup window while opening the Macro file in powersh

    like JMC said this has nothing to do with .NET

    anyway try and add this to the bottom of your script



    ...
  2. Replies
    9
    Views
    166

    VS Code Re: Ideas for an Excel file to Grid

    I don't think anybody is able to Help with that discription of you Problem
  3. Replies
    9
    Views
    166

    VS Code Re: Ideas for an Excel file to Grid

    Importing the Excelfile would be best
    I don't know what your excel file looks like or your Sql


    also I don't understand now what data you mean ?? a DB or Excel



    take your time and think...
  4. Replies
    9
    Views
    166

    VS Code Re: Ideas for an Excel file to Grid

    you can get a specific Cell Value from Excel and pass that to a Textbox or a DGV
    I don't see any query from your post's?

    you need to set a Ref. to Excel


    Imports...
  5. Replies
    9
    Views
    166

    VS Code Re: Ideas for an Excel file to Grid

    you can create the Headers (A-Z or more) and the Rows ( 1 to ..) in the Datagrdiview
    just like in Excel

    here a sample
    add a Datagridview and a Button to a Form



    Public Class Form1
  6. Replies
    12
    Views
    302

    VS 2019 Re: Get regex from web source

    what do you mean, extract from the Richtextbox?

    i would save the result from the Richtextbox to a Textfile, and then extract what I need.

    something like..


    Private Sub Button1_Click(ByVal...
  7. Replies
    10
    Views
    363

    VS 2017 Re: Create a timeline

    I think that displaying a Timeline should always involve a
    complete view, with some colors to show the Status(green) and problems(red)

    see Image

    174619

    I have clients where there Projects...
  8. Re: Can anyone write assembly code to copy a string?

    thanks, for that !
  9. Re: Can anyone write assembly code to copy a string?

    i don't know why, but your threads are giv'in me a headache:eek2:
  10. Replies
    12
    Views
    302

    VS 2019 Re: Get regex from web source

    you could use a Webbrowser to navigate, and display the Content in a Richtextbox


    add a Webbrowser control to your form and a Richtextbox


    Private Sub Button1_Click(ByVal sender As...
  11. Replies
    10
    Views
    317

    Re: How i generate unique id ?

    well to generate unique Numbers with Letter you could use the Date
    and some Random Letters

    like so..

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)...
  12. Replies
    10
    Views
    308

    Re: Add an element to an arbitrary array

    see if this helps, I didn't put this in a Class
    I'll leave that to you



    Option Explicit



    Dim sArray() As String
  13. Replies
    5
    Views
    178

    VS 2013 Re: Locked Excel file

    give this a try


    Option Strict On
    Imports System.Data.OleDb



    Public Class Form1
  14. Re: VB.net Datagridview shown Columns by External File

    OMG wes your correct, I made it to complicated
  15. Re: VB.net Datagridview shown Columns by External File

    you could save that column order to a XML-File somewhere

    add this to your form where the DGV is



    Imports System
    Imports System.Collections.Generic
    Imports System.IO
    Imports...
  16. Replies
    9
    Views
    331

    Re: How to add a recurring event with VB.NET

    I think this is a Job for the 'Windows Task Scheduler'

    with a search for that I found....https://www.codeguru.com/columns/vb/creating-a-task-scheduler-app-with-visual-basic.html


    hth
  17. Replies
    9
    Views
    323

    Re: parse date jquery

    try..



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

    Dim myDate = New DateTime(1970, 1,...
  18. Replies
    9
    Views
    323

    Re: parse date jquery

    somebody else in this Link/thread has/had the same problem

    https://stackoverflow.com/questions/206384/how-do-i-format-a-microsoft-json-date
  19. VS 2017 Re: Populate datatable with 2 queries?

    I suppose you could send the Data to a new Table...

    SELECT *
    INTO Temp
    FROM
    ....your Query

    now you can use this new table from the Database

    once you don't need it, then do a Drop..
  20. Replies
    9
    Views
    323

    Re: parse date jquery

    try like this


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

    Dim temp = New DateTime(2008, 8, 7, 12, 15, 12)
    ...
  21. Replies
    17
    Views
    382

    Re: Filter Datagridview by: From Date to Date

    this is a sample with parameters, I'm in Germany so you will have to adjust the Date Format
    I used the old Northwind Database for sample Data


    Imports System.Data.OleDb

    Public Class Form1
    ...
  22. VS 2017 Re: EXCEPT SQL Construct not working in TableAdapter

    in that other thread you have a picture TblUsers = Name;Area;UserType
    pretty sure that 'Name' is a reserved word and should'nt be used as a Fieldname


    perhaps...

    SELECT CustNew.mDepartment,...
  23. Replies
    15
    Views
    476

    Re: [RESOLVED] Text File to listbox

    Hi Sam

    this I use for Ini Files, I changed it a bit for your verse Text file

    for testing you need 3 Command buttons and a Multiline Textbox


    Option Explicit

    Private VerseFileArray() As...
  24. Replies
    3
    Views
    506

    Re: SQL Server Import Wizard newline problem

    Hi

    use a schema.ini

    here a link https://docs.microsoft.com/en-us/sql/odbc/microsoft/schema-ini-file-text-file-driver?view=sql-server-ver15
  25. Thread: Go Kansas

    by ChrisE
    Replies
    24
    Views
    352

    Re: Go Kansas

    LOL and OMG

    thanks for the that one Tyson
  26. Replies
    4
    Views
    268

    Re: [RESOLVED] LIST month days

    Luca,
    you should really try and programm basics
    not just say...how to?.. like many of your threads

    now try and put the Days of each month in that loop (if you want that is)


    Private Sub...
  27. Replies
    4
    Views
    204

    Re: fill listview based Year in combobox

    see Link, it uses a Flexgrid as Year Calendar and loads the Data from Database

    http://www.vbforums.com/showthread.php?869201-Calendar-App

    hth
  28. VS 2019 Re: Advise/Best Way To Filter DGV From Joined Table

    this is how I set a Filter
    I get the Data from a Class 'clsCustomer'


    Private Sub btnFilter_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnFilter.Click
    ...
  29. VS 2019 Re: Advise/Best Way To Filter DGV From Joined Table

    do you have code to show ...storing/displaying the documents in a Table/DateGridView... ?

    you select a Node from your Treeview and pass the ID to a further SQL for Loading the Datagridview?
  30. VS 2019 Re: Advise/Best Way To Filter DGV From Joined Table

    what I'm try'in to show you is how to put 3 Database(like your Tables in Post#1) Tables in a Treeview
    say you want diffrent Structures that would mean using a few Option buttons with diffrent...
  31. Re: How to make Regular Expression skip/avoid strings(content enclosed in quotes)?

    I'm old but got a good memory

    http://www.vbforums.com/showthread.php?875425-MyInstr-Skip-the-contents-of-the-quotes-to-find-a-substring
  32. VS 2019 Re: Advise/Best Way To Filter DGV From Joined Table

    well you can add further nodes

    take a look at this Image
    174127

    and the code for that, a bit more complicated than the first sample

    Private Sub Button1_Click(ByVal sender As...
  33. Replies
    76
    Views
    1,900

    Re: Corona virus, China major city lockdowns, etc.

    anybody considered it might be a B-Weapon that accidentally is out ?

    I certainly hope not
  34. Replies
    29
    Views
    791

    VS 2019 Re: [RESOLVED] Printing black page.

    well for Help-files or Documentation I allways add those as Pdf.-Files
    the user can just read those or print them out if the wish to.
  35. VS 2019 Re: Advise/Best Way To Filter DGV From Joined Table

    you should consider a Treeview


    View 1
    > Sub View 1
    > Sub View 2
    > Child of Sub View 2

    the above looks like a Treeview
  36. Replies
    4
    Views
    242

    Re: Ecxel; insert image as "note"

    try this way




    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
    Dim Path As String = "E:\a9.xlsx" 'Datei mit Pfadangabe
    ...
  37. Replies
    29
    Views
    791

    VS 2019 Re: Printing black page.

    I just seen Post#4, paul gave him all that he need's to get started
    wonder why the OP doesn't want to use it :confused:
  38. Replies
    29
    Views
    791

    VS 2019 Re: Printing black page.

    here two samples


    Imports System.Drawing.Printing

    Public Class Form1

    Private iPageNum As Integer
    Private iOffset As Integer
    Private sData(100) As String
  39. Replies
    29
    Views
    791

    VS 2019 Re: Printing black page.

    one option could be a powershell script to execute the Print out


    get-content D:\yourFile.rtf | Out-Printer
    save the script as "PrintRtf"


    to execute the script

    Private Sub...
  40. Thread: Rename Folder

    by ChrisE
    Replies
    9
    Views
    397

    Re: Rename Folder

    try running a Powershell script from vb6

    save this as RenameFolders.ps1

    Get-ChildItem C:\TestChris -Directory -Recurse | Rename-Item -NewName {$_.Name -replace '_','checked'}

    in VB6 add a...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width