load array with sql instead of table

Is there a way to use a query instead of a table in the code below?

InfoArray = CurrentDb.TableDefs("tblCells").OpenRecordset.GetRows(999999)

this didn't work:
InfoArray = CurrentDb.QueryDefs("SELECT Meas FROM tblCells").OpenRecordset.GetRows(999999)
avoorheisAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

GRayLCommented:
Firstly, the first should not have worked.

I think it should be:

InfoArray = CurrentDb.Openrecordset("tblCells").GetRows(999999)

Get rows has to work on a recordset so to use a query:

InfoArray = CurrentDB.Openrecordset("Select Meas FROM tblCells").GetRows(999999)

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
flavoCommented:
First thing..

Why use an array when a recorset provides the same and more functionality of an array.

Second, this is how it's done

    Dim r As DAO.Recordset
    Dim v As Variant
   
    Set r = CurrentDb.OpenRecordset("SELECT * FROM myTable;")
    v = r.GetRows

Dave
avoorheisAuthor Commented:
GRayl
The first does work. Your solution does work, thanks

flavo, thanks for the follow up
Your Guide to Achieving IT Business Success

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

avoorheisAuthor Commented:
GRayl
The first does work. Your solution does work, thanks

flavo, thanks for the follow up
GRayLCommented:
Thanks, glad I could help.  Your Submit button stutters, just like jaffer's ;-)
flavoCommented:
There is a problem with EE.

I posted in th Bugs TA.

http:Q_21483999.html
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.