Suljettu

Visio code to auto generate drawing based on access DB

Visual basic Visio Macro that reads data form an access database, and places a standard set of icons on a page in Visio - based on the items and quantities in the access database.

The database holds information about what networking equipment belongs to what rooms.

Each different record in the access database (representing rooms) - Needs to be placed on a different tab and add the defaulted background tab as the background layer.

The macro should be run every time Visio is opened and remove/add shapes the no longer exist/were added in the database. The shapes need to include their 'friendy' name that is represented in the database.

//If there is a 'switch' included in the database, then the other networking items in that room should be automatically mapped to the switch ports. Possible?

//Can this be two way. So If I delete a shape, it will remove the record in the database?

//Can re-use code.

Taidot: tiedonsyöttö, Excel, Microsoft Access, Visual Basic for Apps

Näytä lisää: visio access database, auto generate shapes visio based data, visio code, database based drawing, visio generate code, generate drawing code, visio drawing code, data entry form in access, access database data entry form, visual basic generate visio access, visio auto generate, generate visio automatically, what is macro in excel, excel database visual basic, access delete, background drawing, excel macro add, visual basic database excel database, code basic, generate code database record, data entry visual basic, visual basic delete access, basic data entry page excel, visual basic entry form, 504

Tietoa työnantajasta:
( 9 arvostelua ) Robina, Australia

Projektin tunnus: #1742023

4 freelanceria on tarjonnut keskimäärin 229 $ tähän työhön

expertatwork

We are team of experts having vast knowledge on VISIO VBA. Please have a look at our message in your PMB.

240 $ USD 15 päivässä
(16 arvostelua)
3.6
amfuries

################### ******************* WE HAVE DONE THE SAME APPLICATION PLEASE CHECK THE PM **************** #############

220 $ USD 10 päivässä
(2 arvostelua)
3.2
shelmers

I have written hundreds of Visio VBA macros, many of which incorporate data from Excel, Project and Access. I have also used Visio diagrams to automatically generate Excel workbooks and PowerPoint presentations. An Lisää

250 $ USD 8 päivässä
(0 arvostelua)
0.0
hq007

Hello There, I have designed such type of project in a Road work where data was entered in Excel and my VBA Program Reads Data and Draws Cross Sections of Roads in AutoCAD. Within about 3 Minutes 40 Drawings were creat Lisää

225 $ USD 7 päivässä
(0 arvostelua)
0.0
tentus

i can do it

200 $ USD 10 päivässä
(0 arvostelua)
0.0