DATAENVIRONMENT designer in visual basic 6? FORMATTING?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • psyvanz
    New Member
    • Sep 2009
    • 26

    DATAENVIRONMENT designer in visual basic 6? FORMATTING?

    Code:
    Private Sub add_Click()
    
    dt1.rsCommand1.AddNew
    
    t1.Text = t2.Text + 1 ' << HELP ME HERE!!! I STARTED 000001.. 
    IF I CLICK ADD COMMAND BUTTON, 
    SO IT MUST BE 000002 NOT ONLY NUMBER 2.
    ' BECAUSE I ONLY KNOW ADDING STYLE 1,2,3,4... 
    SO ON AND SO FORT.
     ' I WANT LIKE THIS FORMAT OF ADDING - 000001,000002,000003...
    SO ON AND SO FORT..(AUTONUMBER)
    ' WHAT SHOULD I DO? THANKS IN ADVANCE...
    
    ' NOTE: I'M USING DATAENVIRONMENT DESIGNER.. 
    NOT ADODC, DAO OR A MODULE...
                                
     'IF YOU HAVE PROBLEM IN RUNNING MY PROGRAM TRY TO 
    SET THE CONNECTION OF DATAENVIRONMENT..
     'DOBLE CLICK(DT1)RIGHT CLICK (CONNECTION)FIND (PROPERTIES) 
    THEN CHANGE THE CONNECTION STRING.. 
    LOCATED IN MY FOLDER NAMED DATABASE2.MDB
                  
    'THANKS AGAIN..FOR HELPING..
    
    
    "[B]YOU CAN SEE MY FORM BELOW IN ATTACHMENTS,[/B]
    [B] IF YOU DONT UNDERSTAND THANKS? [/B]
    
    [I][B]SCAN FIRST BEFORE EXTRACTING!!![/B]"[/I]
    
                        
    End Sub
    
    Private Sub save_Click()
    
    dt1.rsCommand1.Update
    
    t2.Text = Val(t1.Text)
    
    End Sub
    
    Private Sub delete_Click()
    
    dt1.rsCommand1.delete
    
    End Sub
    
    Private Sub previous_Click()
    
    dt1.rsCommand1.MovePrevious
    
    End Sub
    
    Private Sub next_Click()
    dt1.rsCommand1.MoveNext
    End Sub
    Private Sub Form_Load()
    
    dt1.rsCommand1.MoveLast
    
    t2.Text = t1.Text
    End Sub
    Attached Files
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    Have you tried to use the Format function ?

    Comment

    • psyvanz
      New Member
      • Sep 2009
      • 26

      #3
      yes... but if i add code= val(text2.text) + 000001 it will not give the 000002 else it goes only "2" like 1 + 1=2, thats the matter?

      Comment

      • debasisdas
        Recognized Expert Expert
        • Dec 2006
        • 8119

        #4
        You need to format the values after adding not before that.

        Comment

        • psyvanz
          New Member
          • Sep 2009
          • 26

          #5
          Originally posted by debasisdas
          You need to format the values after adding not before that.
          sir, is it in the DATAFORMAT OF A TEXTBOX; i've tried it nothing really works...

          sir, if you know the code of this formatting an autonumber; kindly post here...

          autonumber... must start in 000001, 000002, 000003.....so on and so fort....

          YOU CAN USE 1 TEXT BOX AND 1 COMMAND BUTTON... THAT EVERYTIME, YOU CLICK THE COMMAND BUTTON IT WILL ADD... AND IF YOU UNLOAD IT... AND RUN AGAIN, IT WILL START TO THE LAST NUMBER.. LIKE THIS

          TEXT1.TEXT = 000001
          CLICK THE COMMAND BUTTON= 000002
          NEXT CLICK COMMAND BUTTON=000003.. . SO ON AND SO FORT
          WHEN YOU UNLOAD THE FORM... AND THEN RE-RUN... IT WILL START IN 000003..
          AND IF YOU CLICK THE COMMAND BUTTON AGAIN= 000004


          thx in advance.... i just want the code.... i think, this is the right way... to solve my problem.... i know you dont want to download my attachment but.... thats the only way you can help me... to know deeply my problem.... JUST SCAN IT SIR IF YOU AFRAID IN VIRUSES... BEFORE EXTRACTING...

          Comment

          Working...