Macro - write info to Access table

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

Reply to
Wayne Tiffany
Loading thread data ...

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

Reply to
Chris Dubea

I sent it to your other address.

WT

Reply to
Wayne Tiffany

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!

Reply to
dvanzile

Hey Wayne,

Could I also get a copy of this database file!

Thanks in advance

Reply to
Pete

PolyTech Forum website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.