M
MOE Ken
Where can I get a library or document management template? I have checked
the MS template downloads, but nothing seems to match...
the MS template downloads, but nothing seems to match...
R
rico
could try:
http://www.mvps.org/access/resources/downloads.htm
they have many databases to download, not sure if any would be exactly what
you want but a good way of seeing how things are done.
enrico
http://www.mvps.org/access/resources/downloads.htm
they have many databases to download, not sure if any would be exactly what
you want but a good way of seeing how things are done.
enrico
F
Fred Boer
Dear MOEKen:
Just to be sure, have you seen the Book Collection template?
http://office.microsoft.com/en-us/templates/CT011366831033.aspx
Assuming you have, what types of features are you looking for that the
template doesn't provide? Are you working with a small, medium, or large
scale library? Is it a personal collection or business or public library?
Will you need circulation management capabilities? An online catalogue? A
bit more information might make it easier to give you a useful answer!
Cheers
Fred Boer
Just to be sure, have you seen the Book Collection template?
http://office.microsoft.com/en-us/templates/CT011366831033.aspx
Assuming you have, what types of features are you looking for that the
template doesn't provide? Are you working with a small, medium, or large
scale library? Is it a personal collection or business or public library?
Will you need circulation management capabilities? An online catalogue? A
bit more information might make it easier to give you a useful answer!
Cheers
Fred Boer
M
MOE Ken
Fred,
Thanks. The dbase is OK, but I need more fields, such as a description of
the binding, reference source lists data, content colour, etc. I doubt there
is a template...
K
Thanks. The dbase is OK, but I need more fields, such as a description of
the binding, reference source lists data, content colour, etc. I doubt there
is a template...
K
F
Fred Boer
You can, of course, add fields to the tables used by the template, but I
agree, the template is quite basic. I have developed an Access-based library
system for a small school library, so it is an area that interests me.
However, if I could offer some unsolicited advice: you would be wise to do
some research before tackling the creation of a library system from scratch.
There are many, many, (many!) professional library systems available, some
of them very reasonably priced. Developing your own system from scratch
might take far more time (and of course, money!), than buying a package.
Good luck!
Fred
agree, the template is quite basic. I have developed an Access-based library
system for a small school library, so it is an area that interests me.
However, if I could offer some unsolicited advice: you would be wise to do
some research before tackling the creation of a library system from scratch.
There are many, many, (many!) professional library systems available, some
of them very reasonably priced. Developing your own system from scratch
might take far more time (and of course, money!), than buying a package.
Good luck!
Fred
S
samuel
any chance you would share your database? =)
Fred Boer said:
F
Fred Boer
Dear samuel:
I wish I could. Unfortunately that isn't possible. Have you had any luck
with researching existing packages? Are you still thinking of creating your
own?
Cheers!
Fred
I wish I could. Unfortunately that isn't possible. Have you had any luck
with researching existing packages? Are you still thinking of creating your
own?
Cheers!
Fred
S
samuel
yes, i've created one, however, i can't get my combo boxes to show the
correct data.
if you had the time, could you take a look at my database ?
correct data.
if you had the time, could you take a look at my database ?
F
Fred Boer
Well, perhaps we could start here in the newsgroup, and see how we progress!
Please explain more about "showing the correct data"... Does this mean that
the contents of the combobox are incorrect, or that the results of choosing
an item in the combobox aren't what you expect? What is displayed in the
combobox? What do you *want* to happen after you've chosen a combobox item?
What *does* actually happen?
Cheers!
Fred
Please explain more about "showing the correct data"... Does this mean that
the contents of the combobox are incorrect, or that the results of choosing
an item in the combobox aren't what you expect? What is displayed in the
combobox? What do you *want* to happen after you've chosen a combobox item?
What *does* actually happen?
Cheers!
Fred
S
samuel
that's a great idea.
i have a master table "books" which contains every field within the database.
i have a form i want to use to record, whether or not i have read a certain
book, and then record notes from the book into the master table.
the form is called "check out a book" . i have a combo box that i want to
display the title from the tbl books. when i select the title, i want the
field ([author] [category], etc from the books table) fields displayed within
the form.
i'm totally lost.
i have a master table "books" which contains every field within the database.
i have a form i want to use to record, whether or not i have read a certain
book, and then record notes from the book into the master table.
the form is called "check out a book" . i have a combo box that i want to
display the title from the tbl books. when i select the title, i want the
field ([author] [category], etc from the books table) fields displayed within
the form.
i'm totally lost.
F
Fred Boer
Dear samuel:
First of all, if you have one table which contains every field in the
database, there is a strong possibility that your database could benefit
from normalization. There is a ton of information on normalization here:
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html#DatabaseDesign101
Normalization has to do with creating the appropriate tables and
relationships to effectively manage your data. It would be a really good
idea to make sure you have spent time learning about normalization, since an
improperly normalized database can really cause headaches.
Now, as far as your specific question goes, you should be able to create a
combobox that does what you need.
You need a form which is based on the "books" table, (or better, a form
based on a query of the "books" table).
The form wizard can generate a nice form for you.
When you have a form, add a combobox to the form.
Use the combobox wizard. It offers you a choice to "Find a record on the
form...". Select this option.
The wizard will create a combobox that you can use to select a title, and
then the information about that title will fill the form.
If you have trouble with this, post back!
Cheers!
Fred
First of all, if you have one table which contains every field in the
database, there is a strong possibility that your database could benefit
from normalization. There is a ton of information on normalization here:
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html#DatabaseDesign101
Normalization has to do with creating the appropriate tables and
relationships to effectively manage your data. It would be a really good
idea to make sure you have spent time learning about normalization, since an
improperly normalized database can really cause headaches.
Now, as far as your specific question goes, you should be able to create a
combobox that does what you need.
You need a form which is based on the "books" table, (or better, a form
based on a query of the "books" table).
The form wizard can generate a nice form for you.
When you have a form, add a combobox to the form.
Use the combobox wizard. It offers you a choice to "Find a record on the
form...". Select this option.
The wizard will create a combobox that you can use to select a title, and
then the information about that title will fill the form.
If you have trouble with this, post back!
Cheers!
Fred
that's a great idea.
i have a master table "books" which contains every field within the
database.
i have a form i want to use to record, whether or not i have read a
certain
book, and then record notes from the book into the master table.
the form is called "check out a book" . i have a combo box that i want to
display the title from the tbl books. when i select the title, i want the
field ([author] [category], etc from the books table) fields displayed
within
the form.
i'm totally lost.
Fred Boer said:Well, perhaps we could start here in the newsgroup, and see how we
progress!
Please explain more about "showing the correct data"... Does this mean
that
the contents of the combobox are incorrect, or that the results of
choosing
an item in the combobox aren't what you expect? What is displayed in the
combobox? What do you *want* to happen after you've chosen a combobox
item?
What *does* actually happen?
Cheers!
Fred