[AccessD] How to Force the Location of a small form next to a report

Tue Sep 27 21:20:48 CDT 2016

Howdy,

Coming into this one a bit late. I have also written (Way back in the day) a companion form that needed to ‘follow’ a main form, if the main form was moved.

I achieved a nice little ‘snap to’ feature by having code set the position of a trailing form relative to the position of a main form. Added that code to the timer on the ‘trailing’ form. Worked well for that application

Dunno if that helps – Just thought I’d post J

Have fun

Darren

From: AccessD <accessd-bounces at databaseadvisors.com> on behalf of Stuart McLachlan <stuart at lexacorp.com.pg>
Organization: Lexacorp
Reply-To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Date: Saturday, 17 September 2016 9:30 am
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Subject: Re: [AccessD] How to Force the Location of a small form next to a report

That moves the "Active Window", so I suspect it won't work until the control form is already 

on screen and has the focus.

The Form.Move method has the advantage that it  can be applied during creation but before 

the form is displayed.

On 16 Sep 2016 at 21:59, Brad Marks wrote:

Rocky,

Thanks!  I will need to experiment with this.

Brad

-----Original Message-----

From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf

Of Rocky Smolin Sent: Friday, September 16, 2016 4:41 PM To: 'Access

Developers discussion and problem solving'

<accessd at databaseadvisors.com> Subject: Re: [AccessD] How to Force the

Location of a small form next to a report

I think MoveSize may work IIUC what you're trying to accomplish:

https://msdn.microsoft.com/en-us/library/office/ff197394.aspx

rocky

-----Original Message-----

From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf

Of Brad Marks Sent: Friday, September 16, 2016 2:16 PM To: Access

Developers discussion and problem solving Subject: [AccessD] How to

Force the Location of a small form next to a report

All,

Recently, I was asked to develop a small form which controls the data

that appears on a related report.  

This form has six text boxes and five radio buttons.  By using these

text boxes and radio buttons, our users can control the data that is

shown on the report. 

Our users have fairly wide screens.  There is room to show the entire

form on the right size of the report.

Is there a way to force the form to always appear in a specific

location? Currently, when the form is opened, it appears in the upper

left of the window.  I would like to have it always appear on the

right side of the report.

Thanks,

Brad Marks  

--

AccessD mailing list

AccessD at databaseadvisors.com

http://databaseadvisors.com/mailman/listinfo/accessd

Website: http://www.databaseadvisors.com

--

AccessD mailing list

AccessD at databaseadvisors.com

http://databaseadvisors.com/mailman/listinfo/accessd

Website: http://www.databaseadvisors.com

-- 

AccessD mailing list

AccessD at databaseadvisors.com

http://databaseadvisors.com/mailman/listinfo/accessd

Website: http://www.databaseadvisors.com

-- 

AccessD mailing list

AccessD at databaseadvisors.com

http://databaseadvisors.com/mailman/listinfo/accessd

Website: http://www.databaseadvisors.com