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

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

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

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

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

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

I have an Excel spreadsheet which contains a query. The data source for the query is a 'table' (a named range) within the same spreadsheet. What I need is some way of tying this source to the query. When the file is copied or moved or emailed and saved elsewhere, the SQL in the query is...

I have a series of mail merges set up with their respective source files, and everything works fine.....until one of the source files is empty. The contents of the source files changes weekly, and from time to time can conceivably be empty. This presents a problem. I cannot error trap this...

I am querying a data range within an Excel spreadsheet to extract the records that match my criteria. Two of the columns in my range are IDNO and NAME, which are numeric and text respectively. If I set up my criteria range using IDNO, I get perfect results. But if I use the text field NAME, I...

I'm trying to get Access 97 to initiate Word 97 and run a macro within Word. I've got the DoCmd object, and am trying to get both the Maximize and RunMacro functions to work, ie to maximize my Word application and execute MyMacro. Why isn't this working? channel =...

This is probably really simple, but I am new to DDE coding.... I want to get a macro in Word to run when I click a button in Access. I can get Word initiated, but cannot get the code to work right so that the macro runs too. Any help much appreciated. Thanks.