How to update linked box in Visio when the source disappears

I have a Visio diagram where some boxes are linked to access database queries. These queries count certain values by category, for example:


High: 2

Medium: 3

Low: 1

and so on, however, if any of the categories does not have value anymore, the query does not return it but that does not reflect in Visio. I would like to still see the category in visio but the value would be Zero, is that possible?

August 30th, 2015 11:56am

Hi,

Based on my test, if the category field disappears from Access query, the category field of Visio also disappears after update/refresh the data. Visio is just linked the data and can't control/modify the category field, thus I recommend we modify the query of Access. Please use zero instead of null as default value in the Access query, then Visio will see the category and the value would be zero.

For example:

If the High does not have value anymore, please do not use "High: null", and use "High: 0".

In additional, if you have question on Access query, you also can post the question to Access DEV forum:

https://social.msdn.microsoft.com/Forums/office/en-US/home?forum=accessdev

If I misunderstood something, please feel free let know.

Regards,

George Zhao
TechNet Community Support

Free Windows Admin Tool Kit Click here and download it now
August 30th, 2015 10:07pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics