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!

  • Congratulations TouchToneTommy 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: *

  • Users: pro356
  • Content: Threads
  • Order by date
  1. pro356

    csv file too big for excel

    We have a file in csv format with about 1200 columns and over 2 million rows. It is 3.8 gb and too large to open in Excel. We need to be able to filter on several columns at once to conduct specific searches and are stymied trying to find something that will work. Any suggestions?
  2. pro356

    Excel- Sum only the values in column 3 which meet the exact criteria of colum 1

    I have a spreadsheet I am trying to build as template for a budget. In one tab I have listed all our customers and the budgeted amount of income per month. Included in that tab is a column showing the type of income for each client (which income account) by month, it could be one of 6 different...
  3. pro356

    Outlook missing text on replies

    This has gotten especially bad since we started using Google Apps and hosted our email on Google. Email replies from some companies do not get coded properly or something and do not show up in Outlook. The header shows receiving the email from the proper party but nothing shows in the text. If I...
  4. pro356

    Outlook stopped sending, still receives

    I'm perplexed. Suddenly my Outlook 2003 won't send my email. I receive everything fine. When it attempts to send it just acts like nothing is in the Outbox, but there are currently 11 emails in my outbox.
  5. pro356

    Can't format lap top HD

    I want to format my hard drive on my laptop. I don't need most of the programs or files and have copied anything I need. I primarily use it only to surf the web or to connect to my pc at work using logmein.com. I open My Computer and click on the "C" drive, than go to File\Format. It keeps...
  6. pro356

    Outlook error message- Recipients can't be reached

    Using Outlook 2003. For some reason I frequently get the following error message when I attempt to reply to an email. Your message did not reach some or all of the intended recipients. The following recipient(s) could not be reached: 'abc@cebridge.net' on 6/30/2006 7:59 AM...
  7. pro356

    Oops. I deleted a Distribution Group. Can I get it back?

    Using Outlook 2003. I accidentally deleted an entire Distribution Group when I meant only to remove one member. Clicked in the wrong place. I don't see the deleted group in my Recycle Bin. I had several hundred members and recreating it will be a major pain. Am I stuck or is there a way to find it?
  8. pro356

    Contacts always opens to Accounts

    Using Outlook 2003 with Business Contacts Manager. Whenever I compose a new email and click"To" to select a name, it automatically opens to "Accounts" list on the drop down instead of to Contacts, which is where I have most of the contacts. Is there a way to make the default open to Contacts...
  9. pro356

    Setting default media player

    I seem to totallyy forgotten how to do this and can't find it on any search. How can I reset Windows Media Player 10.0 as my default so that all audio files I play off the internet automatically play there?
  10. pro356

    Outlook 2003- Send multiple emails to Junk mail?

    I really like the Junk Mail filter in Outlook 2003 and how easy it is to right click and send a specific email to Junk Mail, and add it to the filter simultaneously. What I haven't been able to figure out though is how to do this with more than 1 email at a time. Is there a way?
  11. pro356

    Hide or change error message in Vlookup result

    I am using a VLookup in Excel to auto-fill in info on purchase orders when entering just the p/o # on another sheet as new inventory items are added for that p/o. Problem is I need the formula down the entire column but until a p/o # is entered on the new sheet it shows the error message "#N/A"...
  12. pro356

    Formula VLook-UP in 2 columns at once.

    Is it possible to do a VLook-up in 2 columns? No problem with 1 column but need to return a value from table array where columns B and C in one spreadsheet match identically to columns H & I in other spreadsheet.
  13. pro356

    Outlook blocking attachments

    The help menu tells me what level 1 and Level 2 attachments Outlook will block, but can't find any way to change the settings. I receive .xls and others no problem, but now can't get any .mdb files. Is there a way to change this to allow them to be opened or even visible?
  14. pro356

    VPN and Millennium edition

    Is it possible to set up a VPN and Remote Desktop Connection using the Millenium Edition of Windows or do I need 2000 or XP to do this?
  15. pro356

    RM- Quickest view of open invoices

    What is the quickest way to view what are currently unpaid invoices by customer? I can go to reports-sales-statements and print statements that show a total amount but it looks like the total billed, not the total open. I choose unapplied only but it still shows just the total? AM i missing...
  16. pro356

    Adjusting print layout on checks and invoices

    A consultant originally set up my print format for my checks and invoices in GP Dynamics. Unfortunately both need adjustments to the layout of how they print. I believe this was set up within GP and not an external Report Writer. Where is this located within GPD and how can I make adjustments to...
  17. pro356

    Apply cash from 2 checks with dupl

    Received check #1 that included some payments not belonging to me, so applied all the valid payments and have money left. Check #2 from same customer deducted those erroneous payments from check #1, so not enough cash to apply to valid payments. What is the right way to handle this in RM? Cash...
  18. pro356

    Outlook wants to select fax vs. email

    Why is it that Outlook seems to arbritrarily decide sometimes to select the fax address instead of email address? In Outlook 2002, when creating an email I begin to enter an addressee and normally Outlook recognizes the name and pops the email address up there for me. Sometimes it will pop up...
  19. pro356

    How to correct wrong invoiced amount

    Invoice is entered and mailed. Month later payment comes and realize I underbilled. Can I correct the original invoice? Do I create a new dummy invoice for the difference? Do I use some debit memo to adjust this?
  20. pro356

    Lost Invoices

    I have about 20 invoices that were entered and printed. I know they printed as some of them have been paid. However, I am unable to find any of them when I do an inquiry by document # or in the smart list under Receivables Transactions. If I try to use that same invoice # again to re-enter the...

Part and Inventory Search

Back
Top