Hi,
I am a beginner for VB.
I copied a script from a data base and manipulated it for my DBase. I wanted to give a 'not in list' command, so that nay item not in teh list will be added to teh relevant column of teh table after we comfirm the message that comes in the form 'Do you want to add this to the list'.
But when running the script it gives error at "Dim dbs As DAO.Database"
Error is "Data base is not set as dbs.
Dim intResult As Integer
Dim strTitle As String
Dim intMsgDialog As Integer
Dim strMsg1 As String
Dim strMsg2 As String
Dim strMsg As String
Dim cbo As Access.ComboBox
Dim dbs As DAO.Database
Dim rst As DAO.Recordset
Dim strTable As String
Dim strEntry As String
Dim strFieldName As String
I am a beginner for VB.
I copied a script from a data base and manipulated it for my DBase. I wanted to give a 'not in list' command, so that nay item not in teh list will be added to teh relevant column of teh table after we comfirm the message that comes in the form 'Do you want to add this to the list'.
But when running the script it gives error at "Dim dbs As DAO.Database"
Error is "Data base is not set as dbs.
Dim intResult As Integer
Dim strTitle As String
Dim intMsgDialog As Integer
Dim strMsg1 As String
Dim strMsg2 As String
Dim strMsg As String
Dim cbo As Access.ComboBox
Dim dbs As DAO.Database
Dim rst As DAO.Recordset
Dim strTable As String
Dim strEntry As String
Dim strFieldName As String