If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access to Org Chart compatability
I created an organizational chart using the org chart
wizard to group people together. I built it off a access database. If I delete a square out of the Org chart, it reflects the changes in the database. I want to go the other way without having to make a whole new org chart. I was wondering if there was a way to change things in the database and to see the changes directly in the chart. I was wondering if there was a quick fix to it without any coding. I am using Visio 2002 sp2 and access 2002 sp3. Some help on this would be appreciated. |
#2
|
|||
|
|||
Access to Org Chart compatability
There is no functionality in Visio to update an existing Organization Chart
from the original data source if the reporting structure has been changed. Your only option is to re-run the wizard to create a new Org Chart. -- Mike Mueller Longhorn SDK This posting is provided "AS IS" with no warranties, and confers no rights. |
#3
|
|||
|
|||
Access to Org Chart compatability
I add new people by copying an existing shape on a page, then 'select database record', and replacing the name with the name to be added.
To identify the delta between names on your org chart, and names in your Access database, you could use the Report function in Visio. This lets you generate an Excel file, which you can then import into Access, and analyse with a simple query. A bit cumbersome - but a great deal easier than re-creating org charts from scratch every time, especially if you have a large org chart Rose "Mike Mueller [MSFT]" wrote: There is no functionality in Visio to update an existing Organization Chart from the original data source if the reporting structure has been changed. Your only option is to re-run the wizard to create a new Org Chart. -- Mike Mueller Longhorn SDK This posting is provided "AS IS" with no warranties, and confers no rights. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Access 2003 | RK | General Discussion | 12 | June 14th, 2004 10:16 AM |
Recommendations needed for installation order of Access XP, Access XP runtime, ... | Mark Plantenberg | Setup, Installing & Configuration | 0 | June 11th, 2004 11:22 PM |
Data Access Page Problem | Doug Munich | General Discussion | 0 | June 5th, 2004 12:03 AM |
Excel chart to Access report | Dave Stone | Charts and Charting | 0 | January 9th, 2004 04:16 PM |
Styles for chart | Debra Dalgleish | Charts and Charting | 1 | October 3rd, 2003 12:27 PM |