Please Help Me to solve this matter

  • Thread starter Thread starter lasithakamalpriya
  • Start date Start date
L

lasithakamalpriya

Please help me on this matter with Ms 2002

Figure 01

Date Invoice Number Grade Nett Weight(Kg)

15/11/2007 2 BOP1 500
15/11/2007 3 OP1 1000
15/11/2007 5 BOPSP 200
Cont: Cont: Cont: Cont:

In Figure 01 always I have to enter the date record by record. It is
wasting the time. In Ms Access 2002 Using Queries & form how can I
create an access table just like Figure 02.
If it is a form I want enter only the Date one time. Then that date
should be combined with all data in the database table.

Figure 02
____________________________________________
Date 15/11/2007
____________________________________________
Invoice Grade Nett Weight(Kg)
Number ____________________________________
2 BOP1 500
3 OP1 1000
5 BOPSP 200
Cont: Cont: Cont:

I tried too many times solve this problem but couldn't so please let
me to Know how I can do this With Ms Access 2002 or Newer version. How
I want to create Table, Quires & Form. And Please let me to know what
options I want to use.

Thank you
 
One option is to do your data entry via a form.

Create a control on the form for the date value such as dteDefaultDate in
the Form Header section.

Place your Date and other controls in the Form detail section. Set the
Default Value property of your Date control to =[dteDefaultDate] ....or what
ever you named the control in the header.

If you are normally entering data for the previous day, you could even set
the default value of the dteDefautlDate control to =Date() - 1 to have it
automatically set to the previous date.
 
Back
Top