Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

printing get error 3014 why and how to solve it

Discussion in 'Information Technology' started by rberry, Jul 28, 2006.

  1. rberry

    rberry
    Expand Collapse
    Guest

    I have a form with 4 page tabs on it, each with a print command button that
    prints of the individual page tabs. I have one page in particular with 40
    combo fileds on it each which is linked to the same table.

    I keep getting the error message 3014 saying I have too many tables open.

    Help!
     
  2. Loading...


  3. Rick B

    Rick B
    Expand Collapse
    Guest

    Not sure about the error, but you should be printing a report, not a form.

    The proper way to do this is to create a report that includes the data you
    want and tie that report to the button. In your example, you would need to
    build 4 reports.

    Reports include the controls you need to print. Forms are designed for
    entering, viewing, and changing data. When you build a report, you can get
    rid of all those combo fields (which look horrible when printed) and use
    text boxes and other printer-friendly controls.


    --
    Rick B



    "rberry" <rberry@discussions.microsoft.com> wrote in message
    news:9F4ECE3C-F3DF-46C1-9CAF-D382722428DE@microsoft.com...
    >I have a form with 4 page tabs on it, each with a print command button that
    > prints of the individual page tabs. I have one page in particular with 40
    > combo fileds on it each which is linked to the same table.
    >
    > I keep getting the error message 3014 saying I have too many tables open.
    >
    > Help!
     
  4. rberry

    rberry
    Expand Collapse
    Guest

    Rick B apologies if I make any protocol gaffs first time I've used this
    medium to problem solve.

    Rick the report runs OK in the database window. Great minds must think
    alike, I have actually got the system set up as you have suggested.

    The problem is that on two of the tabs with command buttons attached, NO
    problems, HOWEVER on the other two tabs when you try to print off the
    reports, you get an error message 3104 - basically it says that too many
    tables are open and the system goes belly up on the print process.

    I suspect that opening these reports in conjunction with this particular
    application is tipping it over the edge. As I say the two tab pages
    concerned have in excess of 40 combo fields attached to a particular linked
    table on each tab page. Only solution I can think of is converting the combo
    fileds into a list fields and hardwiring in the values, however in doing so I
    will lose flexiibility if I want to add additional options within these
    respective fields.

    Any ideas.

    "Rick B" wrote:

    > Not sure about the error, but you should be printing a report, not a form.
    >
    > The proper way to do this is to create a report that includes the data you
    > want and tie that report to the button. In your example, you would need to
    > build 4 reports.
    >
    > Reports include the controls you need to print. Forms are designed for
    > entering, viewing, and changing data. When you build a report, you can get
    > rid of all those combo fields (which look horrible when printed) and use
    > text boxes and other printer-friendly controls.
    >
    >
    > --
    > Rick B
    >
    >
    >
    > "rberry" <rberry@discussions.microsoft.com> wrote in message
    > news:9F4ECE3C-F3DF-46C1-9CAF-D382722428DE@microsoft.com...
    > >I have a form with 4 page tabs on it, each with a print command button that
    > > prints of the individual page tabs. I have one page in particular with 40
    > > combo fileds on it each which is linked to the same table.
    > >
    > > I keep getting the error message 3014 saying I have too many tables open.
    > >
    > > Help!

    >
    >
    >
     

Share This Page