Search Results - VBForums

Search:

Type: Posts; User: morbid.ivan

Page 1 of 5 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    11
    Views
    148

    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.
  2. Replies
    11
    Views
    148

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

    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
  4. Replies
    11
    Views
    148

    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
  5. Replies
    11
    Views
    148

    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...
  6. Replies
    11
    Views
    148

    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
  7. Re: Sending RICHTEXTBOX content to E-mail Problem

    Thanks for the idea. So very helpful.
  8. [RESOLVED] Sending RICHTEXTBOX content to E-mail Problem

    I need help about sending richtextbox contents to e-mail.

    my main problem is, I need to sent the contents on the way how the
    richtextbox is formated.

    for example : 'Good day' in 'Regular'...
  9. Re: Help : Upcoming birthday of the month

    I got it.

    strCriteria = "SELECT sNumber,eDOB,eLAST,eFirst,eSuffix,eClient,eEmail FROM sql_EMPLOYEE " _
    & "WHERE DAY(eDOB)>'" & Day(Now) & "' AND MONTH(eDOB)='" & Month(Now) &...
  10. [RESOLVED] Help : Upcoming birthday of the month

    I need help about displaying upcoming birthday of the same month.


    I have a code, but I don't know what is the right approach to execute it.




    strCriteria = "SELECT...
  11. Replies
    2
    Views
    80

    Re: Need help (Richtextbox KEYDOWN)

    I get your point. Thanks for the idea.




    With rtf

    If Shift = 2 And KeyCode = vbKeyB Then ' CTRL-B
    rtf.SelBold = Not rtf.SelBold
  12. Replies
    2
    Views
    80

    Need help (Richtextbox KEYDOWN)

    I am having a problem with (Shift + I) keycode to format ITALIC font.
    when pressing these combination, it also type letter I.

    What seems to be the problem?

    Any Help?



    Private Sub...
  13. Need help : Lynxgrid (Tab key moving to next cell)

    Is it possible on lynxgrid to move to next cell using TAB Key?

    Please see attached file.
  14. Re: Looking for : Grid Control (with databind and tab key moving to next cell)

    Is there any control you would suggest or similar with my needs aside from the link you've posted?
  15. Re: Looking for : Grid Control (with databind and tab key moving to next cell)

    Can I ask you one question? Is it possible to have a Tab key on LYNXGRID Control?
  16. Looking for : Grid Control (with databind and tab key moving to next cell)

    I am looking for Grid like excel, having a Tab key that can move to the
    next cell. Control can bind such as :
    Combobox, DTpicker and Textbox.


    Any help?
    Is there any control like this?
  17. Re: need help : Error (row cannot be located for updating)

    When I put rs.update inside IF.
    error prompt on rs.update
  18. Re: need help : Error (row cannot be located for updating)

    when I remove -1 from For.
    Error still on "rs.Find ("cNumber = '" & .CellText(i, 0) & "'")"
  19. Re: need help : Error (row cannot be located for updating)

    when I remove rs.update
    on first loop no error were found
    error comes on second loop on "rs.find"

    cNumber is on the first column - 1 to 10
  20. Re: need help : Error (row cannot be located for updating)

    112043
  21. Re: need help : Error (row cannot be located for updating)

    when I remove rs.update
    on first loop no error were found
    error comes on second loop on "rs.find"
  22. Re: need help : Error (row cannot be located for updating)

    yes. Is there's somethings wrong with my loop?
  23. Re: need help : Error (row cannot be located for updating)

    Error point on rs.update
  24. need help : Error (row cannot be located for updating)

    I am getting error (Row cannot be located for updating)

    Database : MySQL DB

    Here's my code



    Dim rs As ADODB.Recordset
    Dim sqlCriteria As String
  25. Re: Need help : Page showing row

    I got it.

    If lPage = 1 Then

    rPosition = "1 - " & lCount

    ElseIf (lPage * nPageSize - 20) + 1 >= rs.RecordCount Then

    ...
  26. Re: Need help : Page showing row

    111883
  27. [RESOLVED] Need help : Page showing row

    I am trying to show 5 records on each page.

    I need to display this status : "Showing row 1 - 5" I got this part.
    But moving to 2nd page status doesn't moving, the result must be "Showing row 5 -...
  28. Re: [RESOLVED] help : slow connection (mysql db + vb6)

    thanks for the help guys. I have learned a lot.
  29. Re: help : slow connection (mysql db + vb6)

    Result I got :

    Rs-retrieval (pure Select-Execution-Time): 4.164063 sec
    3.542969 sec
  30. Re: Need Help (Generate User ID Number on Mysql DB)

    After saving record to database table, how do I get the Generated Number for edit option without exiting the form?
  31. Re: help : slow connection (mysql db + vb6)

    My code for retrieving records


    Private Sub Populate_Employee()
    On Error Resume Next


    Dim rs As ADODB.Recordset
    Dim sqlCriteria As String
    Dim lRow, i As Long
  32. [RESOLVED] help : slow connection (mysql db + vb6)

    I am having a problem on MYSQL database connectivity.

    Not running smoothly. It take 2 to 10sec before records completely load on lynxgrid. Sometimes it hang up.

    Is there any way to save and...
  33. Need Help (Generate User ID Number on Mysql DB)

    I am using MYSQL DB.

    I am having a problem on Generating unique number, checking the database table if it is already taken.


    my problem. 2 users save record at the same time. and they get...
  34. Re: Need Help (Populate Date range to Listbox)

    Thanks a lot. It worked for me. This is what I am looking for.
  35. [RESOLVED] Need Help (Populate Date range to Listbox)

    How to populate Date range to Listbox?

    dFR = DtPicker1.Value ' From
    dTo = DtPicker2.Value ' To

    For example : (From : 02/27/2014) (To : 03/03/2014)



    The output must be like this :
  36. Problem with browsing 'icon' to form or image list

    I have create an icon from adobe photoshop cs3.

    When I've try to browse the 'icon' it says 'invalid picture'

    The size of the 'icon' I have created is 32x32.

    What seems to be the problem?
    ...
  37. Re: Need help (WMP play next on listbox)

    Finally, I got it.

    Private Sub playTime_Timer()

    playTime.Enabled = True

    If lstPlaylist.ListIndex < lstPlaylist.ListCount - 1 Then
    lstPlaylist.ListIndex =...
  38. [RESOLVED] Need help (WMP play next on listbox)

    how to play next movie or mp3 automatically?

    nothing happens on EndOfStream event.

    Please see attached file.

    any help?

    Codes
  39. Re: Need help : (Listiview 1 to Listview 2)

    Thanks for the idea. I finally got it.



    Dim lvwItem As MSComctlLib.ListItem

    For x = lv1.ListItems.Count To 1 Step -1


    If lv1.ListItems(x).Selected =...
  40. [RESOLVED] Need help : (Listiview 1 to Listview 2)

    I need help about copying the record from listview 1 to listview 2 without duplicating of records.

    This is my basic codes : It allows to create duplicate





    Dim x As Integer
    ...
Results 1 to 40 of 199
Page 1 of 5 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.