Recent content by jmnekrkt

Woo! Hoo! it works! Thank you

I've read that I can determine the data source of my pivot table by starting the wizard and using the "back" button. The "back" button is not available when I start the wizard. I am using excel 2000 and an external sql olap cube as a data source...I just can't determine which server or cube...

I'm trying to create a cross tab query that will display all the days of the month even if some of the days have no data. I remember being able to specifiy column names in the past (I used it to order months chronologically instead of alphabetically) but can't find how to do. Thank you

I have a link to an excel template in IE 6...I receive "page cannot be displayed" error. Everyone else in the office can open fine. If I use IE to start Excel and then open I do not have a problem...just cannot open from w/in browser.

I have a workbook with a submit button. When the user clicks submit, I want to see if the fill has been saved with a new name. If not, I want to display the Excel Save dialog box...after the save, the macro sends an email w/the file attached. I currently have working code that asks the user...

I have several excel workbooks from which I need to read data. The sheet in each workbook is named "program"; however, the 1st row of data is different w/in each sheet. I can name the range where the data resides. I need code to find the first row of the range so I can set that as...

discovered that if i write the formula as =sum(a1,a2) instead of =a1 + a2, it will correctly add all cells and not result in #VALUE error. All other math functions do not produce error...

the are using a custom format to display a zero as a dash. my sheet directly links to the cell with the zero value but is reading the formatted dash instead of treating the value as zero. I am actually linking to several cells in a sum formula so the iserr or if("-") formulas are...

My customer is submitting a spreadsheet formatted to show a dash if the value of the cell is zero. When I link to that cell for further calculation, I receive the #VALUE error. I know I can reformat the sheet or I can check for the dash or value (but that makes a really long formula). Is...

Using VB 6, I'm trying to append (or import) data from a secure Access 97 database into a secure Access 2k database. They have two different .mdw files. The VB code to set up and access the Access 2k Database is: DBEngine.SystemDB = "C:\Program...

Thank you for the location. I did not intentionally double post...the site hung up and then failed...there was no evidence that the first submit was successful until I saw both posted. If there is a way to delete erroneous posts, please advise for future reference.

This is the microsoft article I spoke of: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q209778 Access pretty much does not work well with dynamic fields based on crosstabs. You may have to define them another way...similar to the way the filter code works.

Thank you both for responding. This question actually got double posted and was resolved under the other post...with practically the same solution.

if periodeid does not exist in the crosstab results, the filter will not work. I'm not clear on how you are actually trying to select what to print. As for adding the code, open the form properties and select the "on open" event. Your code goes in there. I feel your pain...I too...

I too was having the same type of problem. Crosstab queries do not like parameters. There is a microsoft article that explains how crosstabs evaluate the expression. I finally solved the problem, with excellent help from this forum by using a filter on the report. Try adding the following to...