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 / New Users / November 2005

Tip: Looking for answers? Try searching our database.

Data base Forms

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
SallyGirl - 10 Nov 2005 00:29 GMT
Can you add colums to a preset database form
Albert D.Kallal - 10 Nov 2005 04:26 GMT
> Can you add colums to a preset database form

Do you mean if you modify the table structure, and add a new field to the
table, can you have that "show" on the form? The answer is yes, and this
would course be a "developer" change..not something that your users would
ever do. However, if you add a new field (column) to the table, and your
form is based on a query, then when you bring up the form in design mode,
you will NOT see the additional fields unless you change the forms
underlying query.

So, sure, you can add new columns, but this is a "building stage" issue, and
not something that would occur during general operation of the application.
So, adding new columns is only a design issue, and we don't design software
that allows "users", or the application to add a new column. The reason for
this is then all of your reports, forms, and even code will often have to be
modified.

There are very complex accounting systems that let you assemble very complex
pricing and "assemblies" of parts etc, and these systems never require that
a new column be added to the design.

The term here is called "data modeling", and it allows you to build a
database that does not requite you to add new fields over time (or, it ones
needs to,..it should be a rare event once the application is in use).

It is also possbile that I have not understood your question...so, do feel
free to expand, or dig more more answers...

Signature

Albert D. Kallal   (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com
http://www.members.shaw.ca/AlbertKallal

John Vinson - 10 Nov 2005 04:48 GMT
>Can you add colums to a preset database form

You'll have to explain what a "preset" form is. The term means nothing
to me.

                 John W. Vinson[MVP]    
 
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.