Re: [belajar-access] BackUp

 

Dear Kang Cecep, Environ fungsi standar di VBA Access, sepertinya tidak perlu Microsoft Visual Basic for Application exrensibility 5.3. Karena itu, harus dipisah di query dengan simbol &. Misal:

 

DoCmd.RunSQL "UPDATE Bkup_Ctrl SET Bkup_Ctrl.bkupdate = Date(), Bkup_Ctrl.workstation ='" & Environ("COMPUTERNAME") & "';"

 

Wassalaamu'alaikum Warahmatullahi Wabarakatuh,
Sofyan Efendi
http://imopi.wordpress.com/

----- Original Message -----

From: cepwahyu

To: belajar-access@yahoogroups.com

Sent: Tuesday, May 15, 2012 12:01 PM

Subject: [belajar-access] BackUp [1 Attachment]

Hallo para access mania,

 

Saya nemu contoh untuk backup tapi selalu muncul error "undefined function 'environ' in expression" padahal di preference-nya sudah sya centang Microsoft Visual Basic for Application exrensibility 5.3 tetapi selalu error.

Mungkin ada mengalami kasus yg sama?

Contoh terlampir

 

Best Regards

CW

 

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 9

Visit Your Group

SPAM IS PROHIBITED

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___