hay expert??
i am newer on this forum? i want to create app that main databases locate in server? and my main server is '\\ACCOUNTING\smartksp\DATA\30\data'? in my main prg just like my attachment? so far when i call a program that i choose is running well, but when i want a copy apart of database into excel error message appear 'invalid path or file name' or sometime 'error ole control command prom'
ex: in my command button my coding on formset.form1 is
mserver = '\\ACCOUNTING\smartksp\DATA\30\excel'
mdate = date()
tempexcel = alltrim(thisformset.form1.text1.value) + ' ' + namemonth(mdate) + ' ' + year(mdate)
select mutasip.* from mutasip where date_income <= date() order by norekening into cursor tempmutasip
mexcel = 'mserver' + '\tempexcel'
export to (mexcel) type xl5
why this happend ?
i wanna place my mserver on my main.prg?
note :
namemonth() is function that i call from namemonth.prg and i store in in init formset
i am newer on this forum? i want to create app that main databases locate in server? and my main server is '\\ACCOUNTING\smartksp\DATA\30\data'? in my main prg just like my attachment? so far when i call a program that i choose is running well, but when i want a copy apart of database into excel error message appear 'invalid path or file name' or sometime 'error ole control command prom'
ex: in my command button my coding on formset.form1 is
mserver = '\\ACCOUNTING\smartksp\DATA\30\excel'
mdate = date()
tempexcel = alltrim(thisformset.form1.text1.value) + ' ' + namemonth(mdate) + ' ' + year(mdate)
select mutasip.* from mutasip where date_income <= date() order by norekening into cursor tempmutasip
mexcel = 'mserver' + '\tempexcel'
export to (mexcel) type xl5
why this happend ?
i wanna place my mserver on my main.prg?
note :
namemonth() is function that i call from namemonth.prg and i store in in init formset
