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!

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

Search results for query: *

  1. sahmiele

    Access 2007 error opening database

    I am having an issue opening an old database somebody else created, and I can't figure out the problem I am using access 2007, and when I open my database immediately I get the error message: An error occurred while loading 'Form_MAIN SCREEN'. Do you want to continue loading the project? I...
  2. sahmiele

    Unique values only problem

    I am trying to get the variable "MyList" to only have unique values. It works fine when I just load all of the values, but I can't prevent duplicates. The values are sorted alphabetically, so it shouldn't be that difficult, but I am at a loss. Any help would be greatly appreciated. Thanks...
  3. sahmiele

    job won't run, doesn't realize there is available space on tape

    I have a bunch of weekly jobs, running to a partition that contains three tapes. We have two drives, and the jobs all run smoothly until a tape fills up. Once the first tape fills, it goes to the third tape. If the second tape fills while the third tape is in use, the job won't recognize that...
  4. sahmiele

    how can I avoid having to reload routers constantly?

    Will I have to do that every time it goes down, or just once to correct it?
  5. sahmiele

    how can I avoid having to reload routers constantly?

    We have 70 store locations with vpn connections through cisco 871 routers. Every time there is some disruption, the tunnel drops, which I understand. The only problem is that it does not re-establish the connection. The only way to bring back the tunnel is to telnet into the router and reload...
  6. sahmiele

    addins showing up strange on excel 2007

    I have the code below, which in xp is creating a new menu bar with items to click which will run the macros assinged. When this is opened in excel 2007, the addins tab has the "Order Entry Program" dropdown menu with all of the items in it, and also all of the items on the addin tab. Is there...
  7. sahmiele

    drawing on a form

    When I click Help, about microsoft visual basic, why does it say visual basic 6.3, not visual basic for applications x.x? the code above did not work.
  8. sahmiele

    drawing on a form

    strongm, any way to do this in VB 6? I did post this in the VB 5 & 6 forum, not the VBA one, or did I put it in the wrong one?
  9. sahmiele

    drawing on a form

    I understand, but when I am looking at the form, the "line" button is not in my toolbox. That is why I'm stuck. I have no way to get a line on the form, by design or by code.
  10. sahmiele

    drawing on a form

    When I am looking at the form, the toolbox does not have a "line" option. When I am looking at the code, I can not even click on the toolbox. It is greyed out.
  11. sahmiele

    drawing on a form

    still no luck. Any ideas on how to find/reinstall the necessary dll?
  12. sahmiele

    drawing on a form

    The toolbox icon is greyed out while i am looking at the code, and I can't bring it up. my visual basic version is: Microsoft Visual Basic 6.3 Version 9969 VBA: Retail 6.4.8869 Forms3: 11.0.5709 Could you post the full code above? Then I can modify it. Thanks!
  13. sahmiele

    drawing on a form

    both would be nice to know. I do not have have a control in my toolbox for Line.
  14. sahmiele

    drawing on a form

    Is there any way to draw a line on a form? I can't figure it out to save my life! the form name is MainMenu. Any help would be greatly appreciated.
  15. sahmiele

    Compile Error: Can't Find Project or Library excel

    so, it should look like this: with ThisWorkbook.vbproject Set xObject = .References.Item("ordering") .References.AddFromFile("c:\my orders\ordering.xls") End with Correct?
  16. sahmiele

    Compile Error: Can't Find Project or Library excel

    FXP, what is "crystal"? is this the missing library?
  17. sahmiele

    Compile Error: Can't Find Project or Library excel

    I have an excel file with some macros and forms in it that I have emailed to some external users and are getting the above message. I have searched the error and have found the solution, but I don't want to have to walk 100 users who don't have a strong grasp of computers through the steps of...
  18. sahmiele

    trying to eliminate some excel vlookups

    I've looked at them, but can't seem to get them to work. What are the values I'm supposed to be getting from them?
  19. sahmiele

    trying to eliminate some excel vlookups

    I have an excel workbook, that uses a ton of vlookups. In each row, there are 7 vlookups. They pull product information (description, price, size, etc) from a worksheet (PRICE BOOK) based on a sku number (Column A) on the main worksheet (TEMPLATE). Is there a way I can find the row number of...
  20. sahmiele

    recording excel file size in a variable

    awesome, thanks. Also, is there a simple way to do the same thing with a folder if I have the path name?

Part and Inventory Search

Back
Top