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: amrog
  • Content: Threads
  • Order by date
  1. amrog

    Excel 2007 - Subtotals for data from MSQuery

    I am using Excel 2007. I use MSQuery to connect using ODBC to an Oracle server and get data into table. I am trying to use subtotals, but it seems not working with data from table!! Can anyone support how to overcome this issue or use a VB macro to dynamicly calculates subtotals as table is...
  2. amrog

    HELP --- Workbook sharing with MSQUERY - ODBC connections

    Is there any possibilities to share a workbook that contains sheets with data retrieved and updated from external ODBS sources? Is there any workaround, special add-ins, 3rd-party tools or other Microsoft solutions?
  3. amrog

    Bluetooth not working with Nokia PC Suite

    I had VISTA 32 on my DELL latitude D520 and recently installed Vista SP1 and Nokia PC Suite 6.86.9.3. Suddenly, my bluetooth connection with my Nokia mobile N70 is no more working. I think this is mainly due to the VISTA and not due to the PC Suite. This is because the Bluetooth icon start in...
  4. amrog

    How to Bypass VISTA Windows Update managed by Domain Administrator

    I have recently joined my company domain. The domain administrator has set the group policy to make windows update managed by system administrator by default. How to make the default windows update being through online update rather than the domain update?
  5. amrog

    Outlook 2007 HTTP connectivity with Exchange 2007

    I need to use my Outlook 2007 to send/receive emails using the http connectivity with Exchange 2007. This is done inside my company, and am able to use Iexplorer to login to my inbox from outside the company. Now, I need to do this using my Outlook 2007. My company admin does not provide my any...
  6. amrog

    Extract date range from one date column

    I have a table with the following data: Code Effective_date A 1/1/2008 A 1/2/2008 A 15/5/2008 B 1/1/2008 B 15/2/2008 C 1/2/2008 C 1/4/2008 I need to get the following output: Code Effective_1 Effective_2 A 1/1/2008 31/1/2008 A...
  7. amrog

    Boot OS Drive not shown in Explorer

    I am using VISTA business SP1 on Dell Latitude D520. I just joined a new Domain in my company network. After this recent join, I am not able to find my boot system drive C in explorer or my computer. However, when I write C:\ and press enter, It displays. Has anyone any idea how to be able to...
  8. amrog

    Sum within table with column and row conditions

    I have a sheet with the following data: A B C D E F G H M 1 Code Jan Feb Mar Apr May Jun Jul ------- Dec 2 A 10 11 1 5 9 3 10 8 3 B 4 2 33 9 1 0 12 4 4 C 5 D...
  9. amrog

    Excel - How to create dynamic range based on column content

    Can experts help? I have a 2 columns; A containing product_id and B containing item_id. Each row contains the product_id and one of its item_id. Suppose rows are sorted so that all product_id, item_id are ordered by product_id. I need to construct a row range for each product_id; that is for...

Part and Inventory Search

Back
Top