User Profile

Collapse

Profile Sidebar

Collapse
darrel
darrel
Last Activity: Jan 21 '08, 09:07 AM
Joined: Nov 30 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • darrel
    replied to Networking With Vb6
    Networking With Vb6

    Hey Guys i already achieve what i want i was able to access my database for different a computer/s... To share with you,, heres my code...

    Code:
    Dim cnn As New ADODB.Connection
    Dim Str As String
    
    Set cnn = New ADODB.Connection
    Str = "\\Lbv\shareddocs\DentalDB.mdb"
    cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Str + ";Persist
    ...
    See more | Go to post
    Last edited by darrel; Dec 17 '07, 02:41 AM. Reason: incomplete deatils

    Leave a comment:


  • darrel
    replied to Networking With Vb6
    Hi guys so far this is the code i have, but it gives me an error that the path name is not valid

    Code:
    Set cnn = New ADODB.Connection
    cnn.ConnectionString = _
     "Provider=Microsoft.Jet.OLEDB.4.0;" & _
              "Data Source=" & App.Path & "\\192.168.1.60\C:\My Documents\DentalDB.mdb;"
    cnn.Open
    192.168.1.60 is the ip address of the computer...
    See more | Go to post

    Leave a comment:


  • darrel
    replied to Networking With Vb6
    Thank you for that information, but how can i achieve it, can you give me some example codes of that, or could you give some tutorials or site on how to do it.. Thank you very much...
    See more | Go to post

    Leave a comment:


  • darrel
    started a topic Networking With Vb6

    Networking With Vb6

    Hello there VB wizards. I have a few questions, regarding how networking works with Visual Basic. It's like this - I have a PC that has the database of all my system. It's like a central database pc. Now I want to know how I can access those databases in another PC. For able for me to me achieve network.

    By the way, the databases that are in the central database PC are all Access.

    Another question; Will App Path work...
    See more | Go to post
    Last edited by Killer42; Dec 14 '07, 03:56 AM.

  • i think this is the right condition "If counter < 0".
    See more | Go to post

    Leave a comment:


  • darrel
    replied to List Box And Adodb Combination
    Thank you for all the advice and tips. I figured out how I can populate database records in my list box, I just used the long method procedure.

    Now, I have a new question for you guys. Now that I'm able to populate database records in my lists, what I wanted to do now is to populate all the items in my lists to a datareport to produce a hard copy.

    Can you give me sometimes, I'm nearly close in finishing my Medical and...
    See more | Go to post
    Last edited by Killer42; Oct 28 '07, 03:14 AM.

    Leave a comment:


  • darrel
    replied to List Box And Adodb Combination
    Hello, ive tried what debasisdas suggestion, no sad to say no luck, there no error on runtime, but it doesnt populate my database record in the listbox and it has infinite loop.

    Any more suggestion am badly need to finish this task so that my system will be implemented... Thank you..
    See more | Go to post

    Leave a comment:


  • darrel
    replied to List Box And Adodb Combination
    Theres no error on runtime my problem is the name are not populated in the list box. i will try another sequence. ill keep you posted . Many thanx.
    See more | Go to post

    Leave a comment:


  • darrel
    started a topic List Box And Adodb Combination

    List Box And Adodb Combination

    Hey guys i have a question am having trouble in displaying record in a list box, what i want to achieve is this... i have 2 check boxes, checkbox1 is name MEASLES and checkbox is name "CHICKEN POX". i have a database name MEDICALDB and has 4 tables named STUDENT NUMBER, NAME, CHIKEN POX AND MEASLE..

    i have this example database record:

    Student Number Name Chiken Pox ...
    See more | Go to post
    Last edited by debasisdas; Oct 26 '07, 05:51 AM. Reason: Added code=vb tag

  • Can you show us the code that solved your problem, for the purpose of helping others experiencing same problem? Thank you.
    See more | Go to post
    Last edited by Killer42; Oct 23 '07, 02:02 AM.

    Leave a comment:


  • darrel
    started a topic Data Report Problem

    Data Report Problem

    Question: How can i add runtime parameter using DATA REPORT in vb6?
    For example: i want to show the record of a specific customer
    personal information only.

    e.g.
    "SELECT * FROM CustomerInfo WHERE CustomerName = ' " & txtName.text & " ' "


    Any ideas will be a great help for my system... Thank you...
    See more | Go to post

  • darrel
    started a topic Data Report Printing

    Data Report Printing

    Good VB master i have a question reagrding data reports... i've developed a system called "Automated Medical History" for a clinic... the system ive developed is up and running, but cant produce a hard copy of the reports. but my system a data report available, my problem is i dont know how i can print the data report itself, i hope you can give some ideas on how i can do it!!!


    Thank you!
    See more | Go to post

  • darrel
    started a topic Crystal Report v8

    Crystal Report v8

    Hello there people, i just want to ask, can somebody point me to the right direction where can i find a download of crytal report v8...


    Thank you.. am planning to learn crystal reporting for my programs.... i prefer version 8, because i already have a key code for it..


    Again thank you!
    See more | Go to post

  • darrel
    started a topic How to import VB6 Forms and Object to WINWORD

    How to import VB6 Forms and Object to WINWORD

    Hi vb wizards i hope you can help me with my problem, i've developing an automated medical and dental records using vb6. My system works well in every functions except for printing... I dont know how to print...

    My system includes a search engine, searching for records... if record found a form pops-up, displaying all neccessary details of a specific record... the problem is i dont know how to print it..

    So come up...
    See more | Go to post

  • darrel
    replied to Printing Issue
    Thank you very much for all the help.. i will check it out and gather some data's with it.. Special Thanks to Mayur2007...
    See more | Go to post

    Leave a comment:


  • darrel
    started a topic Printing Issue

    Printing Issue

    Hi there VB Masters. I have a few questions regarding printing process in VB.

    My question is how can I print the whole form and its components in VB6? It's like this - I have a form, that contains labels, check boxes and radio buttons. How can I print it in a short bond paper?

    Lastly can you give some website where I can get some tutorials on how to use crystal reporting in VB6?

    Thank you, any help will...
    See more | Go to post
    Last edited by Killer42; Oct 10 '07, 02:43 AM.

  • darrel
    started a topic Saving Problem

    Saving Problem

    Hi there vb masters i have a problem regrading the saving procedure in my program:

    Here my code:

    Code:
    Private Sub cmdSave_Click()
    Dim rsShowRec As New ADODB.Recordset
    Dim cnn As New ADODB.Connection
    
    Set cnn = New ADODB.Connection
    cnn.ConnectionString = _
     "Provider=Microsoft.Jet.OLEDB.4.0;" & _
              "Data Source=" & App.Path & "\dbTimeScheduling2.mdb;"
    ...
    See more | Go to post

  • I think its nine:

    For more info, i can give my program, what my program does is it tells the users what key did she/ he press on the key board

    Here the code hope it can help!:

    Code:
    Private Sub Text1_KeyDown(KeyCode As Integer, Shift As Integer)
    Dim strKeyPressed As String
    
    Select Case KeyCode
    
    Case vbKeyControl
        strKeyPressed = "Ctrl"
    ...
    See more | Go to post

    Leave a comment:


  • need help to simply my code (LOOPING STATEMENT)

    Hi vb master i need help on this

    here my code:
    Code:
    If Combo1(0) = rs.Fields("TimeStart") And Combo4(0) = rs.Fields("TimeEnd") And Combo2(0) = rs.Fields("ROOM") And Combo3(0) = rs.Fields("DAYS") Then
                    cmdSave.Enabled = False
                    MsgBox ("There's a conflict on this!"), vbCritical
               
               Else
    ...
    See more | Go to post

  • darrel
    started a topic LOOP Testing (True of False)

    LOOP Testing (True of False)

    Hi there i have a problem with the looping statement that i must use in order to achieve wha i want..

    Its like this i have a time scheduling system that compares records in a database the compare process is not a problem.

    if like this, what ive been compare is this:

    if combo1(x) = rs! "TimeStart and combo2(x) = rs!TimeEnd then

    txtCode.backcol or = vbred
    txtSubjects.bac kcolor =...
    See more | Go to post
No activity results to display
Show More
Working...