See the top rated post in this thread. Click here

Results 1 to 10 of 10

Thread: Drawing Register

  1. #1
    Active Member
    Join Date
    2008-01
    Posts
    96
    Login to Give a bone
    0

    Smile Drawing Register

    Hi,
    Is there anyone out there that uses Excel or MS Access to record drawing information or for a drawing register?
    I would Ideally like some piece of software that a user can use to fill in a fom and the information is stored in a database.
    We currently use an Excel spreadsheet, but as a project progresses it becomes massive and difficult to handle.

    Any advice welcome.

    Mike.

  2. #2
    Mod / Salary / SM Wanderer's Avatar
    Join Date
    2001-12
    Location
    St. Louis
    Posts
    5,381
    Login to Give a bone
    0

    Default Re: Drawing Register

    Quote Originally Posted by MikeRobinson View Post
    Hi,
    Is there anyone out there that uses Excel or MS Access to record drawing information or for a drawing register?
    I would Ideally like some piece of software that a user can use to fill in a fom and the information is stored in a database.
    We currently use an Excel spreadsheet, but as a project progresses it becomes massive and difficult to handle.

    Any advice welcome.

    Mike.
    Mike, I'm not sure our application of the data is the same, but, I created an access database years ago to record information about our prints and the forms for input are easy enough to create (well, they were a huge pain 10 years ago when I did this, but, I'm sure they're much easier now).

    I've attached screencaps of:
    038: the main 'switchboard' where I had provided access to a couple of different tables of data, but, only displaying one now because I don't want to confuse anyone else
    039: data input form
    040: printout that results from a multi-prompt query triggered by the 'create report' button on the form
    Attached Images Attached Images
    Melanie Stone
    @MistresDorkness

    ARCHIBUS, FMS/FMInteract and AutoCAD Expert (I use BricsCAD, Revit, & Tririga, too)
    Technical Editor
    not all those who wander are lost

  3. #3
    Administrator Ed Jobe's Avatar
    Join Date
    2000-11
    Location
    Turlock, CA
    Posts
    5,962
    Login to Give a bone
    0

    Default Re: Drawing Register

    You might also want to search the Cad Mgr forum for the subject "document management system". A DMS automates some of that work.
    C:> ED WORKING....

  4. #4
    Active Member
    Join Date
    2008-01
    Posts
    96
    Login to Give a bone
    0

    Default Re: Drawing Register

    Wanderer,
    That database you have created looks like the one I would like - albeit more complicated than I need.

    Mike.

  5. #5
    Mod / Salary / SM Wanderer's Avatar
    Join Date
    2001-12
    Location
    St. Louis
    Posts
    5,381
    Login to Give a bone
    0

    Default Re: Drawing Register

    Quote Originally Posted by MikeRobinson View Post
    Wanderer,
    That database you have created looks like the one I would like - albeit more complicated than I need.

    Mike.
    Mike, ~laughs~ It was a bit of a nightmare and way too complicated on the back end, I assure you. The first code I ever wrote was trying to get that thing to work the way I wanted it to, which wasn't as easy on those older versions of access.

    I do think that Ed had a good suggestion to look into a real DMS because they might be more efficient to set up and use.
    But, if, like me, you are given next-to-no budget for most of your tasks, getting up a simple access repository with a not-scary form for user input should be somewhat straightforward.
    Melanie Stone
    @MistresDorkness

    ARCHIBUS, FMS/FMInteract and AutoCAD Expert (I use BricsCAD, Revit, & Tririga, too)
    Technical Editor
    not all those who wander are lost

  6. #6
    Active Member
    Join Date
    2008-01
    Posts
    96
    Login to Give a bone
    0

    Default Re: Drawing Register

    You are right - I have no budget!
    I was looking to try and program something myself and incorporate our existing drawings or even start from fresh.

    I have used Vault in the past, but that is a pain if you decide you don't like it. It lumps all the drawings together in one large database.

    I don't want to manage the drawing files - Just simply create a form for user to fill in simple information like job number, drawing number, description, revision etc
    From that information, be able to send a report to print.

    Sounds simple, but I know it aint going to be!

  7. #7
    Administrator Ed Jobe's Avatar
    Join Date
    2000-11
    Location
    Turlock, CA
    Posts
    5,962
    Login to Give a bone
    0

    Default Re: Drawing Register

    If you are familiar with Access it is. Do you have anyone there that is? Reminds me of a transmittal db I once created.
    C:> ED WORKING....

  8. #8
    Active Member
    Join Date
    2008-01
    Posts
    96
    Login to Give a bone
    0

    Default Re: Drawing Register

    Quote Originally Posted by Ed Jobe View Post
    If you are familiar with Access it is. Do you have anyone there that is? Reminds me of a transmittal db I once created.
    We have nobody that is familiar with Access. I have time on my hands to learn the about the software.
    Is Access easy to learn? Should I go on a course?
    I do have some course notes that I have access to - Maybe I should start there.

  9. #9
    Administrator Ed Jobe's Avatar
    Join Date
    2000-11
    Location
    Turlock, CA
    Posts
    5,962
    Login to Give a bone
    0

    Default Re: Drawing Register

    Try this link at office.com. You might even be able to find a project template there.
    C:> ED WORKING....

  10. #10
    Active Member
    Join Date
    2008-01
    Posts
    96
    Login to Give a bone
    1

    Default Re: Drawing Register

    Currently looking at this website - http://www.rogersaccesslibrary.com/forum/topic238.html

    Looking to build my own Access Database.

    The tutorials on this site are making sense and a better understanding.

Similar Threads

  1. 2015: Drawing register/issue slip
    By Mark Vorstenbosch in forum Revit Architecture - General
    Replies: 2
    Last Post: 2020-04-24, 12:56 PM
  2. Automated Drawing Register/Issue Sheet in Revit?
    By barrie.sharp in forum Revit Architecture - General
    Replies: 20
    Last Post: 2017-09-07, 01:45 AM
  3. Guide or Standard Drawing Register, for reference, review
    By tolifiers in forum CAD Standards
    Replies: 2
    Last Post: 2009-05-19, 11:16 AM
  4. Excel Drawing Register
    By donalcommane in forum Software
    Replies: 0
    Last Post: 2009-05-13, 09:18 AM
  5. Drawing Register / Issue Sheet in Excel
    By de-co1 in forum Software
    Replies: 9
    Last Post: 2006-12-06, 09:25 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •