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

    Access (Case Sensitivity) - IDs

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

    GetPivotData Query

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

    VBA function issue with Excel

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

    VBA function issue with Excel

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

    Limitation of # of Tables available through ODBC???

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

    Limitation of # of Tables available through ODBC???

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

    Which is better: Actuate or Crystal XI

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

    Parsing out text

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

    Parsing out text

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

    CE Email Option

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

    CE Email Option

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

    String formatting using the ( ¦ ) symbol

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

    String formatting using the ( ¦ ) symbol

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

    Simple row shading?

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

    Automatically selecting the Month Prior

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

    Automatically selecting the Month Prior

    Enterprise will, but the cost is phenomenal ($45,000) for a server license. If you need a cheap way of emailing out your reports, let me know. (jppalmbak@llgm.com) The formula looks pretty standard, I believe that will work as well; if I am incorrect in my assumption, please step in.
  17. Palmbak

    Automatically selecting the Month Prior

    Will what work against Oracle 8.1? =) Enterprise or formula? Jon
  18. Palmbak

    Automatically selecting the Month Prior

    Mike, Not yet, but it will, you see, I am not writing it against a SQL Database, I am actually writing against a UniVerse Database. The parameters I wish to replace with formulas are {?Year} and {?Month}. Example: if {?Month}="1" then {AT_CLIENT.HRSH_WKD_THRU_MTH1} else if...
  19. Palmbak

    Automatically selecting the Month Prior

    Crystal Enterprise is a Web Based method to deliver your Crystal Reports. If you want some info regarding Crystal Enterprise go to (www.crystaldecisions.com/products/crystalenterprise/overview.asp) Cheers, Jon PS. Thanks for responding Mike!!
  20. Palmbak

    Automatically selecting the Month Prior

    I am posting reports to Crystal Enterprise, is there any formula that I can use that will select the prior month for reporting purposes. At the month end, we have 30 or so reports with parameters, is there any way I can use a formula instead of a parameter? Regards, Jon

Part and Inventory Search

Back
Top