My query datasheet is hidden behind my forms

[jafoxy]

Please help as I have a problem at work.

There is a button on my form that runs a query. It all works fine except that the query results are shown behind my form instead of coming to the front. I have looked in the properties for a popup option (like I found for forms and reports) but I cannot find one. I can close the form to view the results but we don't want our users to be able to see all the Access menus etc. I can bring forms and reports to the front but not queries. I would put this into a report but we require the data in datasheet view.

Alternatively, is there an easy way (with a click of a button on my form) to export the query data straight to Excel. I can do this using the Access menus (Tools / Office Links / Analyse It with Microsoft Excel) but I don't want my users to be able to see the Access menus.

I am using Office 2003 with Windows XP Professional.

I hope this all makes sense.

Please help,
Jafoxy

[Lysander]

Please help as I have a problem at work.

There is a button on my form that runs a query. It all works fine except that the query results are shown behind my form instead of coming to the front. I have looked in the properties for a popup option (like I found for forms and reports) but I cannot find one. I can close the form to view the results but we don't want our users to be able to see all the Access menus etc. I can bring forms and reports to the front but not queries. I would put this into a report but we require the data in datasheet view.

Alternatively, is there an easy way (with a click of a button on my form) to export the query data straight to Excel. I can do this using the Access menus (Tools / Office Links / Analyse It with Microsoft Excel) but I don't want my users to be able to see the Access menus.

I am using Office 2003 with Windows XP Professional.

I hope this all makes sense.

Please help,
Jafoxy

You can export to excel under code. Below is an example I used to allow a user to extract some data into excel

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel3, "qryCombinedWithChildren", "z:\bissau\CombinedWithChildren.xls", True
 

Checkout Help TransferSpreadsheet for what all the parameters mean

[hyperpau]

Please help as I have a problem at work.

There is a button on my form that runs a query. It all works fine except that the query results are shown behind my form instead of coming to the front. I have looked in the properties for a popup option (like I found for forms and reports) but I cannot find one. I can close the form to view the results but we don't want our users to be able to see all the Access menus etc. I can bring forms and reports to the front but not queries. I would put this into a report but we require the data in datasheet view.

Alternatively, is there an easy way (with a click of a button on my form) to export the query data straight to Excel. I can do this using the Access menus (Tools / Office Links / Analyse It with Microsoft Excel) but I don't want my users to be able to see the Access menus.

I am using Office 2003 with Windows XP Professional.

I hope this all makes sense.

Please help,
Jafoxy

Why don't you create another form bound to your query. Then format that form's properties as DefaultView = Spreadsheet.

Then program your button to pull up the form instead of the query.

[rath]

I have similar problem. I created the form in datasheet view and bound to query already. But the problem is if the query changes the field, the form will be error. I need to create a form in datasheet to bound to my dynamic column query so i can view my query to pivottable. If create to subform, it cannot view as pivotable. Any advise?

[Nguyen Van Tuan]

I did it in access 2010
I had a same problem. But I could brought my query coming to the front by:
- Dont't popup the form(set popup to "no")
- Choose File\Options\Current Database.
- Click Overlapping Windows