Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / October 2005

Tip: Looking for answers? Try searching our database.

dynamic adding of tabcontrols

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
chriske911 - 17 Oct 2005 14:19 GMT
I have a main account with several subrecords
now, since the subrecords are limited (9 max) and have many fields
I was thinking of dynamically building tabpages instead of using a
continuous subform
is this possible?

each tabpage would get it's title from one particular field of the
subrecord

thnx
Al Camp - 17 Oct 2005 14:54 GMT
Chris,
  If I understand correctly, I think you're trying to create a max of 9
tabs... each to hold one subform record.
  I would think this would be "somehow" be possible, but only after many
hours of effort and a lot of experienced coding, and in the end, be
extremely cumbersome and difficult to work with.
  Try creating just a normal continous subform with 9 records, and displays
just those very critical fields you need to see from the Main form.  Maybe 8
or 9 fields that you need to assist the user in identifying the diffrence
between the subform records.
  Create a "jump" function that... when you double click on a subform
record, a new, full sized form opens up to that particular record, and
displays ALL the ancillary fields that you need to edit or view.  Upon
working on that record, and upon closing of that "jump" form, you'll return
right back to your normal form.
   Practically all commercial software uses this same method.  If you want
to edit a deposit in your checkbook program, you jump out to the deposit
slip... do your work, and return to the checking account you came from.

Signature

hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

>I have a main account with several subrecords
> now, since the subrecords are limited (9 max) and have many fields
[quoted text clipped - 6 lines]
>
> thnx
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.