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

    Uniq Records question

    Hi Hokis, One of each code of two of each code is very different. However, here's one of each code based on your information above: SELECT ACCOUNT, FIRST, LAST, COMPANY, code FROM MyTable GROUP BY ACCOUNT, FIRST, LAST, COMPANY,code; where MyTable represents the name of your table. Hope...
  2. bkpchs237

    Excel word-wrap breaks down for large text blocks

    You may be running up against Excel's display limits. Per the Excel specifications and limits, only 1,024 characters are displayed in a cell, even though up to 32,767 characters can be stored in a cell and displayed in the formula bar. Use the Len() command to find the number of characters in...
  3. bkpchs237

    PowerPoint Chart Text/Font Issue

    kubanvz, Try creating the chart in Excel, get it exactly the way you would like it to look, then Edit, Copy, Edit, Paste Special, Picture into PowerPoint, or Edit, Copy Picture, Edit, Paste. If you don't need to edit it after it is placed into PowerPoint this should work just fine. If you...
  4. bkpchs237

    Forecasting future values based on historical data

    elsenorjose, Assuming that your dates are cells A1 thru H1 and your values in A2 thru H2 the following may help. There are a number of formulas (Forecast, Trend, Growth to name a few) in Excel that may help you with what you propose. However, to use them you will have to ask yourself some...
  5. bkpchs237

    DCOUNT....help!

    logisticsman, A little more help as to what is or is not working here may help us to assist you. Exactly what is happening to cause you to think that it is not updating automatically? Then the question is what are you counting? Should you be using DCount or DCountA? Hope this helps.
  6. bkpchs237

    Access 2003 report won't read query expression

    Kevinski, You state here that the query runs independently just fine. Then I suggest that the problem is with your report. You state that you are trying to write a report and graph the results. Am I to understand that you have placed a graph on the report? I have run into problems with...
  7. bkpchs237

    Access DB 97 to 2K - linked tables

    bkast3, You may have a significant number of issues to address here that may be better served asking your question in the Access forum, but I will try to address one or two. If I read this correctly you now have 2 different front-ends and 2 different back-ends. Now you need to link the new...
  8. bkpchs237

    trim function?

    tizwaz, Are your numbers actually numbers when brought in? By this I mean in the formula bar is the "number" appearing as 11111111111 (eleven 1's) or is it some sort of text entry? Also, do you want to keep them as numbers? If yes and yes, then the custom format for the cells as it appears...
  9. bkpchs237

    Referencing via VLookup

    Mizzness, As Lilliabeth stated the formulas work fine and seem to be proper as written. The questions are: Are you actually trying to find values that reside in columns B & C on the "Remove Access2" worksheet or are they in different columns? Otherwise, if you believe the item you are...
  10. bkpchs237

    Outlook Attachments (word, excel) d/n open. Cause machine to freeze.

    WaverlyITServices, An additional note, you may want to try to recreate the individual's profile. Hope this helps.
  11. bkpchs237

    Reformat Spreadsheet

    eao, I agree with anotherhiggins. Your data is setup in a fashion that is actually easier to handle than what you propose. However, to accomplish the task you describe I propose the following. Assuming your values listed start in Row 2 and continue downward, sort on the Names column, then...
  12. bkpchs237

    default file location in Outlook

    dumdum2, I believe the following link may contain some useful information for your concern: http://support.microsoft.com/kb/252732/en-us Hope this helps.
  13. bkpchs237

    Outlook Attachments (word, excel) d/n open. Cause machine to freeze.

    WaverlyITServices, "If I save a copy of the file to his hard-drive, I experience the same problem." "Logging onto that user on a seperate machine, the problem does not occur." These two statements seem to lean towards a file-type association problem with the one machine or something really...
  14. bkpchs237

    OLK2003 invite contact to appointment on behalf of another user

    hofburg, I believe that the following article will have information useful to you: http://support.microsoft.com/kb/327000/en-us Hope this helps.
  15. bkpchs237

    Make Excel hyperlinks local to current sheet

    patme, You will need to change the subaddress property of the hyperlinks on this worksheet. You can use something similar to the following code, which changes items that have hyperlinks in cells D3 thru D12 to places on Sheet1 on the current sheet to those same cells on the current worksheet...
  16. bkpchs237

    Excel 2003 trying to second guess my data types

    eti3nne, In Excel 2003 under Tools, Options, there are some options that you can toggle for Showing Paste and Insert Options. Check these options, then when you paste something you will be given a drop-down next to it that will allow you to choose to preserve formatting among other choices...
  17. bkpchs237

    MS word 2003 edit picture / crash

    Merlin182, Try deleting the picture then reinserting it. You may try to save it in an alternative format like a *.jpg file before reinserting as well. In addition you might consider some computer maintenance: http://www.theofficeexperts.com/cleanyourpc.htm Hope this helps.
  18. bkpchs237

    Excel 2003 trying to second guess my data types

    eti3nne, I have no idea what the next version might do. However, it seems from this and your other post that you are pasting information from a source that is not Excel. Information from other sources pasted into any program may have some difficulties. It seems that you are pasting in...
  19. bkpchs237

    Difficult for me!!

    leehale, Using the setup above where your values are in cells A1 thru C5 the following array-entered formula should work: =SUM(($A$2:$A$5="TOP")*($B$2:$B$5="PD2")*($C$2:$C$5)) If your value of "TOP - PD2" is in a particular cell then using the following array-entered formula, assuming the...
  20. bkpchs237

    have Outlook Notify Multiple users of Calender Items

    okamsrazor, In her boss' mailbox, go to the Delegates tab, I believe it's Tools, Options. There is an option to "send notifications of meeting requests to my delegate" that needs to be checked. Hope this helps.

Part and Inventory Search

Back
Top