How to pop data from a table in MS Access 2003?

Hot Topic

excel rowheight
Problem passing a range as argument
SendKeys open application
Updating a pivot table
automatical start macro in access2003
Loop causing MS Word freeze
Can anybody explain this code for me ???
Closing desktop opened word wants to close embedded word object
Help with a formula
Using VBA macro to locate next free column on worksheet

Microsoft ISV

Selection of only one object
Help with highlighting employees nominating each other for awards...
Allowing the user to pick a cell in excel
use inputbox to choose cells for plots in excel
Compatibility Issue Excel 2000 and Excel 2003
Updating text in a text box on an Excel Graph
personalized command bar disappears when minimizing excel
MS Office document and image writer print driver
Help with a formula
Assigning new series to chart

How to pop data from a table in MS Access 2003?

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



Answer this question

How to pop data from a table in MS Access 2003?

  • MichaelMouer

    Hi,

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

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



  • Michael Vanhoutte

    Hi

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


  • How to pop data from a table in MS Access 2003?
Answer this question