Search Results - VBForums

Search:

Type: Posts; User: morbid.ivan

Page 1 of 7 1 2 3 4

Search: Search took 0.02 seconds.

  1. Treeview populate (Invalid object error)

    Treeview

    +Root (I got this part)
    --Parent (I got this part)
    ---Child (Error starts here)

    I am trying to join 2 tables, but no success.
    I got this Error "Invalid object 35610"
  2. Help: Inserting new row and updating existing row

    I have 2 different tables table1 name 'tab1' and table2 named 'tab2'.

    I can insert record to table2 and update table1 using separate button. 1 button for adding/insert and 1 for updating table1
    ...
  3. Re: Help: joining 2 statement (Insert and Update)

    129741
  4. Re: Help: joining 2 statement (Insert and Update)

    In mysql, query worked well.



    UPDATE `tab1` SET `Addr`='SPL',`Remarks`='NEW HOME' WHERE `LinkID`='E-001';INSERT INTO `tab2` (`LinkID`,`Addr`,`Remarks`) VALUES ('E-001','SPL', 'NEW HOME');

    ...
  5. Re: Help: joining 2 statement (Insert and Update)

    Additional information:

    For example:

    I insert record on table2 named 'tab2'
    LinkID = 'E-001'
    Address = txtaddr.Text
    Remarks = txtRemarks.Text

    At the same time it must update table1 name...
  6. Help: joining 2 statement (Insert and Update)

    Is it possible to join 2 different statement in one query?




    I use this to insert record
    Dim strQry As String

    strQry = "INSERT INTO tab2 " & _
    "(LinkID, Addr, Remarks) " & _
  7. Help: Display selected fields inListview

    I have a blank Listview, and I also have a List Box (Checkbox)

    Listbox Items: (database Table Fields)
    -ID
    -Surname
    -Given
    -MI
    -Age
    -Birthday
    -Gender
  8. Re: need help:treeview selecting nodes

    I get it... Problem solved



    If Not node.Parent Is Nothing Then
    If Not node.Parent.Parent Is Nothing Then
    MsgBox "Child"
    Else
    ...
  9. Replies
    8
    Views
    241

    Re: help with small code ado

    Dim rs As ADODB.Recordset
    Dim lItems As ListItem

    ListView1.View = lvwReport
    ListView1.ListItems.Clear

    Set rs = New ADODB.Recordset
    With rs
    .CursorLocation = adUseClient
    ...
  10. Re: need help:treeview selecting nodes

    Please check out what went wrong.



    Dim objNode As node

    Set objNode = .SelectedItem

    If Not objNode Is Nothing Then
    If objNode.Children > 0 Then
  11. [RESOLVED] need help:treeview selecting nodes

    Selecting treeview nodes

    Tree Example:

    Root
    >--- IBANEZ (Parent Node)
    |------ Gio (Child Node)
    |------ RG
    |------ JEM
    |------ PGM
  12. Need help: display joined table on listview

    SELECT a.ID, a.Name, b.ID, b.Name, b.Relationship FROM tbl_Name AS a
    INNER JOIN tbl_Dependents AS b ON b.ID=a.ID

    Example

    tbl_Name
    ID|Name----------|
    1 |James Hinrich
    2 |Larch Hamster
    3...
  13. Replies
    0
    Views
    349

    Crystal Report 9 Looking for Hotfix

    Is there anyone has cr90dbexwin_en.zip?

    I can't download it from: ftp://ftp.crystaldecisions.com/outgoing/ehf/cr90dbexwin_en.zip

    Any Help??
  14. Help! Wamp Mysql Database (Import 1GB or More)

    How do I Import more than 1GB database?
    Is it possible to do this with work bench?

    Any suggestions?
  15. Replies
    3
    Views
    297

    Re: Need Help : Textbox date format

    Is it possible on Lost Focus if no value, clear format or simply blank?
    Example : Mask Format "##/##/####"
    With Value : "01/01/2015"
    Without Value : "//"
    How do I remove this "//" if no date...
  16. Replies
    3
    Views
    297

    Need Help : Textbox date format

    Example :
    1. 01/
    2. 01/01/
    3. 01/01/2015

    As I type I need to have a slash char on count of 2 and 5 which is already done.

    Now, my problem is when I press backspace I was stuck on this...
  17. Re: Need help : random system password each day?

    Is it possible password will based on date?

    can you please show some examples? im not knowledgable about AES Encryption
  18. Need help : random system password each day?

    is it possible to have a random login password each day based on date and time?
    for security reasons.

    Any idea?
  19. Replies
    2
    Views
    281

    Need help (DTPICKER) Quarterly range

    How to generate date range quarterly.

    For example

    option 1 - 1st quarter
    option 2 - 2nd quarter
    option 3 - 3rd quarter
    option 4 - 4rt quarter

    I choose "option 4"
  20. Re: Need help Populate (Height or Tall) in combo box

    Public Sub heightLister(cbo As ComboBox)
    Dim iWeight As Integer

    cbo.Clear

    Dim iCtr As Integer
    Dim iLoop As Integer

    For iLoop = 4 To 6
  21. Re: Need help Populate (Height or Tall) in combo box

    in combobox or listbox
  22. [RESOLVED] Need help Populate (Height or Tall) in combo box

    121859

    How do I sort this out?

    Example :
    4'8"
    4'9"
    4'10"
    4'11"
    4'12"
  23. Need Help : MS Access Autonumber (in custom format)

    is it possible to have a custom autoincrement number that resets every year?

    example :
    20140001
    20140002
    20140003
    20140004


    20150001
  24. Need help : Get Autonumber after adding record

    Reference : Adodb
    Database : MySql

    How to get the auto increment number after adding new record?

    Thanks in advance
  25. Re: MySql : Unknown database problem

    I solve the problem guys, by re-installing wamp server and finally database shown up.
  26. [RESOLVED] MySql : Unknown database problem

    I am having a problem on WAMP Server (PHPmyAdmin) when I open it, no database on list but still accessible.
    When I try to create new database I am getting error "Unknown database" but in ODBC test...
  27. Re: Need Help : Mdi Child (Maximized Resize)

    Example :
    - > Current child-form State (Maximized) let's call this "Form #1",
    trying to open another form which is in (Normal) state,
    the "Form #1" resizes into "Normal State" and it should not...
  28. Need Help : Mdi Child (Maximized Resize)

    How to avoid form resizing when opening another form?
  29. Re: Need Help : (VB6 + MySql + Crystal Report) Inner Join

    Take a look at this :




    Dim rpt_Sql As String
    rpt_Sql = "SELECT * From SQL_MAIN " _
    & "INNER JOIN SQL_RELATE ON SQL_MAIN.BATCH = SQL_RELATE.BATCH " _
    & "Where SQL_MAIN.BATCH='1'"
  30. Re: Need Help : (VB6 + MySql + Crystal Report) Inner Join

    Thank you... I will wait for your respond.
  31. Re: Need Help : (VB6 + MySql + Crystal Report) Inner Join

    Result I got :
    118611

    Query still giving me same message. Cannot found
  32. Re: Need Help : (VB6 + MySql + Crystal Report) Inner Join

    SELECT *
    FROM SQL_MAIN
    INNER JOIN SQL_RELATE ON SQL_MAIN.BATCH = SQL_RELATE.BATCH
    WHERE SQL_MAIN.BATCH =1
    LIMIT 0 , 30


    I generated this from MySql, but when I put this on VB6 same error...
  33. Re: Need Help : (VB6 + MySql + Crystal Report) Inner Join

    Nope, I don't know how.

    Can please tell me how to do it?
  34. Re: Need Help : (VB6 + MySql + Crystal Report) Inner Join

    [QUOTE=digitalShaman;4753955]where does the error pop up? is it in this line:

    rs_Report.Open rpt_Sql, conn
    ? then it has got nothing to do with crystal reports.

    The report opens based on query...
  35. Re: Need Help : (VB6 + MySql + Crystal Report) Inner Join

    Public Function konektodata(strServer As String, uName As String, uPass) As Boolean
    On Error GoTo errHandle
    Dim MyOdbcOption
    MyOdbcOption = optFoundRows + optVB + optBigPacket +...
  36. Re: Need Help : (VB6 + MySql + Crystal Report) Inner Join

    The table exist. Check this out...
  37. Need Help : (VB6 + MySql + Crystal Report) Inner Join

    I am having a problem Joining 2 tables in crystal report 9.

    Always showing : Remove Table

    The database table "sql_relate" cannot be found.




    Dim rs_Report As ADODB.Recordset
  38. Re: Problem : Generating Unique Number (too slow)

    (Text Type) Primary field
  39. Re: Problem : Generating Unique Number (too slow)

    Dim rsGEN As ADODB.Recordset
    Dim sqlCriteria As String
    Dim cNum As Long

    Set rsGEN = New ADODB.Recordset
    rsGEN.CursorLocation = adUseClient
    rsGEN.CursorType = adOpenStatic
    ...
  40. Re: Problem : Generating Unique Number (too slow)

    Is my approach is right, having a Front-end every user?
Results 1 to 40 of 270
Page 1 of 7 1 2 3 4



Featured


Click Here to Expand Forum to Full Width