Help!! on converting Access Graphs/Charts

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Zohra (anonymous_at_discussions.microsoft.com)
Date: 07/22/04 

Date: Thu, 22 Jul 2004 05:05:25 -0700

Hi there=)

Basically im working on a database system designed to
capture data via the form. Its got many tables related as
well as Queries, Reports and reports in the form of Graphs.

At the end of every month a report must be
produced/printed in Word format for management to review.

Can someone please tell me how to get a chart(actually
several) in Acess format which are based/linked to several
tables/queries into a word Format(if possible) else into
Excel format.

The problem is that the graphs in the new Word/Excel
format should be dynamic..ie: whatever changes take place
in the database system/records should automatically
reflect on the converted graphs in Word/Excel.

I have tried it using Excel by menu..Data-Get External
Data-New Database Qquery and bla bla wizard. The problem
though is that when it comes to the end (Finish- which is
suppose to return it to Excel) it asks for parameters..i
go back to Acess but from that poin im stuck!

Now these parameters are in Access. they are actually dates
(start and End dates) The graphs that are produced are for
the specified time periods.

Other options like analyze with Excel,publish with word
are of no use.

Your help will be greatly appreciated.

Thanks,
Cheers Zohra (South Africa)

Relevant Pages

  • Help!!Exporting Graphs In Access
    ... Basically im working on a database system designed to ... Reports and reports in the form of Graphs. ... produced/printed in Word format for management to review. ... The problem is that the graphs in the new Word/Excel ...
    (microsoft.public.access.reports)
  • Re: Convert MDB to ADP
    ... I will try to explain what I'm using in access mdb about filter queries ... I have a form where I generate reports, queries, forms and by automation I ... Is it possibel to find any function in SQL server to replace Format, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: How do I create a macro to boldface text in Access?
    ... For example, you could select all of the controls on the report which you want to format as Bold, and then one click on the Bold button and they're done. ... If you can't see a Macro Name column in the macro design window, select it from the View menu. ... Now, when in design view of your report, the keyboard shortcut Ctrl+B will format the currently selected control as Bold. ... In the database, there are tables, queries, forms, reports, etc. ...
    (microsoft.public.access.macros)
  • Re: Month only field problem
    ... reports are fiscal year, some calendar. ... names alphabetically so assigning a number value should keep it in the proper ... calendar order. ... >>field size is long interger and Format is mmmm. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: T4 and friends
    ... > can be trigered from a batch job on the VMS side so that the ... > performance reports that would be more valuable automated. ... > with the VMS community at-large. ... graphs would end up in a shredder or landfill or possibly recycled. ...
    (comp.os.vms)