Open table recordset

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to open a table and read values. The following code causes error:

Set db = CurrentDb()
Set snpTblConnect = db.OpenRecordset("tsDB_Connection", dbOpenSnapshot)

With snpTblConnect
strApp = !AppName
End With

How can I read the table values?
Thanks
 
smk23 said:
I am trying to open a table and read values. The following code
causes error:

Set db = CurrentDb()
Set snpTblConnect = db.OpenRecordset("tsDB_Connection",
dbOpenSnapshot)

With snpTblConnect
strApp = !AppName
End With

How can I read the table values?
Thanks
Click to expand...

What is the error?
 
Rick, I'm having one of those "blank stare and can't think" moments. The
error was "item not in collection" because what I want is the value of column
"strConnect" when the value of column "strConnectionItem" is "AppName".
I'm trying to save connection info in a table and trying to read from the
table. This is simple but I'm drawing a blank right now. How do I do this?
 
Back
Top