Alert icon
We're changing our privacy policy. This stuff matters.  Learn more  Dismiss

MS Access: Expand only selected SubDatasheets

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
955 views
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Sep 10, 2009

Forms![FormName]![SubFormName].Form.SubdatasheetExpanded = True - can be used to expand ALL of the SubDatasheets on your form.
However often you want only some of SubDatasheets to be expanded, based on some criteria (for example - expand only if SubDatasheet contains data..)

Download demo database attached to see how that could be done using Accessibility library.
Make sure you have added a reference for "Accessibility" library (%windir%\system32\oleacc.dll)

http://sites.google.com/site/msaccesscode/

Category:

Science & Technology

Tags:

License:

Standard YouTube License

  • likes, 0 dislikes

Link to this comment:

Share to:
see all

All Comments (0)

Sign In or Sign Up now to post a comment!
Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more