Access Datasheet Control

C

cefrancke

Is there a way to attach the Access Datasheet control to a VB project?
Does Access expose this control to other programming languages via
whatever method?

I'm looking for those cool Access datasheet features to use in a VB
prog.

TIA
 
N

Naresh Nichani MVP

Hi:

You can use the Access subform only within Access to the best of my
knowledge.

VS has a FlexGrid and DBGrid but they do not come close to the Access
subform datasheet view.

Regards,

Naresh Nichani
Microsoft Access MVP
 
M

M.L. Sco Scofield

If you are writing a VB program, you should be asking you question in a VB
group.

There are 36 of them that all start with microsoft.public.vb.

FYI, there is no such thing as a datasheet control in Access. All datasheets
in Access are actually forms displayed in datasheet view.

What you want in VB is a grid control. VB ships with a couple of them and
there are lots of third party ones.

Good luck.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Denver Area Access Users Group Vice President www.DAAUG.org
MS Colorado Events Administrator www.MSColoradoEvents.com
Useful Metric Conversion #18 of 19: 8 nickels = 2 paradigms (My personal
favorite)
Miscellaneous Access and VB "stuff" at www.ScoBiz.com
 
C

cefrancke

No, I think that the question is appropriate here, it is about a
feature in Access.
I've made references to OCX's, DLL's, OLB's, TLB's and such in Access
just like VB. Again, a feature in Access.
I was just wondering if Access exposed the datasheet, the features are
very useful.

I'll concede that this is a question that could go wither way.... :)

However, the question still remains, is this custom control (a window
control not included in the standard MS-Windows library) designed by
Microsoft ( the form in Access, that can have a datasheet view )
available through a reference to Access's Object Library or ActiveX
component registration?

TIA
 
B

Brendan Reynolds

I believe it is unlikely that you will be able to use an Access datasheet in
this way in a VB app. However, Sco is correct that you are more likely to
get a definitive answer in a VB newsgroup, because VB developers are more
likely to have attempted it.

You could, of course, automate Access from VB in order to display the data
in a datasheet view within Access. But that would require all users to have
Access installed, as well as being not particularly fast or
resource-efficient.
 
M

M.L. Sco Scofield

One more time. It is *NOT* a control. It is an Access object. It would be
like asking to use a VB form in Access. A VB form is *NOT* a control. It is
a VB object. It just ain't going to happen.

As Brendan said in his post, you could certainly use an Access form (or
other Access object) through automation. And, as Brendan said, everyone will
need Access installed on their machines. And then we can talk about the
marshalling overhead.

The functionality of an Access form in datasheet view is something that the
VB developers have drooled over for years. Their only solution is to use a
grid control. The only people that can tell you which grid control will be
the best choice for your task will be a VB developer that has used the
different grid controls for different tasks.

And like I said to start with, one of the VB groups is where you will find
those VB developers. (My MCSD is in VB. Just why do you think I sent you to
the VB groups?)

Or, you can do like I did (and many other VB developers have done,) and give
up VB and just use Access. The only thing I ever use VB for any more is to
make library DLLs to use in Access.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Denver Area Access Users Group Vice President www.DAAUG.org
MS Colorado Events Administrator www.MSColoradoEvents.com
Useful Metric Conversion #18 of 19: 8 nickels = 2 paradigms (My personal
favorite)
Miscellaneous Access and VB "stuff" at www.ScoBiz.com
 
M

M.L. Sco Scofield

This message is being returned to you unread because you have been
identified as
a newsgroup user.

A copy has been sent to the newsgroup for follow-up.

Please read http://www.mvps.org/access/netiquette.htm for the proper use of
the
newsgroups.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

----- Original Message -----
From: <[email protected]>
To: "M.L. Sco Scofield" <[email protected]>
Sent: Friday, February 11, 2005 23:54
Subject: Re: Access Datasheet Control

I figure I'll spare the public the dirty laundry...
It doesn't serve the greater good. To teach.

I think you need to get off the caffiene and relax.

I appreciate your comments that *ADDRESS* my question.
This is something that I find many on these groups can't seem to grasp,
which is, answer the question!

I knew by your credentials that you had the answer, which put to rest
that one can not touch the Access object that I'm referring to in a
traditional reference/component method, at least, not without great
difficulty.

You also figured (and I believe you were able from your experience)
that I wanted to have a VB grid behave like said object, which is true.

I dont mind figuring out the programming code to emulate the sublties,
I'll definitely will be on your recommended VB group a askin'.

I can appreciate how frustrating it can be seeing the same questions
over and over, or even seeing someone misguided and asking of the wrong
group.
But, you have a choice, to help or humiliate.

I get frustrated with the lack of depth to the answers, when I know
some of the readers are aware of what I'm doing.

I deal with this type of situation everyday, the same questions over
and over.
I try to glean what the person is asking, acknowledging that I
understand what they are asking in general, and gently send them on
their way with an answer and advice toward more resources to consider
to keep them on track. It's my responsibility, obligation, and endeavor
to make sure they understand what they need, by encouraging them to
learn.

I read your "Sco on SCO" and I have found respect for you in your words
and philosophy (they are truly misguided), not on the letters that
follow your name. Striving for excellence IS the only way to bring
about a better world for everyone.

Your experience is with a proprietary computer software, mine is with
general theory of nature. Everyone in this arena is entitled to dignity
and respect.

My intent was not to irritate anyone, I just wanted to make sure I
wasn't wasting my time with all the programming that may lie ahead.
I do agree that the features of Access provide a better choice for db
development, when it comes to user interfaces.

In my case, some clients do not use the Office products but have a need
for a db oriented application. (Oracle/SQL Server/MySQL etc back end)

Your humble friend,

C. E. Francke, Ph.D. (Philosophiae Doctor) Electrical Engineering,
Computer Science
 
Top