OraFAQ Forum: Forms » Timesheet .. Need Help !

Home » Developer & Programmer » Forms » Timesheet .. Need Help ! (Win XP , Froms 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Timesheet .. Need Help ! [message #324815]

Wed, 04 June 2008 03:42

adilsami
Messages: 46
Registered: October 2007

Member

Hi There,

I'm working on a form called Time sheet, which will be used to
store the login_in & log_out time for the employees .

CREATE TABLE JOB_LOGIN
(
  JOB_NO         NUMBER,
  MECHANIC_NAME  VARCHAR2(100),
  MECHANIC_NO    NUMBER(15) NOT NULL,
  DAY            DATE,
  LOG_IN         DATE,
  LOG_OUT        DATE,
  ACTUAL_HOURS   NUMBER,
  OVERTIME       NUMBER
)

1. Sysdate displayed in DAY field :
(Initial value = $$DATE$$),(Format Mask = DD-MON-YYYY) .

2. For the Log_In time, it been displayed in Log_In field by setting the property of the field :
(Initial value = $$TIME$$),(Format Mask = HH24:MI)

The employee will enter (JOB_NO,MECHANIC_NAME,MECHANIC_NO)
and DAY,LOG_IN,LOG_OUT,DATE,ACTUAL_HOURS,OVERTIME will be
disabled for insertion from the employee (by setting the property (insert allowed= NO) .

NOW , first i want the LOG_IN time to be stored in when the employee enters his (JOB_NO,MECHANIC_NAME,MECHANIC_NO).

am bit stuck at this level that how make the employee store his LOG_OUT time , as i don't want him to type it . It should come from the machine time . And it doesn't store the LOG_IN time again as its been displayed all the time on the form .

PS: The FMB is attached.

Regards,
Adil.