Macro - write info to Access table

Discussion in 'SolidWorks' started by Wayne Tiffany, Sep 2, 2004.

  1. www.kcswug.com/programs/macros/AccessLogOfConfig.swp

    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
     
    Wayne Tiffany, Sep 2, 2004
    #1
  2. Wayne Tiffany

    Chris Dubea Guest

    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 ? This is a
    temporary e-mail address as I never put real e-mail addresses in
    usenet messages any more.

    Thanks a lot!

    Chris
     
    Chris Dubea, Sep 8, 2004
    #2
  3. I sent it to your other address.

    WT

     
    Wayne Tiffany, Sep 8, 2004
    #3
  4. Wayne Tiffany

    Pete Guest

    Hey Wayne,

    Could I also get a copy of this database file!

    Thanks in advance

    Peter Cram
    please remove NOSPAM from email address!
     
    Pete, Sep 9, 2004
    #4
Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.