How do you save queries and forms but start over w/ all new

Interesting places

news.only-4-geeks.com Forum Index » Access


	How do you save queries and forms but start over w/ all new

Jump to:

Posted: Wed Sep 03, 2008 1:50 pm Post subject: How do you save queries and forms but start over w/ all new

I am very new to Access I have a database that has 2007 data in it. I want
to keep all of the forms and queries but enter 2008 data. How do I go about
creating a new database but keep all of those forms and queries?

Linq Adams via AccessMons

Posted: Wed Sep 03, 2008 2:08 pm Post subject: Re: How do you save queries and forms but start over w/ all

Create a new database. Then goto File - Get External Data - Import

Import all objects from your old database. When you go tot he Tables tab,
after selecting All Tables, click on "Options." Under "Import Tables" select
"Definitions Only."

Having said this, I have to tell you that this is ***not*** the normal way to
handle this! Situations and requirements vary, of course, but the normal to
handle this would be to a single database with date fields on your records
and handle things accordingly. That way you wouldn't have to switch back and
forth between DBs to find data from other years.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
LINK

Jerry Whittle

Posted: Wed Sep 03, 2008 2:42 pm Post subject: RE: How do you save queries and forms but start over w/ all

You don't. Creating a new database for each year or month is almost always a
mistake.

Instead have a date field in the table for the records which would define
what year's data is what. Then filter on that date field to return the 2008
data or what ever year(s) you want to see.

A good way to do this would be with the Year function on that date field.
Something like below in the field of a query will show the year:

TheYear: Year([TheDateField])

Then you could put 2009 in the criteria to return only 2009's records.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

"MO" wrote:

Quote:

Page 1 of 1 .:.



Awesome Website Templates ©

ubezpieczenie ac producent spodni pozycjonowanie oprocentowanie lokat parker

How do you save queries and forms but start over w/ all new

Awesome Website Templates ©