Please Help Me to solve this matter
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
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
.
Relevant Pages
- Re: A pk is *both* a physical and a logical object.
... indivdual at some database values. ... I repeat, what does it matter? ... significantly limits the expressiveness of the model, ... expressions that can be used to denote individuals, ...
(comp.databases.theory) - Re: Access is just to hard to understand
... "No matter what the database was required to do". ... >> Your Resource For Help With Access, Excel And Word Applications ... we'll be done for extortion. ...
(microsoft.public.access.gettingstarted) - Re: Updated Primary Key (Identity) Value
... I'm getting the same results when using OleDb and an MS Access database file. ... The first record added to a table returns 0 as the primary key value when the primary key field is an auto-incremented one. ... INSERT INTO Matter file_no, date_created, date_modified VALUES(@file_no, ... In order to get this to work with SQL Server, you also have to add code that looks like this to add an event handler for the row updated event of the underlying data adapter. ...
(microsoft.public.dotnet.framework.adonet) - Re: walking a directory with very many files
... all .jpg files between 40 and 250KB with the path stored in a ... Why not put the images themselves into database fields? ... on modern filesystems it doesn't matter whether you accessing ... that's not the case with filesystems like FreeBSD ufs2 (at least ...
(comp.lang.python) - Re: Posting to another page attribute: PostTargetUrl
... In .NET it is a simple matter to respond to the OnClick event, ... data from simple server controls and store in the database. ... >> context, saving to a temporary table in the database between each page, ...
(microsoft.public.dotnet.general) |
|
