Search Results - VBForums

Search:

Type: Posts; User: morbid.ivan

Page 1 of 7 1 2 3 4

Search: Search took 0.01 seconds.

  1. 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...
  2. Replies
    0
    Views
    292

    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??
  3. 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?
  4. Replies
    3
    Views
    267

    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...
  5. Replies
    3
    Views
    267

    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...
  6. 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
  7. 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?
  8. Replies
    2
    Views
    265

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

    in combobox or listbox
  11. [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"
  12. 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
  13. 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
  14. Re: MySql : Unknown database problem

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

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

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

    Result I got :
    118611

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

    Nope, I don't know how.

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

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

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

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

    117629
  33. 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"
  34. Replies
    1
    Views
    189

    Help : Datagrid bind combobox

    How to bind combobox to datagrid?


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

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

    looking for Icons : 16x16 and 32x32

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

    Thanks in advance
  38. Replies
    1
    Views
    374

    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?
  39. Replies
    3
    Views
    388

    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
  40. Replies
    3
    Views
    388

    [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)
Results 1 to 40 of 259
Page 1 of 7 1 2 3 4



Featured


Click Here to Expand Forum to Full Width