Thank you again for your respond.l have failed to log in for two days
because
of the weak server.My project is about School Centre Information and its
specific to build the information about the library and the school l
choose
never have any system before. Me also , have never look or see any library
system .
My first step are
a) To build a table
1. Book's information
(book.s name, author, publisher, price,refrence number,ISBN number,
categories,date of received)
2.Borrowing book's record for student
(name,class,book's name,author,date of borrowing, date of returning,fine)
3.Borrowing record for teachers)
(name,book's name,total,date of borrowing,date of returning)
4.record of tools teaching method
(name,total,date of accepted,Resource,publisher)
5.Record of tools not including books
(name, total,refrence number,borrowed to,date of borrow,date of return)
6.Record of student fine
(name,class,date,amount,prefect name,book's name
7.Record for using library
(teacher's name, class, time,reason)
8.Record for using tools teaching method1. Book's information
(book.s name, author, publisher, price,refrence number,ISBN number,
categories,date of received)
b) quiries
1. Book's information
(book.s name, author, publisher, price,refrence number,ISBN number,
categories,date of received)
parameter;books name
2.Borrowing book's record for student
(name,class,book's name,author,date of borrowing, date of returning,fine)
parameter;book's name
3.Borrowing record for teachers)
(name,book's name,total,date of borrowing,date of returning)
parameter; teacher's name
4.record of tools teaching method
(name,total,date of accepted,Resource,publisher)
parameter; tool's name
5.Record of tools not including books
(name, total,refrence number,borrowed to,date of borrow,date of return)
tool's name
6.Record of student fine
(name,class,date,amount,prefect name,book's name)
parameter; name
7.Record for using library
(teacher's name, class, time,reason)
parameter;class
8.Record for using tools teaching method
(teacher's name, tool's name, date of borrowing, date of returning)
parameter; tool's name
c . reports
1.Reports Book's
( name, author, publisher, price,refrence number,ISBN number,
categories,date of received)
2.report of Borrowing book's record for student
(name,class,book's name,author,date of borrowing)
3.report of Borrowing record for teachers
(name,book's name,total,date of borrowing,date of returning)
4.report record of tools teaching method
(name,total,date of accepted,Resource,publisher)
5.report Record of tools not including books
(name, total,refrence number,borrowed to,date of borrow,date of return)
6.report Record of student fine
(name,class,date,amount,prefect name,book's name
7.report Record for using library
(teacher's name, class, time,reason)
8.report Record for using tools teaching method
(book.s name, author, publisher, price,refrence number,ISBN number,
categories,date of received)
d. my forms are
i. 8 forms for insert data based to my table
ii.8 forms for my quiries based to my quiries
iii.8 forms for my report based to my report
So, from all above l would like to build 3 buttons to open my quiries
Duane Hookom said:
We don't have much information about your system such as tables, forms,
reports, queries (other than how many which means little).
What are you attempting to do with your application? What types of
information are you storing? How do you want to report the information?
--
Duane Hookom
MS Access MVP
is it necessary to build macro for all my forms or l group them for
three
groups like one group for insert data ,one group for quieres and one
group
for report .
:
firstly , thank you so much for your great help . l think thats my
problem.
l failed to compile my module maybe l dont know how to do it or l
dont
understand how it works. l also need the example that the suitable
coding
to
run my module.Kindly speaking,l have to finish my project to fulfill
the
requirement for my degree. For your information l have 24 forms not 16
forms
. 8 forms to insert data, 8 forms for quieries and 8 forms for
reports.
:
Do any wizards work? Do your modules compile? If your wizards don't
work,
check this KB article
http://support.microsoft.com/?id=303769.
--
Duane Hookom
MS Access MVP
This is the error that l was found when l create button and l dont
understand
what it mean.
Compile error in query expression.
'ApploadString([bw_tblBtnActions].[Description])'
Thanks for your help
:
l have 16 forms , there are forms to insert data ,query data
and
report
data. So ,from that l would like to build 3 button. The problem
is l
failed
to build it and the message send to me was "no module was found".
l
also
try
from macro but it doesn't work.So , l need help because this is
my
problem
since a month. Thank you for your help.
