Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations KootK on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mfleming

    ACAD-VBA Change DynamicBlockSize?

    Another stupid question I have is how to I run the Program in Autocad? When I load the project it shows the parts where it actually goes throught the drawings/blocks (not sure what this is called) but I cant see the FORM WINDOW unless I use the TEST function inside the VBA Editor. Basically...
  2. mfleming

    ACAD-VBA Change DynamicBlockSize?

    I tried Swamp but no reply. I have got it so I can change the visibily state. Just not sure what "values" I use to set the lookup. I keep getting Invalid input. dybprop(i).Value = "12" Under the watch window the type is Variant/String and for value it just says custom. I'm thinking it...
  3. mfleming

    ACAD-VBA Change DynamicBlockSize?

    So from my original question, how do I update/change these values?
  4. mfleming

    ACAD-VBA Change DynamicBlockSize?

    Error 13 Type Mismatch Debug.Print " Value---> " & lookuptbl(lCnt).Value
  5. mfleming

    ACAD-VBA Change DynamicBlockSize?

    TCARPENTER1 I get error 13 Type Mismatch in Debug.Print "lookuptbl(" & lCnt & "): Show --> " & lookuptbl(lCnt).Show & _ " Property Name --> " & lookuptbl(lCnt).PropertyName & _ " Value --> " & lookuptbl(lCnt).Value
  6. mfleming

    ACAD-VBA Change DynamicBlockSize?

    Nope chaninging lookuptbl = element.GetDynamicBlockProperties TO Set lookuptbl = element.GetDynamicBlockProperties gives me Run-Time error 13.. Type mismatch. It works ok if I leave OFF the Set. My New Code: Private Sub CommandButton4_Click() Dim element As Object Dim lookuptbl As...
  7. mfleming

    ACAD-VBA Change DynamicBlockSize?

    Yes and No. This will change the width and height using their parameters BUT I want to add them the LookUP Paramater (which basically has a big list of widths and lengths in specific combinations (ie. 24"w X 48"h, 24"w X 32"h, 22"w X 48"h) I'm wanting to use my excel list to be updated into...
  8. mfleming

    ACAD-VBA Change DynamicBlockSize?

    TCARPENTER1 I believe I already use the GetDyn.... code except when I try to put the () at the end I get an error. lookuptbl = elementBlock.GetDynamicBlockProperties lookuptbl GETS the info and it displays it as lookuptbl(0), lookuptbl(1) and so on. I tried changing the "show" value and I...
  9. mfleming

    ACAD-VBA Change DynamicBlockSize?

    Hello. I'm working on an app that will take width & height values from an excel file and add them to the LOOKUP of my rectangle shape Dynamic Block. In the end I want to be able to update my Dynamic Blocks in the drawing with the NEW LOOKUP values to Stretch the Width & Height. My Dynamic...
  10. mfleming

    Door Flip Dynamic Block Trouble.

    I have almost fixed this. There is only one Flip that doesn't seem to be working. The Flip Door Swing. It works when I just flip the door swing but if I try and stretch the door opening after it is flipped it gets all messed up. Can anyone help me out I have no idea how to fix this?
  11. mfleming

    Excel Add Qty for Unique Parts?

    Thanks I'll look into Pivot Tables. I tried the sumif function but I couldn't get a good way to cycle through all the data when its not in just two columns.
  12. mfleming

    Excel Add Qty for Unique Parts?

    Hello. I'm combine unique names and add the quantities. I use data extraction in AutoCAD to excel and I get all my Parts and qtys. Column-A = Parts Name Column-B = Qty for Parts in Column A Column-C = Parts Name Column-D = Qty for Parts in Column C Column-E = Parts Name Column-F = Qty for...
  13. mfleming

    Commercial Internal Drainage Detail at Roof?

    Hello. I'm looking for a internal drain detail for comercial buildings. Mainly how th drain ties into the roof system ect. If anyone has this in pdf or CAD(dwg) or whatever please contact me. Thank you, Matt
  14. mfleming

    Angle Design for Fixed End?

    I'm switching to a small HSS tube. So much easier. Thank you, Matt
  15. mfleming

    Angle Design for Fixed End?

    I have the proper codes for my area. "Handbook of Steel Construction" Seventh Edition from the Canadian Institute of Steel Construction. Thats not the problem. This is an easy question... well I thought it should be. I mainly to beam & column design and haven't done angle design for some time...
  16. mfleming

    Angle Design for Fixed End?

    Either one should be fine. Pick the one that is easier to understand. Thanks
  17. mfleming

    Angle Design for Fixed End?

    I don't have either of those. All I have is "Handbook of Steel Construction" Seventh Edition (Canadian)
  18. mfleming

    Angle Design for Fixed End?

    I'm looking to design a steel angle that can support 50lbs uniformly distributed. It will be fixed at one end and the length would be 1'-6". ] ] | 50lbs ]============= ] ] 1'-6" -/------------/- This should be pretty easy but I can't remember how to calculate steel...
  19. mfleming

    Mezzanine Joist Space Directions?

    Thanks for everyones input. If we do end up doing this design I will mention using a downturned angle to transfer the lateral loads. As we use a built-up roof system design and we don't need any leaking problems. Matt
  20. mfleming

    Mezzanine Joist Space Directions?

    Hello. I'm just working on a complex project right now with a weird shape for the building. I was wanting to span one section of jsts one way and another span perp to them. My concern is we are using 1-1/2" steel jst deck, and I don't know exactly what happens to connect the different...

Part and Inventory Search