Hi all,
I am creating a database for a charity in the UK and having a problem with the following Select Statement. As you can see I am only selecting the fist and last names.
I am kind of new to this so any help would be appreciated
As I run the code an error message appears as follows.
Run Time Error 3078
"The Microsoft Database Engine cannot find the Table or Query 'Members_Contact_Details'. Make sure it exist
The Table does exist and is spelt the same way -- Can anyone HELP!!!
Option Explicit
Function BuryPostCode()
Dim dbs As Database, rst As Recordset
Set dbs = CurrentDb
Set rst = dbs.OpenRecordset("SELECT First_Name, " _
& "Last_Name FROM Members_Contact_Details;")
dbs.Close
End Function
Private Sub Command4_Click()
End Sub
I am creating a database for a charity in the UK and having a problem with the following Select Statement. As you can see I am only selecting the fist and last names.
I am kind of new to this so any help would be appreciated
As I run the code an error message appears as follows.
Run Time Error 3078
"The Microsoft Database Engine cannot find the Table or Query 'Members_Contact_Details'. Make sure it exist
The Table does exist and is spelt the same way -- Can anyone HELP!!!
Option Explicit
Function BuryPostCode()
Dim dbs As Database, rst As Recordset
Set dbs = CurrentDb
Set rst = dbs.OpenRecordset("SELECT First_Name, " _
& "Last_Name FROM Members_Contact_Details;")
dbs.Close
End Function
Private Sub Command4_Click()
End Sub