How do I create a new blank form based on an excisting form?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a new database for 2005 using the exact layout for a
form used in 2004. When i do this using the wizard or by creating a replica
it is bringing up all the pages in the 2004 dtatbase. I want a blank database
so I can stat a fresh for the year but it just keeps creating a copy, if I
try deleting pages from the new database it deltes them form the 2004 copy as
well so some where it has created a link.
How do I create a new data base for this year using last years layout
without it dragging through data?
 
You could copy the file through Windows Explorer, rename and then make any
2005 changes.

Otherwise, you could start with a blank database and import in only the
objects you want to keep.

It seems it is always best in the long run to create your database in such a
way that you don't have to make changes when the year changes. Just
something to think about.
 
Angelica,

If you create a new database for 2005 you can them import the tables,
forms, queries from the 2004 database. When you import the tables select
options, definitions only.

That should copy just the table structure and not the data.

Hope that help,
~John
 
Hi Angelica,

As other responders have alluded, if it's necessary to go through ANY effort
on your database application just because the year has changed then your
design is incorrect. It implies that some of the objects in your
application are named for the YEAR.

You'll be miles ahead to think through what it is you're trying to do
(provide a solution or cluster of solutions to a problem or group of related
problems) before you dig into the design. If the year is significant in
what you're doing then there should be a date field in one of your tables.
You should NOT have a table named "Date" or "2005".

If you have more questions, please post back but tell us your version of
Access, what you're trying to do with the application and where it is that
you're stuck. It's quite often useful to include your table names and to
list the significant fields in each table.

As in all of the Access newsgroups, a post will almost always get one or
more responses. Given that this is an omnibus newsgroup you might have to
plow through a lot of stuff to check your thread. There are several
specialized Access newsgroups which start with the name of this newsgroup
but then add a period and name the specialty such as 'gettingstarted' and
tablesdesign' and 'forms'.

HTH
-
-Larry-
 
Back
Top