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

    Default Value of SYSDATE in a Date field throws error

    Hello I am inserting data into a table and have a ROW_ADD_TMS column that is set in the table to default at the sysdate. When I attempt to insert data, this field throws the following error: ORA-01840: input value not long enough for date format When I try take the default value off of the...
  2. Shatneriffic

    SaveCopyAs Path

    Hello I'm trying to use VB.NET to save an open spreadsheet to a network drive and am receiving errors when run the code. Here's the line where the problem exists. excelWorkbook.SaveCopyAs("//wsent01ts/callgrp/reports/Accts 120 ME.xls"); I can save it manually to this path...
  3. Shatneriffic

    Excel Pivot Table Datasource Change

    Hello We have a development and production regions for our oracle environment that support reporting in Excel pivot tables. How do we point our pivot tables in the development schema to the production schema without having to rebuild them from scratch? Thanks!
  4. Shatneriffic

    Automatically Refresh and Publish Spreadsheet

    Hello We have an app that opens, refreshes and publishes a ton of Excel spreadsheets with pivot tables to a web folder. Most of the spreadsheets update fine. However, one just keeps being published with the data from the exact same date everyday. Below is the code. Section 1 is an example of...

Part and Inventory Search

Back
Top