Search Results - VBForums

Search:

Type: Posts; User: morbid.ivan

Page 1 of 7 1 2 3 4

Search: Search took 0.02 seconds.

  1. 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...
  2. Need Help : Mdi Child (Maximized Resize)

    How to avoid form resizing when opening another form?
  3. 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'"
  4. Re: Need Help : (VB6 + MySql + Crystal Report) Inner Join

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

    Result I got :
    118611

    Query still giving me same message. Cannot found
  6. 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...
  7. Re: Need Help : (VB6 + MySql + Crystal Report) Inner Join

    Nope, I don't know how.

    Can please tell me how to do it?
  8. 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...
  9. 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 +...
  10. Re: Need Help : (VB6 + MySql + Crystal Report) Inner Join

    The table exist. Check this out...
  11. 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
  12. Re: Problem : Generating Unique Number (too slow)

    (Text Type) Primary field
  13. 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
    ...
  14. Re: Problem : Generating Unique Number (too slow)

    Is my approach is right, having a Front-end every user?
  15. Re: Problem : Generating Unique Number (too slow)

    Nothing happens, still slow.

    But when I've try to put the program where the back-end database located, I can filter more than 1000 records
    less than 3 seconds.

    Maybe the link between Back-end...
  16. Problem : Generating Unique Number (too slow)

    I split my Ms Access DB to Front-end to Back-end.
    Total records stored is more than 30 thousand.

    my problem is, when im generating unique number took 10 seconds.

    my code :


    Dim i As Long
  17. Re: Need Help (String to Mathematical Equation)

    117629
  18. Need Help (String to Mathematical Equation)

    I have a single line formula in my database table.

    Field name : salFormula

    Example :

    "= (value 1 + value 2) * 3 / 2"
    "= (value 1 + value 2 + value 3) / 2"
    "= (value 1 - value 2) * 2"
  19. Replies
    1
    Views
    113

    Help : Datagrid bind combobox

    How to bind combobox to datagrid?


    Any help?
  20. Re: Need Help : Insert record and adjust number sequence

    Aside on Autonumber I also have another field to hold series number.
  21. Need Help : Insert record and adjust number sequence

    Series -- Name
    E-001---- John
    E-002---- Phil
    E-003---- Bill
    ------- > Going to insert record here (I need this to become E-004)
    E-004---- Ron
    E-005---- Han
    E-006---- Joanne
    E-007---- Millet
  22. Replies
    4
    Views
    724

    looking for Icons : 16x16 and 32x32

    I am looking for icon set for vbalExplorer or toolbar.
    size : 16x16 and 32x32

    Thanks in advance
  23. Replies
    1
    Views
    314

    MDI Child form Need help

    Need help about MDI child form.

    How to avoid the current form from sending back? Like in MS Excel, when you "Find and Replace"
    the 'FIND form' still visible without sending back.

    Any Help?
  24. Replies
    3
    Views
    282

    Re: dateadd problem

    I get your point. Thanks for the help.

    My code now is :



    Private Sub cmd_Gen_Click()
    Dim dDate As Date
    dDate = DateAdd("d", -1, dtPck.Value)
    dAdd dDate
  25. Replies
    3
    Views
    282

    [RESOLVED] dateadd problem

    Private Sub Form_Load()
    dAdd "6/1/2014"
    End Sub

    Function dAdd(ByVal dFrom As Date)
    Dim i As Integer
    i = 0
    For i = 1 To 15

    dFrom = DateAdd("d", 1, dFrom)
  26. crystal report : Suppress Group Header (Need Help Urgent)

    How do I Suppress 'GROUP' if 'Details' section is blank, and then move to next page showing the next 'GROUP'?

    EXAMPLE :

    Page #1
    GROUP - A
    Detail Section
    - Blank.

    If Blank Details, page...
  27. Re: Need Help : Problem after Make Executable file, it disappears

    When I remove 'OFFICE RIBBON' control, exe file runs.
  28. Re: Need Help : Problem after Make Executable file, it disappears

    I'm using Avast.
  29. Re: Need Help : Problem after Make Executable file, it disappears

    is the form MANIFEST.res can cause this problem? Does putting project on desktop can trigger the compiled file from hiding? And what anti-virus should I use to stop this problem?
  30. Replies
    0
    Views
    125

    Need help : Lan Messenger

    I am trying to create a system that can check if the user is online/offline in database.
    User account will be displayed in Treeview, icon will be changed depends on status if it is online/offline.
    ...
  31. Re: [RESOLVED] Need help : determine if the value is within the range

    I already solved the problem. I found my mistakes.

    Here's the code :



    Do Until rs.EOF

    myFormula = Format(myFormula, "#.#0")
    ...
  32. Re: Need help : determine if the value is within the range

    Dim cn As New ADODB.Connection
    Dim m_rate As Double
    Dim m_cola As Double

    Private Sub cmd_EE_Click()
    Dim rs As ADODB.Recordset
    Dim myString As String
    Dim myFormula As Double
    Dim m_B1, m_B2 As...
  33. [RESOLVED] Need help : determine if the value is within the range

    I need help about, determining if the value is within the range.

    In my case, the value doesn't fall to correct bracket/range.

    Please see the attached file. Thanks
  34. Re: Need Help : Problem after Make Executable file, it disappears

    when I disable the antivirus, the exe file runs.
  35. Need Help : Problem after Make Executable file, it disappears

    after I make my project to .exe, when I open it, the file disappears

    any help out there?
  36. Replies
    8
    Views
    330

    Help : Middle name to Initial

    I am trying to get middle initial from middle name.

    for example :

    Walker = W.
    Gilberto = G.

    My problem is what if the middle name is like this :

    Dela Cruz = it must be D.C.
  37. Replies
    7
    Views
    335

    Re: Datagrid Paging?

    [QUOTE=robie;4681307]Hi morbid.ivan, I've been goggling your problem and i found these http://www.sourcecodester.com/node/4128 .. You can download the source code in that page..

    The language used...
  38. Replies
    1
    Views
    159

    Help : WAMP MySql Import database

    How to import more than 1GB Database?

    Need your help guys ASAP.
  39. Replies
    7
    Views
    335

    Re: Datagrid Paging?

    Here's my complete code




    Dim lCurrentPage As Long
    Dim lItm As ListItem

    Private Sub cmdNavigate_Click(Index As Integer)
  40. Replies
    7
    Views
    335

    Re: Datagrid Paging?

    Yes I cant. This is my code on listview, this shows 20 records per page.




    Set rs = New ADODB.Recordset
    rs.CursorLocation = adUseClient
    rs.CursorType = adOpenForwardOnly...
Results 1 to 40 of 244
Page 1 of 7 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.