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 derfloh 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. wadjssd

    Customers NOT buying items

    Hi all, Hopefully there's a more simple way to do what I'm trying here - via some funky SQL code. I have an item that is my best-selling line. I have created a table(A) containing all the people that have bought it in the last month, and another table(B) containing all of the other items that...
  2. wadjssd

    Excel VBA Error Handler Looping Problem

    Excellent - it now works a treat. Many thanks, Skip! :o)
  3. wadjssd

    Excel VBA Error Handler Looping Problem

    Thanks Skip, Unfortunately, when I run your version the code falls over at the first occurrence of a non-matched value in the lookup, almost like it's unable to 'activate' the VLOOKUP procedure without having an Error Handler to refer to....weird. Any more thoughts? "Runtime error '1004'...
  4. wadjssd

    Excel VBA Error Handler Looping Problem

    Hi all, I've found a similar thread to this as posted previously, but the solution given doesn't seem to work for me. So, here goes: I'm performing a VLOOKUP using VBA (it's a massive spreadsheet so the efficiency benefits are huge - plus, it forms part of a much larger automated process)...
  5. wadjssd

    IIS Installation problem

    Me again. Just for info for those that may suffer the same fate as me, as I have now solved the issue. I'm not sure which of the 3 pieces of software I listed was to blame, but I did a full uninstall of all 3, removed IIS, rebooted, and then reinstalled IIS. Success!! I have subsequently...
  6. wadjssd

    IIS Installation problem

    I'm running Win XP Pro SP2. Upon trying to install Visual Studio .NET, I was informed that as a prerequisite, I needed to install IIS and Frontpage Server Extensions. So, in the ususal way I did so via Add/Remove Windows Components. Windows threw up no error messages during this installation...
  7. wadjssd

    Excel Runtime error via Internet Explorer

    Hmmm, not sure about this. When the form is initialised, the code uses "Range" references to populate the dropdown lists...so I can't understand why it seems to be losing the link back to the spreadsheet once the form is loaded...plus why this is only happening when run via IE. I've tried...
  8. wadjssd

    Excel Runtime error via Internet Explorer

    I have built an Excel model which performs various convoluted calculations based on dropdown boxes and text box input. One element takes the product of values from 2 text boxes and divides this by an exchange rate, which is selected via a dropdown box. The various exchange rates are held in the...
  9. wadjssd

    Populate an array with the results of an Access query?

    I've got an existing query which produces a simple recordset of unique values (all text strings) from a table. I'm writing a VBA module and would like to be able to automatically populate an array with these unique values. Is this possible? If so, any help / pointers would be gratefully...
  10. wadjssd

    Lotus Notes HTML footer problem

    Hi I am trying to set up a colleauge with a simple HTML file as a footer for all of her emails. I have set up myself perfectly successfully, but whenever she tries to create a new mail message, she gets the following error: Invalid View Environment Variable - check Notes.ini I can happily sit...
  11. wadjssd

    User-defined functions causing slow recalc

    I have a file with half a dozen or so sheets, which I am converting from 123 on behalf of someone else. To get around the differences in the database functions between these two apps, I have written a couple of my own functions to do some DCOUNTS and DSUMS. There are probably a thousand...
  12. wadjssd

    Switchboard in Excel (similar to Access switchboard)?

    Hi ashows, I guess the best way to accomplish this is by creating a user form, with buttons on it which take the users to the various sheets / print out the various reports. This will then appear to be very similar to the Access switchboard. Let me know if you need more details on creating user...
  13. wadjssd

    Excel sheets behaving differently....

    Thanks to you all for your time on this, especially DaleWatson123321, whose "A3& Text(B3, Format)" method has provided a more than adequate workaround. A nice shiny star well-earned. If anyone ever manages to solve this one 'properly', I'd be interested in the solution. Cheers, wadjssd
  14. wadjssd

    Excel sheets behaving differently....

    Hi - thanks for the replies, Unfortunately, I'm still getting the same result. I have tested doing a concatenation in another location on the problem sheet, which works okay - but still no joy in the place where I need it!! Very weird. I have checked, double checked and triple checked all...
  15. wadjssd

    Excel sheets behaving differently....

    Yep, checked all that. There seems to be no difference at all between the sheets, but still the mystery error continues....
  16. wadjssd

    Excel sheets behaving differently....

    Hopefully there's a simple explaination for this quirky behaviour..... I have a workbook with numerous sheets. In, say, Sheet1, a concatenation formula such as =A1&A2 gives the expected results, regardless of the contents of the cells A1 and A2. However, on, say, Sheet2, the same formula...
  17. wadjssd

    Checking ColorIndex in Excel

    Yes ta! [thumbsup2] wadjssd
  18. wadjssd

    Checking ColorIndex in Excel

    I have written a small function to check if a cell's interior color matches a color specified by the user. Here is the code: Function ColorCheck(Rng As Range, Indx As Integer) As String If Rng.Interior.ColorIndex = Indx Then ColorCheck = "Yes" Else ColorCheck = "No" End If...
  19. wadjssd

    Unable to open file

    My mistake - it's Lotus 123 '97. wadjssd
  20. wadjssd

    Unable to open file

    Yes, the .123 extension is a Lotus 123 release 5 (I think) file. Excel 97 doesn't recognise them - not sure about 2000/Xp. You might need to get the originator to re-save the file as a .wk4. Cheers, wadjssd

Part and Inventory Search

Back
Top