Search results for query: *

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

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

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'...

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)...

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

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

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

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

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

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

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

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

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

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

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

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

Yes ta! [thumbsup2] wadjssd

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

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

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