Set Mytable = MyDB.OpenRecordset
in [Tables]
|
From: Steve on 3 Mar 2010 13:09 Yes I did. Thank you! "Allen Browne" <AllenBrowne(a)SeeSig.Invalid> wrote in message news:O8o945ouKHA.3896(a)TK2MSFTNGP02.phx.gbl... > Steve, I think you missed the constant declaration on the first line of > his code. > > -- > Allen Browne - Microsoft MVP. Perth, Western Australia > Tips for Access users - http://allenbrowne.com/tips.html > Reply to group, rather than allenbrowne at mvps dot org. > > > "Steve" <notmyemail(a)address.com> wrote in message > news:ue#TKymuKHA.3408(a)TK2MSFTNGP06.phx.gbl... >> ProductTable needs to be enclosed inside double quotes. >>> >>> 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?? >
From: John... Visio MVP on 3 Mar 2010 13:14
and you also missed the concept that these newsgroups are not provided so you can ply your questionable services. John... "Steve" <notmyemail(a)address.com> wrote in message news:eX9W2yvuKHA.4464(a)TK2MSFTNGP04.phx.gbl... > Yes I did. Thank you! > > > "Allen Browne" <AllenBrowne(a)SeeSig.Invalid> wrote in message > news:O8o945ouKHA.3896(a)TK2MSFTNGP02.phx.gbl... >> Steve, I think you missed the constant declaration on the first line of >> his code. >> >> -- >> Allen Browne - Microsoft MVP. Perth, Western Australia >> Tips for Access users - http://allenbrowne.com/tips.html >> Reply to group, rather than allenbrowne at mvps dot org. >> >> >> "Steve" <notmyemail(a)address.com> wrote in message >> news:ue#TKymuKHA.3408(a)TK2MSFTNGP06.phx.gbl... >>> ProductTable needs to be enclosed inside double quotes. >>>> >>>> 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?? >> > > |