N
Naresh Kumar Saini
I use Access 2000 on Windows 98. My database consist of one Main table with
is linked by one-to-many relationship with four other tables. The main table
contains details of a transaction/bill and other tables each have record of
individual items of transaction/bill, discounts, taxes, etc.
(1) I use a Form with four SubForms for data entry. How can I copy a Record
(while in Main Form) and paste it at the end (so that a full Record in Main
Table along with related records in all four linked tables are copied). Or is
not possible?
(2) I print above information in a Report with four SubReports. I need to
print only one Record from Main table (along with related records in related
tables) because the report header/foote have total, etc for a record. I set
Filter property of Report to (e.g.) BillNumber=[Please type Bill Number to be
viewed/printed]. The Filter On property is set to Yes. It works for for a
session, but when I open the report next time, the Filter do not work. It is
missing from Report Property, though the Filter On property is still set to
Yes.
(3) While designing the database I discovered that SubForm and SubReport do
not display correct records (even if relationship is perfectly set) until the
linked field name of sub table is set to same as main table (e.g. MainID in
Main Table is linked to MainID field in sub table. Until I did so, the
SubForms and SubReport display 'all' the records rather than as expected. Is
it a limitation or I was doing some other mistake? It is working fine now.
PS: My Form and Report are based directly on Tables and not on Quries.
Perhaps it is a poor practice, but I did so when initially things were not
working corectly to rule out at least errors related to quries. All
calculations are done on Form and Report itself. Now I am thinking to
creating a Qurey and change the source of my Form and Report to these Quries.
Perhaps it will at least solve the Filter On problem!
Thanks for any help.
Naresh Kumar Saini
nksaini<at>gmaail<dot>com
is linked by one-to-many relationship with four other tables. The main table
contains details of a transaction/bill and other tables each have record of
individual items of transaction/bill, discounts, taxes, etc.
(1) I use a Form with four SubForms for data entry. How can I copy a Record
(while in Main Form) and paste it at the end (so that a full Record in Main
Table along with related records in all four linked tables are copied). Or is
not possible?
(2) I print above information in a Report with four SubReports. I need to
print only one Record from Main table (along with related records in related
tables) because the report header/foote have total, etc for a record. I set
Filter property of Report to (e.g.) BillNumber=[Please type Bill Number to be
viewed/printed]. The Filter On property is set to Yes. It works for for a
session, but when I open the report next time, the Filter do not work. It is
missing from Report Property, though the Filter On property is still set to
Yes.
(3) While designing the database I discovered that SubForm and SubReport do
not display correct records (even if relationship is perfectly set) until the
linked field name of sub table is set to same as main table (e.g. MainID in
Main Table is linked to MainID field in sub table. Until I did so, the
SubForms and SubReport display 'all' the records rather than as expected. Is
it a limitation or I was doing some other mistake? It is working fine now.
PS: My Form and Report are based directly on Tables and not on Quries.
Perhaps it is a poor practice, but I did so when initially things were not
working corectly to rule out at least errors related to quries. All
calculations are done on Form and Report itself. Now I am thinking to
creating a Qurey and change the source of my Form and Report to these Quries.
Perhaps it will at least solve the Filter On problem!
Thanks for any help.
Naresh Kumar Saini
nksaini<at>gmaail<dot>com