Search results for query: *

I am importing a file into a microsoft access database that includes a unix timestamp which is in UTC (for example: 1066038603 = 10/13/2003 09:50). How can i convert this number into a date and time that can be recognized by microsoft access. Is there an access function that can convert this...

Here is my situation. I have dates for transactions that are stored in the db. These dates are in GMT (greenwich mean time) and i want to convert the dates to EST(eastern standard time) or EDT (easter daylight time) according to the date. If the date occurs in February, i want a query that...

Hi, I'm trying to select mulitple records from an XMLType file. Here is my code: SELECT report_date, EXTRACTVALUE(tr.trx_data , '/trx-report/body/line/external-id/text()') "External ID" FROM TRX_REPORT tr The error i get is: ORA-19025: EXTRACTVALUE returns value of only one node...

I have a text box on a form that I only want to be able to edit if a combo box has a certain value. Does anyone know how I can do this? Thanks for your help! -marc

I've created a report that is an asp page that uses vbscript. It pulls data off of a database and displays it in a table. I want to be able to run the report once and then allow users to access the html output intead of continuously pulling the same data off of the database. Is there a way...

I am wondering what other good software is out there that I can use as an alternative to Crystal Enterprise and/or Crystal Reports (i'm shopping around). I Need the software to be able to do the following: -Automatically generate reports for set times at least once a day (pulling data from an...

I need to be able to use crystal enterprise 8 to access excel versions of my reports. These reports must be in excel 8.0 format. Unfortunately, crystal enterprise 8 only gives the option to export to excel in 7.0 format. Does anyone know if and how I can export from Crystal Enterprise 8 in...

I have recently installed Crystal Enterprise 8 and CANNOT view reports through Crystal Enterprise, but CAN view the reports through Crystal Reports 8.5. I have both installed on the same computer. I am connecting to an Oracle Database using an ODBC connection (system DSN). When I try to view...