View Single Post
  #84 (permalink)  
Old 03-30-09, 12:14
pkstormy pkstormy is offline
Moderator
 
Join Date: Dec 2004
Location: Madison, WI
Posts: 3,925
Embed Query into a form/Export queries/Show crosstabs

The following example shows how you can embed a query into a subform for users to easily view it. This works very well for crosstab or any type of query (where you want the query results controlled by a form display.)

It especially works well for crosstab type queries where the header "fields" are unknown.

BONUS: Also included is the "browser" shell for easily exporting any query to a filename and then opening that folder.

The nice thing I like about this method is that when the form is open and a user wants to navigate through the records/fields, it works just like Excel does (ie. you can push the down arrow key and it goes down to the next record but stays on that column!)
Attached Files
File Type: zip CrossTabQueryFormAndExportDataExample.zip (211.8 KB, 988 views)
__________________
Expert Database Programming
MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Last edited by pkstormy; 04-26-10 at 15:25.
Reply With Quote