Home Forums AccessBooks RealTime Command Line Help?

Tagged: 

This topic contains 3 replies, has 4 voices, and was last updated by  Yudel Rosales 5 days, 20 hours ago.

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #16395

    kevin.patenaude
    Participant

    Anyone know how I can make the command below only pull information from the last six months to date?

    tables = “Receivepayment”
    cmd1 = strcat(cmd,param2)
    cmd11 = strcat (cmd1,”, “)
    cmd2 = strcat(cmd11,db)
    cmd22 = strcat(cmd2,”, Overwrite, “)
    cmdfinal = strcat(cmd22,tables)
    runshell(“C:\Program Files\Synegration\Acessbooks Realtime\AccessBooksRT.exe”,cmdfinal,””,@NORMAL,@WAIT)

    Any help would be appreciated.

    #16421

    Tom Crawford
    Keymaster

    I would recommend upgrading to our OpenSync Read Only product as we are no longer supporting ABRT.

    #67145

    Lewis
    Participant

    You can also use the Month function in a query in Microsoft Access. The first Month function will extract the month value from the date 13/08/1985 and display the results in a column called Expr1. You can replace Expr1 with a column name that is more meaningful.

    #67148

    Yudel Rosales
    Keymaster

    Unfortunately, we don’t support Access Books real Time anymore. I will recommend upgrading to OpenSync v3.
    Sorry for the inconvenience.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.