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!

Recent content by CuckooNut

  1. CuckooNut

    Setting Excel Column Width from Access VBA Module

    Skip/Andy, Thanks for your help. Andy, you were spot on. I found a line farther down in my code that executed the autofit and thus overwrote my static column widths. Feelin' pretty sheepish right now! Skip, even though I ended up not needing it this time, that FAQ is extremely useful, so...
  2. CuckooNut

    Setting Excel Column Width from Access VBA Module

    Hi Skip, Thanks for your reply. I did as you suggested, but it still does nothing. Here is what I have written: With ExcelWkb.Sheets("Sheet1").Range("A:A") .EntireColumn.ColumnWidth = 35 End With What I don't understand, is why all of the other formatting seems to work. In...
  3. CuckooNut

    Setting Excel Column Width from Access VBA Module

    Hello, I have an Access VBA module that outputs the results of a query to an Excel 2007 spreadsheet. I have written the code to format the cells as needed, and everything seems to work except for one thing: for some reason, it just ignores the code I have written for setting column width...
  4. CuckooNut

    Missing 'msador15.dll' version 6.0

    Ok, I found the answer. Basically, what it came down to was that Windows 7 stores the msador15.dll file in the 32-bit system folder. Here is the default path: C:\Program Files (x86)\Common Files\System\ado\msador15.dll Note that it is located in "Program Files (x86)", rather than in the...
  5. CuckooNut

    Missing 'msador15.dll' version 6.0

    Hi everyone, I have an Access 2007 database that has been working perfectly - until now. I was provided with a new computer at work, and now whenever I try to open the database, I get the following error: "Your Microsoft Office Access database or project contains a missing or broken reference...
  6. CuckooNut

    Removing all characters after a certain point in a text field

    Hi everyone, I have an Email field in my table that I converted from a Hyperlink field into a text field, and now all of the email addresses are concatenated with "#mailto:[the person's email address]". I need to delete everything from "#mailto" to the end of the string. I could go through...
  7. CuckooNut

    Method 'Open' of object 'Workbooks' failed

    Well, sure enough, the problem lies with the Approve-It add-in. We disabled it on my co-worker's computer, and the procedure now works perfectly. Go figure. We both had the same add-in installed, but for some reason it was only an issue on his machine. Oh well. Thanks, gkoliver, for your...
  8. CuckooNut

    Method 'Open' of object 'Workbooks' failed

    bubba100, I have not tried that. I don't think the file name is the issue, because it actually opens the file (he sees it on his screen), but then gives the error before any of the cells are populated with the export information.
  9. CuckooNut

    Method 'Open' of object 'Workbooks' failed

    Skip, The user clicks a "Browse" button and then selects a file in the file dialog that appears. txt_Select_File is the text box that receives the pathname of the selected file, so it should be accurate every time.
  10. CuckooNut

    Method 'Open' of object 'Workbooks' failed

    gkoliver, Thanks for your response. We actually went through and compared which add-ins he had on his system with the ones I had on mine,and they match up. We both have the ApproveIt add-in, but it doesn't seem to be causing any issues on my computer. Maybe I will have him disable it...
  11. CuckooNut

    Method 'Open' of object 'Workbooks' failed

    Hi everyone, I have a procedure in my database that exports some information from Access 2007 into an Excel spreadsheet. The procedure works perfectly whenever I run it on my computer, but when one of my co-workers tries to run the same procedure on his computer, he gets a "Method 'Open' of...
  12. CuckooNut

    Importing duration values from Excel to Access

    Also, just so you know, it exported the results as the number, and not as the formula.
  13. CuckooNut

    Importing duration values from Excel to Access

    jges, that worked like a charm. Thank you! And thanks to all of you for your help!
  14. CuckooNut

    Importing duration values from Excel to Access

    Thanks for your responses. I am fine with storing the durations as seconds in the database. My question is, what is the best way to convert the duration from the date/time h:mm:ss format that the spreadsheet uses into the whole number format that I need in order to store the data as seconds in...

Part and Inventory Search

Back
Top