<div>
I just tested it again and its fine. Thanks<br />
<br />
Seamus
</div>


I just tested it again and its fine. Thanks

Seamus

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have a form where im trying to run a make table query.<br />
<br />
Two questions<br />
<br />
(1) to run the query, is this code correct?<br />
<br />
DoCmd.OpenQuery &quot;GL Balances&quot;, acViewNormal<br />
<br />
(2) to transfer that out of the MDB to excel, is this code correct?<br />
<br />
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, &quot;Balances&quot;, &quot;G:\Asset Services MI\UnMatched Merit\Balances.xls&quot;, True, &quot;GL Balances&quot;<br />
<br />
<br />
Thanks<br />
Seamus
</div>
</div>


Hi,

I have a form where im trying to run a make table query.

Two questions

(1) to run the query, is this code correct?

DoCmd.OpenQuery "GL Balances", acViewNormal

(2) to transfer that out of the MDB to excel, is this code correct?

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, "Balances", "G:\Asset Services MI\UnMatched Merit\Balances.xls", True, "GL Balances"


Thanks
Seamus

Access form

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.