Search Results - VBForums

Search:

Type: Posts; User: morbid.ivan

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Re: Problem : Generating Unique Number (too slow)

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

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

    117629
  7. 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"
  8. Replies
    1
    Views
    90

    Help : Datagrid bind combobox

    How to bind combobox to datagrid?


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

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

    looking for Icons : 16x16 and 32x32

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

    Thanks in advance
  12. Replies
    1
    Views
    289

    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?
  13. Replies
    3
    Views
    232

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

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

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

    I'm using Avast.
  18. 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?
  19. Replies
    0
    Views
    107

    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.
    ...
  20. 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")
    ...
  21. 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...
  22. [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
  23. Re: Need Help : Problem after Make Executable file, it disappears

    when I disable the antivirus, the exe file runs.
  24. 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?
  25. Replies
    8
    Views
    268

    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.
  26. Replies
    7
    Views
    294

    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...
  27. Replies
    1
    Views
    144

    Help : WAMP MySql Import database

    How to import more than 1GB Database?

    Need your help guys ASAP.
  28. Replies
    7
    Views
    294

    Re: Datagrid Paging?

    Here's my complete code




    Dim lCurrentPage As Long
    Dim lItm As ListItem

    Private Sub cmdNavigate_Click(Index As Integer)
  29. Replies
    7
    Views
    294

    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...
  30. Replies
    7
    Views
    294

    Datagrid Paging?

    Is it possible to have a data paging on Datagrid?

    I was able to do this with listview, but I dont know how in Datagrid.

    Any Help?

    My Basic Code
  31. [RESOLVED] Need Help : Datagrid Column Maxlength

    How to limit datagrid column length?

    for example :
    column1 : 5 chars.
    column2 : 64 chars.

    any help?
  32. Replies
    2
    Views
    189

    Re: List out all forms open

    Thanks a lot. This code really worked for me.
  33. Replies
    2
    Views
    189

    [RESOLVED] List out all forms open

    How to list out all forms open into a list box?

    Any help?
  34. Replies
    2
    Views
    186

    Help : MySql Database Exist

    How do I check if the MySql Database found or not found on Specific IP Address?

    Any Help?
  35. Replies
    11
    Views
    368

    Re: Help : Payment Scheduling

    Please see attached file

    I was able to adjust on 10 and 20, 3 and 18. And I got the result that I am Looking for.

    Now my problem is 15 and 31.
  36. Replies
    11
    Views
    368

    Re: Help : Payment Scheduling

    Another set of example is just in case the schedule was changed into 10 and 20 of the month instead of 15 and last day of the month.
  37. Replies
    11
    Views
    368

    Re: Help : Payment Scheduling

    For example :
    Payment starts on Jan 3, 2014
    Ends on Feb 18, 2014

    or
    Payment starts on Jan 10, 2014
    Ends on Feb 20, 2014
  38. Replies
    11
    Views
    368

    Re: Help : Payment Scheduling

    Thank you. This is what I am looking for.

    Thank you so much for the help guys. I owe you this.

    One more question.

    For example :
    Payment starts on Jan 3, 2014
    Ends on Feb 18, 2014
  39. Replies
    11
    Views
    368

    Re: Help : Payment Scheduling

    I am sorry about the term 'Give(s)', what I mean to say is 2 payments per month.
    The payment is 15 and last day of the month(s).

    Example :

    Payment Term : 2 months.

    Payment Starts on : Jan...
  40. Replies
    11
    Views
    368

    Help : Payment Scheduling

    I need help about payment scheduling.

    Example :
    Deduction Starts on : 01/15/2014
    Ends on : Last day of February
    Payment Mode : 2 Months/4 Gives

    Result I am Looking

    1 - 01/15/2014
Results 1 to 40 of 233
Page 1 of 6 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.