Recent content by Palmbak

Is there a work-around within Access that will allow the Database to look at the following two (2) IDs as separate distinct records? Record A: "123abc456def" Record B: "123ABC456DEF" Any suggestions? Thanks, Jon Jon Palmbak Director Sales Finance www.broadridge.com

I have the following information in a Pivot table: Jan, Feb, Mar... Budget figures and a Total for the year, what I'm trying to do is Reference the Grand Total and I keep getting a #Ref, I can reference other parts of the pivot table using the GetPivotData function without a problem, it's just...

the code goes from upper row (rCrpFlsHmCellFT(iFT).Row + 1) to the lower bound row (rCrpFlsEndCellFT(iFT).Row - 1) and inserts the function calculateNasdRegChargePercent with the reference to the other cell >>Code For iCnt = rCrpFlsHmCellFT(iFT).Row + 1 To rCrpFlsEndCellFT(iFT).Row - 1...

I'm using Excel 2000, in the background I'm using VBA to populate data/functions into my spreadsheets.Every function works and shows the right result however one user defined function show only "#NAME?" instead of expected result. When I click on the cell the function...

There's a limitation of how many tables you can view with Excel/Access, I ended up downloading some shareware and it works (Query Tool (ODBC) 5.0). Thanks again. Jon Jon Palmbak Senior Business Consultant www.metlife.com

We have a warehouse environment which I'm trying to connect to via ODBC (either Access/Excel or Crystal) for whatever reason, I'm only seeing a limited number of the available tables. We have about 12,000 tables in our environment, does anyone know whether there's a limitation on how many...

I'm in the process of instituting a reporting solution throughout my company. My experience is with Crystal but they are pushing Actuate... so my question is; which is better or does it depend on the reporting/analysis requests? Any thoughts will be highly appreciated. - Jon Jon Palmbak...

Thank you both for your answers... Works perfectly!! Best regards, Jon Jon Palmbak Business Analyst www.llgm.com

03/15/04 - LL58781: BRYANT ODELL; M5 120 W 56 ST to QUJ Im trying to pull the following information out of the text above "M5 120 W 56 ST to QUJ" I can't use the right/left function (same for mid) because the length won't always be the same. Is there a function I can use that shows...

That is actually a pretty good idea. However, it would be nice if you were able to put the conditional in the subject line of the email. (Guess we will have to wait for that one.) Jon Palmbak Business Analyst www.llgm.com

Datamuse, I don't that he was referring to his reports erroring, I have the same problem. The report runs on a daily basis, but some days there might not be any data to generate returning 0 records. I think that we are trying to keep the email from sending out if there were 0 records returned...

That works PERFECTLY, thank you much!! Jon Palmbak Business Analyst www.llgm.com

This is what I have: This is what I am getting from an Address field. =============================== Stephen E. Miron, Esq.|Miron Building Products Company, Inc.|Route 9w|Lake Katrine Rd =============================== This is what I want: =============================== Stephen E. Miron...

Is there a conditional formatting option available for shading alternating rows? Whether it be a Group1 or Group2 or Detail sections of a report. Anyone have any suggestions? Thanks in advance, Jon

Yup, Ido Millet has an application called "Visual CUT" which is real cheap and an all around "awesome" product. www.milletsoftware.com Highly recommended!!!!! Cheers, Jon