Recent content by jodo

I missed that inital CDate on the original post, but it was in there. It still doesn't work. I've been running this application since 2003 and haven't had any issues until a couple of months ago when the users were pulling data when the jobs on the server were running. Any other suggestions...

I have a query that pulls data from a table that has 5.7 million rows. The query has a date field (DTM) among several other fields that I pull. The DTM field has a criteria string that looks like this: Between [forms]![frmMain]![StartDate] And CDate([forms]![frmMain]![FeederEndDate]) It is...

EVENTLOG TABLE CREATE STATEMENT ------- Generated by SYS.DBMS_METADATA on 3/25/2008 at 10:00:45 AM ------- CREATE TABLE "LAKEMS"."EVENTLOG" ( "UTCTIME" DATE, "POINTNAME" VARCHAR2(25 CHAR), "POINTTYPE" NUMBER(*,0), "POINTNUMBER" NUMBER(*,0), "STATIONNAME" VARCHAR2(30 CHAR)...

It fires when an entry is made into the eventlog table. The eventlog receives its entries from many different events in the field. However, my trigger only captures breaker operations. The trigger is fired after an INSERT into the eventlog table for each row. Yes, this is a SCADA system. I...

I have a trigger below. It fires when an event occurs and an entry is made into the eventlog table. However, it seems that when the event happens in the same second, say a breaker TRIPS CLOSES and TRIPS all in the same second, only the first TRIP causes the trigger to fire. Looks like the...

BlueHorizon, Thanks for the response, but I've tried changing the conversion settings and it didn't work. jodo

A style I created called Main Topics. This style is applied to both the FORMS and REPORTS label. Thanks. jodom LUCK - WHERE PREPARATION MEETS OPPORTUNITY!!

Samaba, Word 2003 and Adobe 7 Professional. Once I was satisfied with the document in Word, I clicked the "Convert to Adboe PDF" button on the Toolbar. On my first response, I forgot to check the change converstion settings. I'v since corrected that. Now I have Main Topics as a bookmark and...

Samaba, thanks for your reply. I did what you said. I created a Style called MainTopics and formatted to my liking, I did the Paragragh, Outline Level and selected level one. I applied it to 3 places. My TOC in Word looks fine, but on conversion to adobe, it acted like it didn't even...

Using Word 2003 and Adobe 7 Professional. I have written an application and want to create a help guide for the users. I want the words FORMS and REPORTS to be main headings in the Table of Contents in Word. They both have several subheadings. I've done this part and it works correctly. When I...

Aubs I was having the same issue that Carina was having. Your suggestion Try "un-ticking" the option "Windows in Taskbar" found in Tools-->Options-->"View Tab" worked. Thanks jodom LUCK - WHERE PREPARATION MEETS OPPORTUNITY!!

I'm studying to take the IZO-007 exam. However, I originally had the Oracle OCP Introduction to Oracle 9i: SQL Exam Guide, but it had a lot of obvious mistakes. Now, I've purchased the OCA/OCP Introduction to 9i SQL Study Guide by Sybex and this book has mistakes also, but it seems so much...

foolio12, I used this whole format and it worked. Thanks for your help. =Format(CDate(CDbl(DateDiff("n",[FIRST_TC],[COMPLETE]))/(60*24)),"Short Time") jodom LUCK - WHERE PREPARATION MEETS OPPORTUNITY!!

foolio12, DURATION is a created field in the record source of the report that looks like this (DURATION: DateDiff("n",[FIRST_TC],[COMPLETE])). This way, I can just use DURATION on the report instead of typing in the whole thing. I tried, using your suggestion...

I have a database that is being converted to XP. I have a field on a report that is called DURATION. DURATION is the difference between COMPLETE and FIRST_TC in minutes. In ACCESS 97, on the report I formatted the field to (=Format([DURATION],"hh:nn")). This forces the minutes to be converted...