Search Results - VBForums

Search:

Type: Posts; User: morbid.ivan

Page 1 of 7 1 2 3 4

Search: Search took 0.02 seconds.

  1. 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?
  2. Replies
    3
    Views
    191

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

    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...
  4. 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
  5. 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?
  6. Replies
    2
    Views
    233

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

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

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

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

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

    Result I got :
    118611

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

    Nope, I don't know how.

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

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

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

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

    117629
  31. 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"
  32. Replies
    1
    Views
    148

    Help : Datagrid bind combobox

    How to bind combobox to datagrid?


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

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

    looking for Icons : 16x16 and 32x32

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

    Thanks in advance
  36. Replies
    1
    Views
    355

    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?
  37. Replies
    3
    Views
    352

    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
  38. Replies
    3
    Views
    352

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

    When I remove 'OFFICE RIBBON' control, exe file runs.
Results 1 to 40 of 257
Page 1 of 7 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.