Scalable Drawings

[andysuth]

Hi,

I'm new to Access.

I've been using a MS Excel Macro to update Parameters (Length, Width, Depth, number of knobbles, etc), for drawings in a SolidEdge2D file.

I then kept a record of these in a case specific CSV file and a total CSV file, both of which could be read or printed out in format through MS Excel.

I've been told in no uncertain terms that I'm a "muppet", and should have used Access to drive a drawing file where the drawings could be rescaled and saved along with the parameters.

Can this be done? or is the person who told me that a cotton-headed ninny-muggins?

Can anyone help me with a simple example of say a rectangle where the Access Macro would alter the length and width of a rectangle?

Or is it easier to stick with the SE2d/MSExcel solution?

Thanks,

-AndyS

[Tommy]

"cotton-headed ninny-muggins" No not really.

This will depend on how many drawings and what a knobble is. I do not know Solid Edge, but I use Acad, keeping this in mind I would have to say..... whatever you are comfortable with is the best way. If the excel way is quick and easy, everyone understands it and it works, then there you are. If this is just a small part then you should use a database system of some type to reduce your headaches after the learning curve. This does not mean you are wrong it just means that the database way is more dynamic/fexible.

[andysuth]

I would be happy to keep using SE2D, except for the fact SE sent a message around telling us all we had to upgrade as the free license had run out: this was september.

After SE telling everyone "no more forced upgrades" I became a little nervous (what if they stop giving out these time-limited licenses?) hence wondering if I can do this direct in Access, rather than using my ropey little digital integration between Office and SE2d.

If you know how to, say, do a vector drawing and alter the lengths of elements, I'd be very interested in hearing that.

-Andy

[Tommy]

I normally produce fabrication drawings, but I use controls that write in a dxf format. Then I use a free viewer to display and print if needed. I have also drawn on a form, but I don't think that is practical for this. Can you define what you mean by vector drawing?

[andysuth]

By "Vector Drawing" I probably mean the same as "Drawn on a form",

Thinking about it though, I've not used Access since office 95, so I'm probably too rusty on it to write this.

Be interested to see if it could be doen though.

-Andy.