+ Reply to Thread
Results 1 to 4 of 4

Cacading Forms - Positioning

  1. #1
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Cacading Forms - Positioning

    I am working on a project to produce labels and work instructions for a manufacturing process. This part of the project generates a bill of materials. It is a two-step process. Clicking the add button brings up a form that shows the available materials and has a series of cascading drop downs. Select a material then click on the thickness list box and it will show you the thickness that this material comes in and so on.

    Use Material 2. Some of the other materials have data issues that cause the program to error out.

    Once you selected each of the boxes, click on the commit button and a second form comes up with this information (plus others) filled in. Then the user can fill in the rest of the information or even override the existing information.

    All of this is irrelevant but it does tell you how to navigate the system to demonstrate the issue.

    I want to show the second form slightly offset from the first form. The first form has .top = 100 and .left = 100. The second form has .top = 120 and .left = 120. The second form comes up left aligned with the first form, and apparently in the middle of the screen. The .top and .left seem to be ignored. Is this a "feature" or is there a way to work around this?
    Attached Images Attached Images
    Attached Files Attached Files
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  2. #2
    Forum Expert
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    O365 32bit (Windows)
    Posts
    1,980

    Re: Cacading Forms - Positioning

    You need to change the StartUpPosition property to Manual.

    Then, when you load it specify the relative left and top

    Please Login or Register  to view this content.

  3. #3
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: Cacading Forms - Positioning

    I like the idea of setting things up before launching the form instead of when initializing it after lauch. I tried this
    Please Login or Register  to view this content.
    Without any change in the result.

  4. #4
    Forum Expert
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    O365 32bit (Windows)
    Posts
    1,980

    Re: Cacading Forms - Positioning

    Did you change UF_Confirm's StartUpPosition to manual in Design Mode?

    The "Me" part refers to the other form. I was looking at the commit button of UF_Make_List.

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Generate forms from Data table, print forms to PDF
    By Frick in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-07-2023, 11:23 AM
  2. Excel Forms - Forms File Keeps loosing synchronization?
    By learning new things in forum Excel General
    Replies: 0
    Last Post: 10-01-2020, 07:22 PM
  3. Replies: 0
    Last Post: 07-16-2015, 07:51 AM
  4. Print on ready blank forms (document forms)
    By gandrinno in forum Excel General
    Replies: 1
    Last Post: 02-16-2009, 06:12 PM
  5. [SOLVED] Excel forms - authorise / deny forms
    By Ian Manning in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-08-2006, 12:10 PM
  6. Positioning
    By Roger in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-08-2005, 04:05 PM
  7. [SOLVED] Positioning 2 User Forms
    By mully in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 06-11-2005, 04:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1