Access : Delete all row from access 2007

you can use query Delete from nameTable

but if you see alert "Disabled Mode xxxxx",
you must enabled mode ;

Step 1: Show the Message Bar

If the Message Bar is already visible, you can skip this step.

• On the Database Tools tab, in the Show/Hide group, select the Message Bar check box.
  

If the Message Bar check box is disabled, you will have to enable it.

after that you can enabled the mode...after disabled mode you can use query  Delete from nameTable

AX : Get Label Enum AX 2012

SysDictEnum InventTransPostingTypeEnum = new SysDictEnum(enumnum(InventTransPostingType) );

InventTransPostingTypeEnum.value2Label(_SID.InventTransPostingType);

AX : Working with dates X++ (https://dynamicsaxed.wordpress.com/2015/06/04/working-with-dates-in-x/)

I was working on some date related functionality the other day during which I discovered some really useful date functions in X++. Some of you might be familiar with some of this already, however it is always good to have a blog post out there that lists them all for future reference. I have also added sample code for the usage of each function.

Initialization

A date variable can be initialized with a date constant. The date literal in X++ has a predefined format i.e. dd\MM\yyyy. Note that backslash is used instead of forward slash and unlike string constants neither single nor double quotes is used.

transDate = 01\01\2015;


today

Returns the date of the machine on which the code is run.

transDate = today();


systemDateGet

AX : Pengurangan Bulan dari 2 Variabel

 bulan=intvNo(paramFromDate, paramToDate, intvScale::YearMonth);  

AX: Get End Month AX 2012

you can get end month with endmth
example
endmth(dateMthFwd(tanggalmulai,-jmlbulan));

Query : Contoh Query Fcuntion SQL Server

create function CustBalanceAsOfTransDatex ( @AsOfDate datetime, @DataAreaID varchar(10) )
returns table
as return (
select a.ACCOUNTNUM, sum(AMOUNTMST - isnull(Terbayar, 0)) as Sisa, cust.CUSTGROUP,dirp.NAME as names
from (

    select   
        ct.*,
        (select sum(SETTLEAMOUNTMST - EXCHADJUSTMENT)
            from CUSTSETTLEMENT cset
            where cset.ACCOUNTNUM = ct.ACCOUNTNUM and cset.TRANSRECID = ct.RECID
                and partition = 5637144576 and DATAAREAID = @DataAreaID
                and cset.TRANSDATE <= @AsOfDate)
                as Terbayar
    from
        (
            select VOUCHER, INVOICE, CLOSED, POSTINGPROFILE, AMOUNTMST, AMOUNTCUR, RECID, ACCOUNTNUM, TRANSDATE
            from CUSTTRANS
            where --AccountNum = 'CUST-C006' and
            partition = 5637144576 and DATAAREAID = @DataAreaID
            and TRANSDATE <= @AsOfDate
            and TransType in (
            0, --None
            2, -- Sales
            15, -- payment
            8, -- cust
            36 -- General Journal
            ) and
            POSTINGPROFILE = 'GEN' and (Closed = '1900-01-01' or Closed > @AsOfDate)
        ) ct
) a inner join CUSTTABLE cust on a.ACCOUNTNUM = cust.ACCOUNTNUM
inner join DIRPARTYTABLE dirp on cust.PARTY = dirp.RECID
where a.AMOUNTMST - isnull(a.Terbayar, 0) <> 0
group by a.ACCOUNTNUM, cust.CUSTGROUP,dirp.NAME
)
go

Register all .dll in one folder

you can use this :

for %A in (*.dll) do regsvr32 /u /s %A && regsvr32 /s %A