Thread
:
Set Mytable = MyDB.OpenRecordset
View Single Post
#
4
March 3rd, 2010, 12:57 AM posted to microsoft.public.access.tablesdbdesign
Steve[_77_]
external usenet poster
Posts: 1,017
Set Mytable = MyDB.OpenRecordset
Hello Tom,
ProductTable needs to be enclosed inside double quotes.
Steve
"Tom" wrote in message
...
Help,
I am not much of a programmer, but I have managed to build a fairly good
tool.
The original code was written in 2003 but upon the conversion to 2007, I
get a Type Mismatch on the following code.
Const ProductTable = "Products"
Dim MyTable As Recordset
Dim MyDB As Database
Dim PNHolder As String
Set MyDB = CurrentDb()
Set MyTable = MyDB.OpenRecordset(ProductTable) ---ß Error appears
here??
Steve[_77_]
View Public Profile
View message headers
Find all posts by Steve[_77_]
Find all threads started by Steve[_77_]