Search results for 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()...

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

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

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

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

One of the standard column options for a view is the time that a document was last modified. Has anyone ever seen how to have a column that shows when a document was checked out?

We have a WSS Team Site set up with one document library. We use the Team Site to collaborate on documents and then, when we are done, would like to archive them in Documentum. Getting the files from SharePoint to a place where we can bulkload it into Documentum shouldn't be a problem...

I am passing a date into a function and want to return a date one month from that date. For example, if I pass in 1/1/2003 I want to return 2/1/2003. I know how to do this in Excel (=date(year(a1),month(a1)+1,day(a1)) (the date will always be the first of the month for simplicity's sake). How...

To simplify, I have a spreadsheet with a row that has dates (i.e. 1/2001, 2/2001, 3/2001, etc.) and a row with earnings figures (i.e. $5000, $4000, etc.). I have a column for each month (1-120...start date is configured elsewhere). I am trying to write a function or macro that returns...

I have a very simple macro in Excel that selects a sheet that is passed in - something like: Sub GetSheet (strSheet As String) Sheets(strSheet).Select End Sub This macro works running it by itself or if attaching to a command button. Now, when I create a custom menu and attach this macro to...

We are mimicing some functionality of 3rd party software for a demo but don't want to actually connect to an external system. SO, we want to replace the resulting HTML screens with screenshots (.jpg files). Is there a way to create an HTML page that will basically be the .jpg? I have tried...