Search Results - VBForums

Search:

Type: Posts; User: morbid.ivan

Page 1 of 7 1 2 3 4

Search: Search took 0.01 seconds.

  1. 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
  2. Re: Need help Populate (Height or Tall) in combo box

    in combobox or listbox
  3. [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"
  4. 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
  5. 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
  6. Re: MySql : Unknown database problem

    I solve the problem guys, by re-installing wamp server and finally database shown up.
  7. [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...
  8. 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...
  9. Need Help : Mdi Child (Maximized Resize)

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

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

    Result I got :
    118611

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

    Nope, I don't know how.

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

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

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

    Is my approach is right, having a Front-end every user?
  22. 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...
  23. 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
  24. Re: Need Help (String to Mathematical Equation)

    117629
  25. 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"
  26. Replies
    1
    Views
    117

    Help : Datagrid bind combobox

    How to bind combobox to datagrid?


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

    Aside on Autonumber I also have another field to hold series number.
  28. 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
  29. Replies
    4
    Views
    774

    looking for Icons : 16x16 and 32x32

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

    Thanks in advance
  30. Replies
    1
    Views
    332

    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?
  31. Replies
    3
    Views
    307

    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
  32. Replies
    3
    Views
    307

    [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)
  33. 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...
  34. Re: Need Help : Problem after Make Executable file, it disappears

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

    I'm using Avast.
  36. 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?
  37. Replies
    0
    Views
    132

    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.
    ...
  38. 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")
    ...
  39. 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...
  40. [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
Results 1 to 40 of 251
Page 1 of 7 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.