I want to populate combo box with particular field value of a table in ms access.
datafile = "D:\database.accdb"
.Provider = "microsoft.ACE.OLEDB.12.0"
.ConnectionString = datafile
Set rs = cn.Execute("select * from mytable")
Do Until rs.EOF
I am getting runtime error 3705 provider of object connection failed
Private Sub Form_Load()
Dim Conn As New ADODB.Connection
Dim rs As ADODB.Recordset
Set Conn = New ADODB.Connection
Conn.Provider = "Microsoft.ACE.OLEDB.12.0"
Conn.CursorLocation = adUseClient
Set rs = New ADODB.Recordset
rs.Open "select * from mytable", Conn, adOpenDynamic, adLockBatchOptimistic
While Not rs.EOF
I have a 2d matrix with dimension (3, n) called A, I want to calculate the normalization and cross product of two arrays (b,z) (see the code please) for each column (for the first column, then the second one and so on).
the function that I created to find the ...
Hi. I have a form with list box : lst_product, datagridview : grd_order and button: btn_addline. lst_product has a list of product ids selected from database (MS Acess 2013) , grd_order is by default empty except for 2 headers and btn_addline adds rows to grd_order.