Search results for query: *

I would like to click on a button on a form (after specifying a file name) and be able to automatically import an Excel file into an Access database. How should I go about doing that? Some code examples would be much appreciated. Thanks M

How can I use & in enumerations? I tried escaping it by using & but it doesn't seem to work.

When I try to export a pivot table view to Excel, it doesn't export the data in the data section. Why is this? It says, "Drop Data Items Here" in the excel spreadsheet?

I have a pivot table view. I would like for the contents of fields in the data section to wrap around. How can I this? I looked in properties, but I don't see any options for 'row height' or 'wrap around'.

I have a pivot table form. I would like for the contents of fields in the data section to wrap around. How can I this? I looked in properties, but I don't see any options for 'row height' or 'wrap around'.

I have two combo boxes on my form. I would like the selection list of the 2nd combo box to display values that are valid for the selected item in combo box 1. For example, let's say Combo Box 1 shows a list of states. When a particular state is selected in Combo Box 1, I want Combo box 2 to...

I'm looking for a good free XML editor. Can anyone recommend one?

I have an ASP page that is accessing a SQL Server database to display data. Everything works fine on the development box. When I move this to production, I got the following error: "Active Server Pages error 'ASP 0113' Script timed out The maximum amount of time for a script to execute...

I'm trying to excluding some rows from my resultset. Here is an example: Table 1: Is the universal set of records (10,000) records Table 2: Has a subset of the records that exist in Table 1 that meet condition1 (different from condition 2 below) Table 3: Has a subset of the records that...

I'm trying to create a new web project in Visual Interdev. When I get to the "Specify a server and mode" screen, I specified the server name, the mode and hit next, but I keep on getting "Unable to contact server" error. I've tried using the IP address:port number, IP address, machine name...

I have a SQL Server 2000 database. I created a couple of database login ids. Everything is find when I created the user accounts and set the password. But when I try to set the Database Access for these user accounts, SQL Server takes me to the Confirm Password screen. I enter the password...

I have an ASP application that uses an ActiveX DLL. As I'm debugging the ASP app, I would like to jump to the ActiveX DLL's code to debug it when I get to the line that references the DLL using the CreateServerObject command. How can I do this? I have the DLL and the sourcecode for the DLL on...

I installed Visual Studio 6 on my desktop running Windows XP. I use Visual Interdev to develop a web application (ASP). I use a local IIS server as the web server. I'm having problems using the debugger. I get the following error when I try to debug: "Unable to find project on server...

I just moved a website (it is an asp application) to a new site. This site used to be a virtual directory under another website. When I moved the site to a new site, I made sure that I modified any code that was referencing files from the parent old site. For example the old setup was like...

I have two sub reports in my main report. Each subreport displays a number field. I would like to total these numbers for each row and also sum up the grand total for each column on the last page of the report. How can I do that? How can I access fields on my subreport from the main report?

I have a table that contains program_id, program_name, signed_date, paid_date. I would like to get a count of the signed_date field where the paid_date is not blank. I have the following query: SELECT Program_ID, Count(Signed_Date) FROM Program GROUP BY Program_ID, Paid_date HAVING...

I need to create a report that keeps track of signed/unsigned records for internal programs of different departments. The following is an example of the data layout: DeptID ProgramID Sent_Date Signed_Date 1 1 10/10/04 1 2 10/12/04 1 3 10/1/04 10/31/04...