+ Reply to Thread
Results 1 to 4 of 4

Copying Multipage Pages and related code

  1. #1
    Registered User
    Join Date
    10-25-2007
    Location
    Melbourne, Australia
    Posts
    27

    Copying Multipage Pages and related code

    Hello all.

    I am trying to develop a production reporting form that is to be used by several others for gathering manufacturing data.
    I have created the input form on the first page of a Multipage control. It has just over 200 text boxes and comboboxes. Depending on the work area or the user, the number of pages will vary, so rather than create a form with over 30 pages, I found out how to copy the first page of the multipage and all the controls for just the number of pages required.
    My problem is that all the code related to the text and comboboxes does not come with the copied pages.
    Can someone please advise how to get the controls on the duplicated pages to behave the same way as on the original page, for example, summing the appropriate text boxes, or should I have taken a different approach?
    Thanks in advance.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Copying Multipage Pages and related code

    Hello Jagman,

    It is difficult to propose any strategy without seeing how the data is organized. It is safe to say there is probably a simpler way to do what you want. I don't know anyone who would have the patience to enter data on form with around 200 text boxes, combo boxes, etc. If you could provide a sample workbook, you're more likely to get ideas and input on how to proceed with this.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Copying Multipage Pages and related code

    Why would you need 30 identical pages?
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  4. #4
    Registered User
    Join Date
    10-25-2007
    Location
    Melbourne, Australia
    Posts
    27

    Re: Copying Multipage Pages and related code

    Thanks Leith & royUK for your interest.
    As a manufacturing plant, we have 36 production cells divided into 9 work areas, which are allocated to 5 supervisors. Every morning the supervisors fill out the previous day’s activity report for each shift on each cell. One form contains the three shifts.
    The reporting form is the same layout for each production cell though the specific content will be different e.g. part numbers made, scrap reasons and personnel.
    Currently, each supervisor uses a workbook that contains multiple worksheets, each setup for the specific production cell. When they have finished entering all the data they click a button to print out a summary and upload the data into another workbook. The problem with this method is when a change is made to a calculation all the worksheets need to be changed separately.
    My goal was to have a single workbook as a shared file or template which all of the supervisors used. Depending on the supervisor selected from a drop-down list, the Multipage form would be configured with the number of pages to match the production cells allocated to the supervisor. Each multipage page would contain the form for a specific production cell, replacing the separate worksheets in the current system. The comboboxes and some of the text boxes would then be populated automatically for each production cell. Not every box would require data entry. Provision is made to cover worst case in terms of data collected. A reasonable expectation is that out of the 205 combo and text boxes on the form, perhaps 30 to 40 would be used each day.
    With a single workbook being used, if any changes are required only one file is modified for global effect.
    I think the problem boils down to: If I can identify all my controls on the first page of a multipage and then copy that page, how do I identify the same controls on the copied pages?
    I have attached a stripped-out version of the workbook to show the basic form (because the multipage tabs and combobox lists are obtained from other workbooks the file wont run). The blue areas will be calculated or filled from other lists. I hope you get the idea.
    Thanks again.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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