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

Display an ADO recordset as a datasheet in MS Access data project

I am using Access 2002 as an adp front end to SQL Server 2000.  I want to create a recordset in ADO using parameters selected by the user and display it in a datasheet view, the same display result you get from DoCmd.OpenQuery and DoCmd.OpenStoredProcedure.
0
dwoliver
Asked:
dwoliver
  • 2
  • 2
1 Solution
 
Leigh PurvisDatabase DeveloperCommented:
I'm afraid that's not going to happen.
You could have a form (in datasheet mode) with the appropriately bound controls in it - and then set that form's recordset to be the recordset you've opened.
But a spontaneous datasheet from a recordset held in code isn't possible.
(You could write it out in a structured order to a file or something - but that isnt the same as a datasheet type grid)
0
 
dwoliverAuthor Commented:
Thanks for clarifying this issue.  A related follow-up question.  Is it possible to open a stored procedure as a datasheet AND pass it some parameters or can you only open sprocs that require no parameters?
0
 
Leigh PurvisDatabase DeveloperCommented:
Well, bear in mind that it's something I'd never want to do anyway... I certainly don't know of a way that you'd do that (without the parameter prompts popping up at you).

You should really be looking to use forms for such things.
You gain so much more control.
0
 
dwoliverAuthor Commented:
Thanks, LPurvis for your prompt responses.  Answer accepted.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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