Search results for query: *

Thanks - you just need to change the "where" to "having" since count is an aggregate function. Exactly what I was looking for.

I have a table (PRICES) with the following data: product, location, price, date. I want to find all of the records where the product and location are the same (shouldn't have more than one combination of product/location). I'm having trouble finding the right combination of count() and group()...

That answers that question perfectly - the only problem I have (and I didn't think about this when posting) is that each row of the table has a value that I want to return as well. Each reporting date will have a different score so I want to include the score that was reported on that reporting...

I have a table that looks like this: State, Location, Source, Date TX, Houston, 1, 1/1/05 TX, Houston, 1, 12/1/04 TX, Houston, 2, 2/1/05 TX, Houston, 2, 3/1/05 TX, Dallas, 1, 1/1/05 etc. Basically I want to be able to go through the table and find the latest date for each location and for...

FYI, I needed to put the text "ByVal" in front of the variables that were being passed in.

I have the following code which is designed to show two buttons (save and cancel) when the user finishes editing a spreadsheet object in an Access form. Private Sub wks1_EndEdit(Accept As Boolean, FinalValue As Variant, Cancel As Variant, ErrorDescription As Variant)...

I would like to convert all of my OWC Spreadsheet objects in my Access application to XP - I thought I would be able to use the "Convert" option, but it only lists the 9.0 (i.e. same version that is already there). What do I need to do to be able to convert it to 10.0 (without deleting the 9.0...

Right now I have an Access application that uses OWC Spreadsheet components (inserting this component directly into Access forms) and referencing MSOWC.dll. However, some of these calls are not compatible with Office 2003 so I would like to create a wrapper component within one of our DLLs that...

Right now I have an Access application that uses OWC Spreadsheet components (inserting this component directly into Access forms) and referencing MSOWC.dll. However, some of these calls are not compatible with Office 2003 so I would like to create a wrapper component within one of our DLLs that...

Thanks for the suggestion, but the criteria is complicated and depends on the record before and after it (when sorted correctly). It turns out I'm going to put an OWC.Spreadsheet object on a form and display it that way. Thanks again.

I am stepping through a recordset and along the way find records that I want to send to a table or some type of report - what is the syntax for doing this? Do I need to save the records in an array and wait until I am done, then open a new recordset to update a table with the records in the...

I have a few complex queries created in Access but now I have to use some VBA logic to step through the records in these queries and sort/exclude some of them. Do I just start up a module and use the same ADODB type stuff as I would if I did it in Excel? Or is there an easier way to approach...

Thanks for the advice, although I'm still getting the same error. Someone here said it was because it was trying to update the version of OWC that I have installed. I don't actually want to do that so I would normally cancel the installer, but (a) it doesn't actually end up installing anything...

I have Visual Studio 6.0 with SP4. When I open the application Windows Installer appears and the dialog box says "Installing...." but nothing ever happens. I can click once on one of the top menu items and then am completely frozen (have to ctrl+alt+del) in the application (can go to other...

I am working with an application that uses Office Web Components - this uses a different DLL depending on if the user has Office 2002 or later. Is there a way to programatically determine which version of Office a user has installed?

Hi, I'm new to Access so forgive me if there is an obvious answer. The description below isn't the actual fields but it makes it easier to understand. I have a report that lists total sales by location and customer satisfaction by location). I would like to show a weighted average of customer...

Does anyone know the exact requirements to be able to see the dropdowns? Is it just that the user needs one of the minimum standard browsers (e.g. 5.01/SP2, 5.5/SP2, 6.0+)? Or is there anything else like a security/JavaScript security setting? I'm trying to let the client know what their...

I'll admit that I haven't modified these, but it states that they are for "the content and format of e-mail alerts about changes made to list items" which it sounds like you are trying to do... Sorry I can't provide any pratical advice beyond the link

when you click on the modify settings and columns, the first section is called "General Settings". In that section at the bottom there are four links, which of the following do you have? Change general settings Save document library as template * Change permissions for this...

There is information related to this in the WSS SDK Help file. You can download it from here: http://www.microsoft.com/downloads/details.aspx?FamilyID=1c64af62-c2e9-4ca3-a2a0-7d4319980011&DisplayLang=en The beginning of the help is below (it is followed by more details and examples)...