CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 6 of 6

Threaded View

  1. #3
    Join Date
    May 2012
    Posts
    8

    Re: How to get all data updated to the new one

    While Not rstData4.EOF

    If rstData4("SpecID") = SpecId Then
    ReviewDate3 = UCase$(Trim$(NullReturn(rstData4("SpecLastUpdate"), "")))
    ReviewDate3 = rstData4("SpecLastUpdate")
    ReviewDate4 = DateAdd("m", 60, ReviewDate3)
    EffectiveDate2 = ReviewDate4
    GoTo FoundSpec
    Else
    rstData4.MoveNext
    End If

    Wend



    okey, I have rstData3 and rstData4 which are the databases in access. Those databases have same specid and title and i compared in order to get the date(speclastupdate) that only have in rstData4.

    SpecId = rstDate3
    ReviewDate3 = the name for speclastupdate in rstData4
    ReviewData4 = new date after dateadd
    EffectiveDate2 = date displayed in output attached (EFFECTIVE_DATE)

    Hope these information will good enough for u to help me to figure out what was the problem? please..
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured