User Profile

Collapse

Profile Sidebar

Collapse
songsu
songsu
Last Activity: Aug 23 '15, 09:19 PM
Joined: Aug 22 '15
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • songsu
    replied to Need help for a loop
    in Access
    I have it solved. Thank you.
    See more | Go to post

      Leave a comment:

    • songsu
      started a topic Switch from batch file to VBscript
      in Visual Basic

      Switch from batch file to VBscript

      I have a batch file to start Access macro like this:

      Code:
      "C:\Program Files\Microsoft Office\OFFICE14\MSACCESS.EXE" "C:\users\sus.ACEELAC\Desktop\DailyRun\DailyRun.accdb" /Excl /X macNewfall
      I want to change to Vbscript to run the macro because I have other code in my VBscript. Sorry if I post to the wrong category as I cannot find VBscript forum. Please help. Thank. you.
      See more | Go to post
      • songsu
        started a topic Need help for a loop
        in Access

        Need help for a loop

        My qryDataToSend has following result:

        KeyField Full_Name COURSE NPDD CENSUS LDTD Email
        jd1001 John Doe ART 001-0101 1/15/2015 2/16/2015 3/17/2015 johndoe@fakeema il.com
        jd1001 John Doe ART 023-0202 1/16/2015 2/17/2015 3/18/2015 johndoe@fakeema il.com
        my1002 May Yee MATh 115-0303 7/1/2015 8/2/2015 9/3/2015 mayyee@thisemai l.com
        my1002 May Yee LAW 001-0505 8/1/2015 9/4/2015 10/20/2015 mayyee@thisemai l.com...
        See more | Go to post
        No activity results to display
        Show More
        Working...