Lock sizing of window

[Guest]

Hello,
I have (I hope!) finished my database. I want to lock the size of the
windows when they are opened, though. I've figured out how to lock them in
place so the user can't move them around, but I can't figure out how to
prevent the user from shrinking/enlarging the window. I thought the "can
shrink" and "can grow" options would prevent this (if I set to "NO") but that
didn't seem to do anything...thoughts? Thanks so much!!!

 

[Rob Parker]

Hi Jennifer,

Just set the Border Style for the form to Dialog. It prevents the form
being re-sized; it does not cause the form to open in dialog mode.

HTH,

Rob

 

[Guest]

Dude, you rock. That works perfect. So...how much do you know about deploying
to end users who don't have Access on their computer? That's where I'm
stuck right now. Someone had recommended VSTO but when I go to the site to
investigate, it's showing several programs. I'm new to releasing to users w/o
Access...so far I've only built programs for people who already HAVE Access...

 

[Rob Parker]

Hi again,

I know next-to-nothing about deploying to users without Access. But there
are plenty of people here who do know, and it's a fairly common question - a
search on this group in Google Groups should give you a good number of hits.
My memory of the general gist of them is:

1. End-users must have Access, or a run-time version of Access.

2. The run-time version is included in the Access Developers Kit, and can be
distributed with your application to end-users without any additional
payment or licencing.

I've never heard of VSTO, so I can't comment on that. If your search
doesn't give sufficient info, I'd repost that question as a new thread -
it's likely to get missed in this one now.

Rob