Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2004
    Posts
    1

    Unanswered: Cannot open any more databases

    I can see another thread on this subject - but I need more info if poss!

    I have a main form with about 16 tabs on and spread across these tabs are about 20 sub forms - I have lots of tables (as u would expect from a good design of database!!) and when the user needs to do other operations I hide the main form (its bound and so closing and reopening would cause performance issues !). The ap is split fe/be and I have a fair number of combo boxes spread around.

    I have now hit this limit and need to do something to reduce the number of tableids used (see other thread)

    How best should I do this - should I take any dlookups and write a generic function which uses sql on the specified table with the given criteria - would this generate a single tableid rather than having many for all the dlookups?

    Should I blank the record source for combo boxes when a tab is hidden from view - would this release tableids ?

    Any other ways of reducing the tableids and I want to keep my User Interface as is !!

    Thoughts appreciated

    Gary Hill

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Sorry run that by me again, 1 parent form with 16 tabs AND 20 sub forms.
    Sounds a nightmare

Posting Permissions

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