Macro - write info to Access table

Sep 02, 2004 4 Replies

formatting link



This macro grabs the configuration name, path, file name, and the ASI part number (in the User Specified name slot) of the current document and inputs those values into an Access table on the server. The ASI part number is copied to the clipboard to be used later. I also added the option to zoom to fit in the isometric view, save the file, close it, run Unfrag on its folder, and then the option to make the file Read-only.



As always, comments are welcome.



WT


Hi Wayne,

I've been playing with your macro, more to get a feel for writing to databases, than anything. Is it possible to get a blank copy of PNInv97.mdb to play with? I don't have a copy of Access at work and can't easily create it.

Could you e-mail it to me at snipped-for-privacy@spamgourmet.com? This is a temporary e-mail address as I never put real e-mail addresses in usenet messages any more.

Thanks a lot!

Chris

I sent it to your other address.

WT

Hey Wayne, You wouldn't by any chance be able to send me that file as well? If you could my e-mail is dvanzile3@n o r g r e n a u t o.com (Take out the spaces of course....)

Thanks once again!

Hey Wayne,

Could I also get a copy of this database file!

Thanks in advance

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required