bir modul oluşturup modulümüze bu kodu yazalım
[color=#FF0000]Public Function SQLProsedur(Formx As Form, SQL_Prosedur As String)
Dim cn As ADODB.Connection
Dim rst As New ADODB.Recordset
Dim sorgu1 As String
Set cn = New ADODB.Connection
sorgu1 = SQL_Prosedur
cn.ConnectionString = verinedir()
cn.Open
rst.CursorLocation = adUseClient
rst.Open sorgu1, cn, adOpenKeyset, adLockOptimistic
Set Formx.Recordset = rst
rst.Close
cn.Close
Set rst = Nothing
Set cn = Nothing
End Functio
|
Yeni bir modul açalım ve bu kodları yazalım
[color=#FF0000]Public Function hatagec()
On Error Resume Next
End Function
Public Function BuGun()
BuGun = Date
End Function
Public Function Ileri()
DoCmd.GoToRecord , , acNext
End Function
Public Function Geri()
DoCmd.GoToRecord , , acPrevious
End Function
Public Function EnBas()
DoCmd.GoToRecord , , acFirst
End Function
Public Function EnSon()
DoCmd.GoToRecord , , acLast
End Function
Public Function Yeni()
DoCmd.GoToRecord , , a
|