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

    Importing Excel data

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

    Ampersand in enumerations

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

    Exporting Pivot Table View to Excel

    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?
  4. mimivdg2002

    Pivot Table View

    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'.
  5. mimivdg2002

    Wrapping around a pivot table row

    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'.
  6. mimivdg2002

    One combo box dependng on another combo box

    That works. Thanks a lot.
  7. mimivdg2002

    One combo box dependng on another combo box

    I have the following lines in the AfterUpdate event of Combo1: Combo2.Requery Combo2.SetFocus Combo2.ListIndex = 0 I get the following error: "Run-time error '7777'. You've used the ListIndex property incorrectly". Any idea, why? Thanks M
  8. mimivdg2002

    One combo box dependng on another combo box

    Thanks, I now have the two comboxes working as desired. The values listed in combo box 2 are based on the item selected in Combo box 1 which is what I wanted. I have another question, how can I make sure that combo box 2 always selects the first item on the list in other words, I don't want...
  9. mimivdg2002

    One combo box dependng on another combo box

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

    XML editors

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

    ASP timeout errors

    It's not a problem with ADO ConnectionString, other ASP pages on the production box use it to connect the database and fetch data. Account or database permissions are not the cause either, as I said other ASP pages connect to the database fine. The problem is only with this one ASP page.
  12. mimivdg2002

    ASP timeout errors

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

    Excluding rows query

    You are exactly right, T2 is a subset of T3. So now what I have done is this: 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...
  14. mimivdg2002

    Excluding rows query

    Replacing AND with OR isn't going to do it. Sorry, I mispoke earlier, what I want to get are records from table 1 that are not in table 2 and that are not in table 3 (records in table 1 that are neither in table 2 nor in table 3). Thanks M
  15. mimivdg2002

    Excluding rows query

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

    New project in Visual Interdev

    Yes. The Front Page extensions are installed (that's one of the things the document had me check). Any other ideas?
  17. mimivdg2002

    New project in Visual Interdev

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

    I have a SQL Server 2000 database.

    Yes, I'm System Administrator in SQL Server. I'm able to create logins in SQL Server. It is when I go to the properites of existing logins and want to change something such as adding database access to particular objects that I run into this problem.
  19. mimivdg2002

    I have a SQL Server 2000 database.

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

    Debugging an ActiveX DLL from ASP

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

Part and Inventory Search

Back
Top