Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations MintJulep 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. FacilitiesCAD

    Ceiling Incandescent

    X XX XXX XXX XXX XXX XXX...
  2. FacilitiesCAD

    EXCEL Hide rows or columns

    Onlyadrafter, your code is easy to follow and helpfull but could you explain what "IV5" and x1toleft refer to in the context of the code? For MY_COLUMNS = 1 To Range("IV5").End(xlToLeft).Column Tim
  3. FacilitiesCAD

    Inserting images in LT

    I'm not sure because I use an older version of light. When I can do something by selecting buttons but don't know the command, I do it one then hit f2 to see what commands were used. I then use the same command with a - or _ in front of it to force it to be all text entered. Then I can...
  4. FacilitiesCAD

    Counting text

    Thanks both of you. counta was the solution I was looking for but it is always nice to know more than one way to skin a cat. Tim
  5. FacilitiesCAD

    Counting text

    Looks like it would do something. I understand the LEN()>0 part but what is the -- for? As promised a star Tim
  6. FacilitiesCAD

    Counting text

    A friend stopped by with a question earlier and I found him a quick answer but I'm wondering if there is a better answer. He had a list of text in some excel cells and he wanted to know how many entries were in the list. ex: A B 1 Name1 5 2 Name2 17 3 4 Name3 0 5...
  7. FacilitiesCAD

    AutoCAD to MS Access and Back

    about the template file First_tag_here c 040 000 Second_tag_here c 040 000 the c stands for text or string or someting like that the 040 sets the limit of upto 40 characters and it can be changed. The 000 refers to decimal places when importing a number. Tim
  8. FacilitiesCAD

    AutoCAD to MS Access and Back

    The following is the format for at template file that you might just save as template.txt First_tag_here c 040 000 Second_tag_here c 040 000 The trick about this is no extra spaces or [enters] now the scrit file(access.scr) to extract the data is: -attext c...
  9. FacilitiesCAD

    how to use vba to mk stickers..

    Alright, I opened the file and the code you want doesn't look to hard. First I want to thank you because your file showed me vlookup wich I had never seen before. You can aproach this from a few different ways. Either you can set up a macro that you run after each data entry or one that does...
  10. FacilitiesCAD

    AutoCAD to MS Access and Back

    I learned this mostly between this web site and the tek-tips site. (plus reading different help files once I heard of the commands) (I am using Autocad lt 2000 and access 97) (Do not use spaces or you may need to find other ways of doing this) 1st) how to make a "block" that...
  11. FacilitiesCAD

    AutoCAD to MS Access and Back

    I only know how to do this 1 way so far. I can insert a block with defined attributes into an Autocad file and I can also pull out those defined attributes into access but I don't currently know how to change from access the attributes already in an autocad file. Would this information be of...
  12. FacilitiesCAD

    how to use vba to mk stickers..

    Page requested not found. Reading your note makes me think you understand the logic needed to do what you want to do. First are all 3 sheets in the same workbook? It sounds like you shoud be able to put in your "sticer sheet" =checklist!a1 if the information you want is always...
  13. FacilitiesCAD

    Multiple Drawings using MS Access as a database

    Heres what to do. (I assume you know how to use access better than I do) Bellow is an example. I created a file named insert_text_two.dwg (note it is best to avoid using spaces) The file has everything drawn out plus I have two parts of text that can be changed. To make text that can be...
  14. FacilitiesCAD

    getting rid of ' when I extract attributes

    I've learned how to extract attributes from my drawing file and now I'm trying to import them into access. When I do this manually I have a choice for text descriptor and set it to '. But now I'm trying to do this in VB code and I don't see any way of removing the singlequote. Does anyone...
  15. FacilitiesCAD

    Problems with \

    Thanks for the help, I was able to reload the printer under a different name.
  16. FacilitiesCAD

    Problems with \

    I have just tried that with no avail. Anyone else run into this problem or does anyone know the asci number for "\" Thanks, Tim
  17. FacilitiesCAD

    Problems with \

    Yes, I'm printing over the network, and I have tried,"/","\"and"\\" plus "^\" and "&\" I am currently able to print to that printer. My only problem is putting it in a macro because it treats a "\" as a request for user input. Thanks...
  18. FacilitiesCAD

    Problems with \

    I have made a tolbar button to print a specific way that I want. I am now trying to set it up for a different printer and unfortunately the printername is something like this: \\abcd\name When I put this in the \ causes it to pause for a user input. Is there any way around this. I am unable...
  19. FacilitiesCAD

    Pulling Text from AutoCAD

    Yes there is. There are differnt ways text can be put into autocad 1) Text 2) Mtext 3) Attribute The first two you need to edit the text so it has popped up in a window then highlight the text you want to copy and hit 'Ctrl' and 'c' to copy then go into notepad or word and hit 'Ctrl' and 'v'...
  20. FacilitiesCAD

    Linking Excel to Access data

    The other things you mention could be done in access but I see your point. Good luck. Tim

Part and Inventory Search

Back
Top