ACCESS FEED: RE: [MS_AccessPros] can you with an event trigger flip a form from form view to datasheet view?

Jumat, 29 Juli 2011

RE: [MS_AccessPros] can you with an event trigger flip a form from form view to datasheet view?

Terence-

I don't think that's possible, because a form in Datasheet view can't show a
command button to "flip" it back. The command to "flip" to Datasheet would be:

DoCmd.RunCommand acCmdDataSheetView

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Terence
Sent: Friday, July 29, 2011 9:15 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] can you with an event trigger flip a form from form
view to datasheet view?

I want to place a button on a popup form that flips it to data sheet view and
vice versa, but I am not sure what property that would be nor what the property
value would be ?

TY
Terence

------------------------------------

Yahoo! Groups Links