Database macros
Database macros
(OP)
I'm looking for an example of how to get a field value from an Access database and insert it into a model parameter.
I have written this for an Excel sheet before and know how call that information,
i.e. Part.Parameter("ThreadStart@ThreadPlane@Shaft.SLDPRT").SystemValue = [O15].Value / 1000
Now I would like to try do it from Access because I am finding that I have a larger amount of info that I would like to organize in a database and use that database to control my models.
Any suggestions?
I have written this for an Excel sheet before and know how call that information,
i.e. Part.Parameter("ThreadStart@ThreadPlane@Shaft.SLDPRT").SystemValue = [O15].Value / 1000
Now I would like to try do it from Access because I am finding that I have a larger amount of info that I would like to organize in a database and use that database to control my models.
Any suggestions?
Regards,
Christopher Zona
Litens Automotive Partnership
Concord, Ontario, Canada






RE: Database macros
It may not be possible from a macro, due to licensing issues. However, other VB objects with such capabilities may be available. You may be able to use the Microsoft Access API library.
Another option may be to write your macro from within Access, and have the Access macro manipulate SolidWorks.
http://www.EsoxRepublic.com
RE: Database macros
Now you can use a "regular" Excel macro to link the intended field (cell) to SW.
Regards
RE: Database macros
Part.Parameter("").VALUE
instead of
Part.Parameter("").SystemValue
"Value" will return units in your current doc props, except for angular units.