x Want to participate? Join the group to interact

  • Use Browse() with "NOT IN" where clause/filter

    Hi, I need to do filtering using the "NOT IN" just like in SQL SERVER, but with Browse() function in ACCPAC library. I try using NOT IN with browse but got error, I guess its not supported. Is there other way to filter similar to "NOT IN"? Thank you.

  • Get List of Companies database using MSSQL Query

    Hi, I want to create a Business Intelligence Report by using Report Manager & Connector. In this report, I want to get rows from table APPYM of all Companies database. But first, I need to know which database is actually a company database for Sage…

  • Get user using windows authentication and domain

    i want login using macro. but using windows authentication and specific domain can anyone can help me?

  • get Field value in macro into a variable Vb.net.

    I want to get value from PORCP1detail1Fields.FieldByName("ITEMDESC"). the condition that i have set if PORCP1header.Read how to get the previous data from that field and set into a variable in vb Example: Dim vItemDesc As String = "" vItemDesc…

*Community Hub is the new name for Sage City