How to pop data from a table in MS Access 2003?  
Author Message
gil bil





PostPosted: Visual Basic for Applications (VBA), How to pop data from a table in MS Access 2003? Top

why does the next statement result in an error message

MsgBox Application.CurrentData.AllTables(tblECG).Properties.Item(1).Value

The Error: " The expression you entered refers to an object that is closed or doesn't exist'.

error number: 2467

any other suggestions to get a specified value from a table



Microsoft ISV Community Center Forums2  
 
 
ADG





PostPosted: Visual Basic for Applications (VBA), How to pop data from a table in MS Access 2003? Top

Hi

What are you trying to read form the table, data or one of its properties


 
 
Derek Smyth





PostPosted: Visual Basic for Applications (VBA), How to pop data from a table in MS Access 2003? Top

Hi,

Could this be because you missed the quotes around the table name

MsgBox Application.CurrentData.AllTables("tblECG").Properties.Item(1).Value