Recent content by mimivdg2002

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

That works. Thanks a lot.

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

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

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?

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.

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

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

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

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