JithuAccess
Member
- Local time
- Today, 15:40
- Joined
- Mar 3, 2020
- Messages
- 297
Hello Guys,
This is my Code:
Dim db As Database
Dim rst As Recordset
Dim STRSQL As String
Set db = CurrentDb()
STRSQL = "Select [Table1.ID] from [Table1];"
Set rst = db.OpenRecordset(STQSQL)
I am getting an error message like:
I have this Table1 in my Database. I have no idea why I am getting this Error. Could you kindly let me know what is the Error.
Thanks
This is my Code:
Dim db As Database
Dim rst As Recordset
Dim STRSQL As String
Set db = CurrentDb()
STRSQL = "Select [Table1.ID] from [Table1];"
Set rst = db.OpenRecordset(STQSQL)
I am getting an error message like:
I have this Table1 in my Database. I have no idea why I am getting this Error. Could you kindly let me know what is the Error.
Thanks