Search results for query: *

Hi, I need to create a crosstab query using vba code. I have a table with six fields. I need to have two fields going vertical and one horizontal and another field summed is the data. Im using Access 2000. A sample of the final outcome would look like the data below: Year Month 210000...

I have data like this below. I am using Excel 2000. Year Month 210000 236000 237000 1990 1 2 341 188 1990 2 0 325 169 1990 3 1 343 174 1990 4 3 321 263 1990 5 1 354 305 1990 6 1 375...

Hi, I have a command button(cmdDerive) and a list box(listbox2) in a Microsoft Excel form. The list box has 11 items in it. When i select an item in the list box and click on the command button a calculation takes place. I need to add code so that if i do not have an item in the list box...

Hi, I have data in excel 2000 and i need to get the average of the "Employ" field grouped by all the other fields. Here is an example of the data: Year Month Owner NAICS Employ 1990 4 3 2210 44 1991 6 3 6111 2794 1994 7 5 6116 54 1993...

Hi, Is there a way to put minimize and maximize buttons on a userfrom in excel. I am using excel 2000. thanks, mike

Hi. I'm trying to copy a pivot table into a new worksheet using chart.copy. That turns the data sources into value lists (so not linked back to the pivot table). That's what I want because I want a graph suitable for printing, without all of the pivot table buttons. The problem is that if I have...

I'm trying to make a list box in Excel that takes a value list from a semicolon deliminted string (ie, "how; now; brown; cow"). In Access, I'd just set the RowSourceType to "Value List" and then assign the string to RowSource, but there isn't any RowSourceType in Excel. I...

Hi, I need to add a field to an Access Database using VBA code. Can this be done without using DAO. Because i am using a recordset in my code. or does that even matter. Im using Office 2000. Thanks, mike

Hi, I have a data that consist of 5 fields and is as follows: YRQTR County month1Emp month2Emp month3Emp 19901 031 5 7 6 19902 043 11 21 14 I need to put these five columns into four columns as follows...

Hi, Can anyone tell me if it is possible to create three data series in with dual axes in one chart using excel. I have done it with two data series but i dont know if you can do it with three. I am using office 2000. If someone can help me out I would appreciate it. Thanks, Mike

I have an application in access that creates tables and can export them into excel spreadsheets. I want to click on a button from access and make a pivot table appear. I have a macro that if I run it on any table in excel it will work correctly. The question is how do I make the pivot table...

Hi, I wrote a macro that creates a pivot table and a chart. It works correctly when I run it with the data in the same workbook that I created the macro. But when i try to run the macro with another workbook. It gives me an error. The error says "reference is not valid." Sub...