Welcome to SPN

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

Sign Up Now!
  1. Guest ji, please consider donating today!
      Become a Supporter    ::   Make a Contribution   
    Monthly Recurring Target: $300 :: Achieved: $95

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!

    >
    >
    >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page