Animated Sidebar Slide Menu

[Arman]

Hi folks!



I am not really great when it comes to VBA and Access related stuff, so I was wondering if it would be possible to create a slide styled menu in an Access form.

[ranman256]

maybe...a lot of work for that tho.
a subform with controls on it, normally invisible.
click a button on the master form, start the subform 'off' screen , then visible
subfrm.left = me.width +1000

,then slowly move the subform to the left
while subfrm.left < me.width - 2000
subfrm.left = subfrm.left -100
next


a lot of work for a gimick.

[Arman]

maybe...a lot of work for that tho.
a subform with controls on it, normally invisible.
click a button on the master form, start the subform 'off' screen , then visible
subfrm.left = me.width +1000

,then slowly move the subform to the left
while subfrm.left < me.width - 2000
subfrm.left = subfrm.left -100
next


a lot of work for a gimick.

Ah, I see. So, I'd have a subform with all those menu items in it and I would set its visibility to "none". When I click on a button, it would run a macro that would bring the menu in and make it visible.

That does sound like quite some work. Though, I am unable to put the subforms on the right / left side.

[ranman256]

put the subform where you can see it,
at form load event move it waaaay off to the right , beyond me.width.

[Arman]

put the subform where you can see it,
at form load event move it waaaay off to the right , beyond me.width.

I have a feeling I am doing it incorrectly. When I save the code and open the form to test, the "side menu" (which is another form" can be seen. Imgur preview.

[Micron]

Didn't expect you could move a subform off of the main form's real estate, but I'm not going to try it anyway.
Here's what I would try - resizing and/or moving a rectangle, either left or right, where the rectangle background is the same colour as the form section. If an image is involved, then might not be possible - unless you add a clip of the image section and manage to get registration exact enough between the rectangle and the form section. So the rectangle would be 0 width to begin with, then expand to full width in steps. Maybe the rectangle doesn't have to be coloured at all, and can just be transparent.

[Micron]

looks like cross-posted here https://www.mrexcel.com/forum/micros...ndow-size.html
both image links result in the same image
Original Poster (OP): Please read this re: cross posting https://www.excelguru.ca/content.php?184