• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 287
  • Last Modified:

Access form

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
0
Seamus2626
Asked:
Seamus2626
1 Solution
 
peter57rCommented:
Are you having a problem with the code?
If so, what is going wrong?
0
 
Seamus2626Author Commented:
I just tested it again and its fine. Thanks

Seamus
0

Featured Post

2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

Tackle projects and never again get stuck behind a technical roadblock.
Join Now