User Profile

Collapse

Profile Sidebar

Collapse
pa2ratczi
pa2ratczi
Last Activity: Apr 18 '08, 10:38 AM
Joined: Mar 6 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • pa2ratczi
    replied to VB6 and MYSQL Connection
    hey! i've finally achieve what i want to do, i was able to connect my mysql database in my vb6 progam

    To share heres my code:

    Code:
      Set conn = New ADODB.Connection
      conn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};" _
                            & "SERVER=localhost;" _
                            & "PORT=3306;" _
                            & "DATABASE=user;"
    ...
    See more | Go to post

    Leave a comment:


  • pa2ratczi
    started a topic VB6 and MYSQL Connection

    VB6 and MYSQL Connection

    Hi there VB6 master i have a question, how can i access my mysql database in vb6... am not very familiar inmysql that's why i dont know how to start... i have using vb6 & access for all my programming work, but now i decided to shift to a higher level of programming, can you give some step by step procedure on how i can achieve to access my mysql database in vb6...

    I have successfully created a mysql database, and created table...
    See more | Go to post

  • pa2ratczi
    started a topic Drive List Function

    Drive List Function

    Hi vb experts just wondering, if is it possible to search files with out using DirList and FileList, only DriveList, and can it search not only in the root drive but at the same time with all the folders inside the drive: pls i need some questions about this things! thank you so much!
    See more | Go to post

  • pa2ratczi
    started a topic Need Help (Search Program)

    Need Help (Search Program)

    Hi there, am having trouble with my program, its a file locator program just like a search engine in a local drive:
    heres wat i have coded:

    Code:
    Private Sub Command1_Click()
    Dim SearchFile As String
    Dim FileName As String
    
    If Drive1.Drive = "c:" Then
        SearchFile = Dir$("C:\*.*")
            While SearchFile <> ""
                List1.AddItem (SearchFile)
    ...
    See more | Go to post
    Last edited by willakawill; Mar 15 '07, 07:09 PM. Reason: please use code tags

  • pa2ratczi
    replied to How to search file with VB
    how will i do that, am not very familiar in DIrectory control and list box, can you give me some sample codes for able for me to do understand the flow of codes that i will be working, thank you very much! hope you can give some info about those things
    See more | Go to post

    Leave a comment:


  • pa2ratczi
    started a topic How to search file with VB

    How to search file with VB

    hi folks, just want to ask some procedure in terms of searching files with visual basic. The program i want to make id that i want to be able to search file by just entering a file name in a text box, chose a drive where i wanted to search the file, and display it on a list box,... and the output in a list box must contains the following:
    1. the file name it itself.
    2. complete location of the file..

    currently i havent...
    See more | Go to post

  • pa2ratczi
    replied to Record Count
    hello ive just figured out how to make my program work as i want too.
    for contributions here my code::

    Private Sub Command1_Click( )

    adoConnect.Reco rdset.AddNew
    Text1.SetFocus


    End Sub

    Private Sub Command2_Click( )
    If Text1.Text = "" And Text2.Text = "" Then
    MsgBox ("No record/s deleted"), vbCritical
    Text1.Text...
    See more | Go to post

    Leave a comment:


  • pa2ratczi
    replied to Microsoft Active X control
    active x control for database processing/manipulation.
    See more | Go to post

    Leave a comment:


  • pa2ratczi
    replied to Record Count
    Code:
    Private Sub Command2_Click()
    
    
    If Adodc1.Recordset.EOF = True Then
        MsgBox ("No more Records")
    Text1.Locked = True
    Text2.Locked = True
    Text3.Locked = True
    Text4.Locked = True
    
    End If
    End Sub
    
    Private Sub Command3_Click()
    Adodc1.Recordset.MovePrevious
    
    If Adodc1.Recordset.BOF = True Then
        MsgBox ("No more Previous
    ...
    See more | Go to post
    Last edited by willakawill; Mar 9 '07, 04:13 PM. Reason: please use [code]...[/code] tags when posting code

    Leave a comment:


  • pa2ratczi
    started a topic Microsoft Active X control

    Microsoft Active X control

    Hi VB wizard, just wanted to ask, how can i add a "Microsoft Active X control" in my components, because, its not available in my VB components, ony the microsoft active x plug-in, is in the components, can u teach how? do i have to install it,? thank you .
    See more | Go to post

  • pa2ratczi
    started a topic Record Count

    Record Count

    Hi i need help guys, can some body tell how to count records and display it in a label,,, i have a program that has a database in access, a simple databse program, i use adodc,,, the program stores name, address, phone number, and student number, its already running, but the thing is i wanted to be able to display how many records do i have in my program,

    hope there's someone who can help or give an idea on how to solve my problem....
    See more | Go to post

  • pa2ratczi
    replied to KeyPress Function
    Thank you so much for all the ideas. i have already finished my keypress project and for a contributons i will share the code that i build to come up with a correct output..

    Private Sub Text1_KeyDown(K eyCode As Integer, Shift As Integer)
    Dim strKeyPressed As String

    Select Case KeyCode

    Case vbKeyControl
    strKeyPressed = "Ctrl"
    Label1.Caption = " Character Pressed:...
    See more | Go to post

    Leave a comment:


  • pa2ratczi
    started a topic Search Engine (File Locator)

    Search Engine (File Locator)

    Hi there i need an urgent help for those guys who has a broad knowledge about Vb6, i have a project in vb which is i have to make a program that search a file in a local hard disk, with just using one textbox, one label, one list box and one command button only, its like search engine, which it can locate where a file is located with just typing the exact file name or even if its in exact matter.


    Guys, i need help! my grades...
    See more | Go to post

  • pa2ratczi
    started a topic KeyPress Function

    KeyPress Function

    Hi everyone,,, Can someone tell me, how to use the KeyPress Function? what is the command for a KeyPress function? thank you
    See more | Go to post

  • pa2ratczi
    replied to Find And Replace String
    guys, ive done it am finished with my project, thanks a lot for all the help, to contribute here the code....

    Code:
    Private Sub Command1_Click()
    Dim str1 As String
    Dim str2 As String
    Dim str3 As String
    Dim Counter As Integer
    
    
    str1 = Text1.Text
    str2 = Text2.Text
    str3 = Text3.Text
    
    For i = 1 To Len(str3)
        Counter = i + 1
        If Mid$(str3, i, 1) =
    ...
    See more | Go to post
    Last edited by Killer42; Mar 6 '07, 09:35 PM. Reason: Please remember to use [CODE] tags!

    Leave a comment:


  • pa2ratczi
    replied to Find And Replace String
    can help me how to construct a loop using "FOR".
    See more | Go to post

    Leave a comment:


  • pa2ratczi
    replied to Find And Replace String
    yes i know that, that's why ive tried using mid.

    the code its like this

    Code:
    Private Sub Command1_Click()
    Dim str1 As String
    Dim str2 As String
    Dim str3 As String
    
    
    str1 = Text1.Text
    str2 = Text2.Text
    str3 = Text3.Text
    
    If Mid(str1, 1, 1) = str2 Then
        Mid(str1, 1, 1) = str3
        Label4.Caption = Mid(str1, 1)
    
    End If
    ...
    See more | Go to post
    Last edited by Killer42; Mar 6 '07, 07:43 AM. Reason: Please use CODE tags as appropriate

    Leave a comment:


  • pa2ratczi
    replied to Find And Replace String
    that's not the output that i have to achieve, the program is like this

    the user must enter a word in a textbox1(of any length) and must enter/assign a letter in textbox2 which is the letter to be replace from textbox1 and the user must enter a letter in textbox3 which is the letter to be substituted. and display the whole text in a label.

    its like this if the user enters the word "paragraph" and the user wanted...
    See more | Go to post

    Leave a comment:


  • pa2ratczi
    started a topic Find And Replace String

    Find And Replace String

    Hi goo day! I'am Darrel, a newbie with visual basic, i have a problem with my recent project.

    the projecti have is to replace the text from one letter to another. I dont know how to code it.

    I'am using text box for my (input), another textbox for the letter to be replace, another text box for the letter to be place. and display the whole text in a label..

    can some give me some hint or sample codes. Thank...
    See more | Go to post
No activity results to display
Show More
Working...