Form view to Datasheet view

A

Al Camp

Is there a VB command to cause a form (single form view - views
allowed = both) to change to Datasheet view... "on the fly"...
programmatically.

I checked out Default View, Views Allowed, and Current View, and
those don't appear to be what I want.

I have an Datasheet View icon on my toolbar, but I don't allow
users to access the toolbar.

Thanks in advance,

Al Camp
 
D

Dirk Goldgar

Al Camp said:
Is there a VB command to cause a form (single form view - views
allowed = both) to change to Datasheet view... "on the fly"...
programmatically.

I checked out Default View, Views Allowed, and Current View, and
those don't appear to be what I want.

I have an Datasheet View icon on my toolbar, but I don't allow
users to access the toolbar.

RunCommand acCmdDatasheetView
 
A

Al Camp

Thanks Dirk,
I knew it was do-able. Too bad the items I looked up in Help
didn't refer to the acCmd equivalent.... but I should have
thought to look there.
Thanks again,
Al Camp
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top