[0theghost0]

شكرا اخي على مجهودك ولكن هناك خطأ

الكود

Using conn As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\Database1.accdb;Persist Security Info=False;")
Dim cmd2 As New OleDbCommand
cmd2.CommandType = CommandType.Text
cmd2.Connection = conn
cmd2.CommandText = "select max (Ren_NO) from [Rent_Equipment] "
conn.Open()
Dim a As Integer = cmd2.ExecuteScalar
conn.Close()
TextBox5.Text = a
End Using

مكان الخطأ
Dim a As Integer = cmd2.ExecuteScalar

عنوان الخطأ

An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll

Additional information: Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.

فهل انا وضع شيء ليس في مكانه ؟؟