Tags: access, database, datasheet, form, hoi, macro, menubar, microsoft, mysql, oracle, somebody, sql, switch, view
Access from "Form View" to "Datasheet View"
Somebody can help me out.
I need a macro where I can switch from the database "Form View" to the
I can do it with the menubar option, but I want to do it with a
Leave a comment...
- 1 Comments
- Hi johan,
I'm using Access 2000, but guess there will be not much differences in the
In the click_event of a button in a mask, try something like this:
If (Me.CurrentView = 1) Then ' Mask
ElseIf (Me.CurrentView = 2) Then ' Datasheet
In effect, the second condition is not fired, because in datasheet view the
button is no more present, but you can link this code to a different source
Hope this helps.
"johan" <jmslab.ms-access.questionfor.info.xs4all.nl> ha scritto nel messaggio
> Somebody can help me out.
> I need a macro where I can switch from the database "Form View" to the
> "Datasheet View".
> I can do it with the menubar option, but I want to do it with a
>#1; Sun, 01 Jun 2008 15:54:00 GMT