SQL-Server
Access
Case When Sex='1' Then 'G'
Else 'M' End
IIF(Sex='1','G','M')
Where DataDate = '2011/09/30'
Where DataDate = #2011/09/30#
Where Mane Like 'ABC%'
Where Mane Like 'ABC*'
- Oct 08 Tue 2013 11:22
-
[VBA][Access與SQL Server的語法差異]
- Oct 08 Tue 2013 11:21
-
[VBA][Access 97讀取INI檔案]
------------------------------[VBA程式碼]---------------------------------
Private Declare Function GetPrivateProfileString Lib "kernel32" Alias "GetPrivateProfileStringA" (ByVal lpApplicationName As String, ByVal lpKeyName As Any, ByVal lpDefault As String, ByVal lpReturnedString As String, ByVal nSize As Long, ByVal lpFileName As String) As Long
Private Declare Function GetPrivateProfileString Lib "kernel32" Alias "GetPrivateProfileStringA" (ByVal lpApplicationName As String, ByVal lpKeyName As Any, ByVal lpDefault As String, ByVal lpReturnedString As String, ByVal nSize As Long, ByVal lpFileName As String) As Long
- Oct 08 Tue 2013 11:21
-
[VBA][Access 97找尋目前檔案路徑]
- Oct 08 Tue 2013 11:08
-
[VBA][建立一文字檔及讀取一文字檔]
- Oct 08 Tue 2013 10:14
-
[VBA]Access程式集
http://vb.ncis.com.tw/LMVB2.0/exp/exp.html
VB新增資料表或資料庫.
http://tw.knowledge.yahoo.com/question/question?qid=1607042107814
======================================================================================================================
設定資料新增或修改的警告視窗
----------------------------
DoCmd.SetWarnings False
- Aug 15 Mon 2011 10:00
-
[VBA]Access巨集指令
巨集指令
============================================================
事件 Event 說明
--------------------------------------------------------
On Enter 焦點對準在按鈕時，主要是指焦點的移動是來源自
"同一張表單內"的控制物件時，所觸發的事件。
On Exit 焦點從按鈕上移走
On Got Focus 取得焦點，主要是指焦點的移動是來源自"同一張
表單內"或"別的視窗"的控制物件時，所觸發的事件。
On Lost Focus 失去焦點
On Click 按一下按鈕時
On Dbl Click 按兩下按鈕時
On Mouse Down 滑鼠按鈕按下時
On Mouse Move 滑鼠移動時
On Mouse Up 滑鼠按鈕放開時
On Key Down 按下鍵盤按鍵放開
On Key Up 鍵盤按鍵放開時
On Key Press 鍵盤按鍵按下時
============================================================
事件 Event 說明
--------------------------------------------------------
On Enter 焦點對準在按鈕時，主要是指焦點的移動是來源自
"同一張表單內"的控制物件時，所觸發的事件。
On Exit 焦點從按鈕上移走
On Got Focus 取得焦點，主要是指焦點的移動是來源自"同一張
表單內"或"別的視窗"的控制物件時，所觸發的事件。
On Lost Focus 失去焦點
On Click 按一下按鈕時
On Dbl Click 按兩下按鈕時
On Mouse Down 滑鼠按鈕按下時
On Mouse Move 滑鼠移動時
On Mouse Up 滑鼠按鈕放開時
On Key Down 按下鍵盤按鍵放開
On Key Up 鍵盤按鍵放開時
On Key Press 鍵盤按鍵按下時
1