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, visio code, database based drawing, visio generate code, generate drawing code, visio drawing code, visio auto generate, generate visio automatically, excel database visual basic, access delete, background drawing, excel macro add, code basic, generate code database record, data entry visual basic, visual basic delete access, visual basic entry form, 504, visio basic shapes, auto add, excel shape, drawing excel, equipment access database, add layer, excel form access

About the Employer:
( 9 reviews ) 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