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

    slightly different duplicate query

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

    slightly different duplicate query

    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()...
  3. cdipaolo

    finding max date within groups within a query

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

    finding max date within groups within a query

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

    Calling the EndEdit event - syntax question

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

    Calling the EndEdit event - syntax question

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

    Converting OWC Spreadsheet from 9 to 10

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

    Active X Control within DLL?

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

    Creating component within a DLL

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

    Outputting results from Access VBA Module to a Table

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

    Outputting results from Access VBA Module to a Table

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

    Just starting - manipulating Access data using VBA

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

    Error when opening Visual Studio

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

    Error when opening Visual Studio

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

    Programatically determining the version of Office installed

    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?
  16. cdipaolo

    Weighted average in a report

    ...each location has. I can also get the contribution to the total weighted average for each by multiplying customer satisfaction for that location * (location volume/total volume). However, when I try to add all of those individual weightings up at the bottom I'm trying to sum up individual...
  17. cdipaolo

    Dropdown boxes

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

    Sharepoint2003: Costomize notification EMail?

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

    Controlling access to a Document Library

    ...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 document library * Delete this document...
  20. cdipaolo

    Sharepoint2003: Costomize notification EMail?

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

Part and Inventory Search

Back
Top