Susan Harkins
ssharkins at bellsouth.net
Fri Jul 23 14:50:03 CDT 2004
Why not divide the data into the same structure as the tab and use 1:1 relationships? Susan H. This sounds good too. The form is 8" W X 5" tall. It uses a tabbed control with 11 tabs. This is a Six Sigma Project management module, within a Workflow System. I've done many processes like this, and people love it (a direct quote!). If you compare this approach to managing a business process to using paper forms, emails, memory, phone calls, walking down the hall, 'smoke signals', etc., it’s a great productivity tool. Some processes, like Debit Memos, or Supplier Deviations, are simple. Some, like Supplier First Article, Nonconforming Material, or Six Sigma Projects, are complex. And the more complex, the more value a database has. I've made the screens very easy to use. Labels are colored to indicate required, optional, locked, or system entered. During the current event the focus is moved to the page and the field where the work on that process probably needs to be done next. Access is great for this kind of stuff where a main goal is to make the user's life much easier. Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Michael Brösdorf Sent: Friday, July 23, 2004 1:59 PM To: Access Developers discussion and problem solving Subject: AW: [AccessD] Need more than 255 fields! (was - Hit the Wall?) How about 2 tables with a 1:1 relationship? To display that as a form you could use an main form/sub form approach or two subforms on an (unbound) main form. But 270 field - who is gonna read/understand this?? Does that even fit on a standard-size-display? Michael -----Ursprüngliche Nachricht----- Von: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]Im Auftrag von DWUTKA at marlow.com Gesendet: Freitag, 23. Juli 2004 20:39 An: accessd at databaseadvisors.com Betreff: RE: [AccessD] Need more than 255 fields! (was - Hit the Wall?) Go with an unbound form. There is no limit to how many properties a Class can have, so build a class to represent a 'record', and fill it with multiple recordsets. Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Dan Waters Sent: Friday, July 23, 2004 1:23 PM To: Database Advisors Subject: FW: [AccessD] Need more than 255 fields! (was - Hit the Wall?) Any other ideas on ways to resolve this issue? Thanks! Dan Waters -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Thursday, July 22, 2004 8:45 PM To: Database Advisors Subject: [AccessD] Hit the Wall? In an Access app w/FE and BE, I need a table that has about 270 fields. A single form will be bound to the table. (This is a business process management application.) If I upsize this to a project (never done this), I can have up to 1024 fields in a table. I tried creating a query to join two smaller tables, but queries are also limited to 255 columns. Is there a way around this so I can still use an Access BE? Thanks! Dan Waters -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com