[MS_AccessPros] Run VBA codes in query

 

Hi everyone,,, :)

Can we run vba codes in query..? for example i can run this codes below on click button on a form, but is it possible to run the codes in query..? Here is the codes sample:

If Month([TglSPT]) = 1 Then
Me.ExInt = "/SP/Set-DPRD/I/" & Year([TglSPT])
Me.NoSPPD_2 = "/SPPD/Set-DPRD/I/" & Year([TglSPT])
ElseIf Month([TglSPT]) = 2 Then
Me.ExInt = "/SP/Set-DPRD/II/" & Year([TglSPT])
Me.NoSPPD_2 = "/SPPD/Set-DPRD/II/" & Year([TglSPT])
Else Month([TglSPT]) = 3 Then
Me.ExInt = "/SP/Set-DPRD/III/" & Year([TglSPT])
Me.NoSPPD_2 = "/SPPD/Set-DPRD/III/" & Year([TglSPT])

Any explanation would be grateful,...thank you

Regards
Hendra Agestha

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 5
• New Files 3

Visit Your Group

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

.

__,_._,___