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 / Database Design / February 2008

Tip: Looking for answers? Try searching our database.

Using the same format for all Forms within 1 database

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
dplove - 21 Feb 2008 17:29 GMT
I have created a Form from a table.  The form is formatted the way I would
like.  I have several other tables that I would like to change to Forms but I
would like to use the same format from the 1st Form without having to
manually format it.  Is there a way to use this format for all of the Forms I
create?
KARL DEWEY - 21 Feb 2008 17:49 GMT
Open the form in design view, click on menu FILE - Save As and save as your
new form name.  Then edit the Record Source to the other query.
Signature

KARL DEWEY
Build a little - Test a little

> I have created a Form from a table.  The form is formatted the way I would
> like.  I have several other tables that I would like to change to Forms but I
> would like to use the same format from the 1st Form without having to
> manually format it.  Is there a way to use this format for all of the Forms I
> create?
dplove - 21 Feb 2008 18:31 GMT
Thank you, thats what I was looking for

> Open the form in design view, click on menu FILE - Save As and save as your
> new form name.  Then edit the Record Source to the other query.
[quoted text clipped - 4 lines]
> > manually format it.  Is there a way to use this format for all of the Forms I
> > create?
tedmi - 22 Feb 2008 15:27 GMT
That creates a potential maintenance nightmare, if you want the forms to be
identical forever, because you would have to apply any changes to multiple
forms (one of the few certainties of app design is that the design will
change!)
A better approach is to use a single form, just change the data source at
each use. You could create a menu form that lists all of the data sources,
clicking on one of them would open your data form and set its data source
property in the Open event. That way, you would have only two forms to
maintain: one data form, plus the menu form if the number of data sources
changes.
Signature

TedMi

> Thank you, thats what I was looking for
>
[quoted text clipped - 6 lines]
> > > manually format it.  Is there a way to use this format for all of the Forms I
> > > create?
KARL DEWEY - 22 Feb 2008 16:15 GMT
If the data source has differering field names then the queries would need to
have generic alises like Field1, Field2, etc.
Signature

KARL DEWEY
Build a little - Test a little

> That creates a potential maintenance nightmare, if you want the forms to be
> identical forever, because you would have to apply any changes to multiple
[quoted text clipped - 17 lines]
> > > > manually format it.  Is there a way to use this format for all of the Forms I
> > > > create?
Klatuu - 22 Feb 2008 18:45 GMT
Not a good idea.
Karl's suggestion is a good one.  It is not that every form will be the same
forever, but this is only for getting the app up and running quickly.  I do
the same thing myself.
Signature

Dave Hargis, Microsoft Access MVP

> That creates a potential maintenance nightmare, if you want the forms to be
> identical forever, because you would have to apply any changes to multiple
[quoted text clipped - 17 lines]
> > > > manually format it.  Is there a way to use this format for all of the Forms I
> > > > create?
 
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.