PC Review


Reply
Thread Tools Rate Thread

Can I copy queries, reports, etc. to a new project?

 
 
=?Utf-8?B?QnJ5YW4=?=
Guest
Posts: n/a
 
      12th Feb 2006
I have a link with a GIS database, which contains all of my data in one
table. I have many customers that are combined into that one table. I would
like to create some queries that use the whole database, but I would also
like to have individual reports for each client.

Once I have a list of queries and reports I would like for each client,
could is there a way to copy them into a new project so I do not have to
rewrite each query?

Thanks!
 
Reply With Quote
 
 
 
 
Graham Mandeno
Guest
Posts: n/a
 
      12th Feb 2006
Hi Bryan

Sure! just File > Get external data > Import.

Of course, you don't want to import tables, otherwise the different
front-ends will no longer be sharing the data.

You should link the tables instead: File > Get external data > Link tables.
--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

"Bryan" <(E-Mail Removed)> wrote in message
news:9AEA273A-1289-46D5-BD45-(E-Mail Removed)...
>I have a link with a GIS database, which contains all of my data in one
> table. I have many customers that are combined into that one table. I
> would
> like to create some queries that use the whole database, but I would also
> like to have individual reports for each client.
>
> Once I have a list of queries and reports I would like for each client,
> could is there a way to copy them into a new project so I do not have to
> rewrite each query?
>
> Thanks!



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
copy queries and reports northstar Microsoft Access Getting Started 3 17th Apr 2009 05:51 PM
Moving project from VS2003 - VS2005 Crystal reports and setup project Claire Microsoft C# .NET 4 30th Aug 2007 07:36 PM
With VBA from Excel: Open Project, extract resource list and copy it to a worksheet, close project. Tony Microsoft Excel Programming 1 18th Oct 2005 03:53 PM
reference from console project to web project dll creates a copy of the DLL. z. f. Microsoft Dot NET Framework 2 14th Jun 2004 08:09 AM
Copy access objects (reports, queries, etc) from one Access db to another using VB.net kenbeard Microsoft Dot NET Framework 7 16th Feb 2004 04:10 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:37 PM.