<div>
GRayl<br />
The first does work. Your solution does work, thanks<br />
<br />
flavo, thanks for the follow up
</div>


GRayl
The first does work. Your solution does work, thanks

flavo, thanks for the follow up

<div>
Thanks, glad I could help. &nbsp;Your Submit button stutters, just like jaffer's ;-)
</div>


Thanks, glad I could help.  Your Submit button stutters, just like jaffer's ;-)

<div>
There is a problem with EE.<br />
<br />
I posted in th Bugs TA.<br />
<br />
<a href="http:Q_21483999.html" rel="ugc">http:Q_21483999.html</a>
</div>


There is a problem with EE.

I posted in th Bugs TA.

http:Q_21483999.html [http:Q_21483999.html]

<div>
<div class="content wysiwyg-content">
Is there a way to use a query instead of a table in the code below?<br />
<br />
InfoArray = CurrentDb.TableDefs(&quot;tblCe<wbr />lls&quot;).Open<wbr />Recordset.<wbr />GetRows(99<wbr />9999)<br />
<br />
this didn't work:<br />
InfoArray = CurrentDb.QueryDefs(&quot;SELEC<wbr />T Meas FROM tblCells&quot;).OpenRecordset.G<wbr />etRows(999<wbr />999)
</div>
</div>


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)

load array with sql instead of table

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.