Library Management Database
May 8, 2007I’m looking for a Microsoft Access Database that is for library Management.
Any help or directions where I can get help would be great.
BR,
Fahad
ADVERTISEMENT
Library Database Help
Dec 27, 2005Hi. Newbie questions here...
1) I am making a library database. I created a simple query to identify books on loan.
I need a form to browse all books, not just the unavailible books.
However it needs to show that the book is unavailible/onloan (like my query identifies), perhaps by changing the colour to red or an "on loan" tickbox,
How do I achieve this?
2) How do I run some code on startup?
I found code to change the main background colour, but I don't want to assign a button to do it
I did search about but couldnt find the answer.
Cheers.
Help On Library Database
Apr 4, 2007Hi there! I haven't done any work on MS Access for some while now and I would like some help, to get back into things I want to do a library database system. I would like to have a table for 'customer' and 'books' and 'books out on loan'My idea for tables so far are:Customer{ CustomerNo - autonumber(PK) First Name - Text Second Name -Text Surname - Text HouseName - Text Street - Text County - Text Postcode - Text Phone - Number E-mail - Text}Books{ ISBN - Number(PK) Title - Text Author - Text On_Loan - Yes/No}On_Loan{ ISBN - Number(FK) Title - Text(FK) CustomerNo - Autonumber(FK) Date_Out - Date/Time Date_In - Date/Time(PK) Fine - Currency}Do these tables look ok?I'm know how to make these tables, but the forms and querys are a bit foreign to me after having time away from access, could anyone please advice me on how to go about this or show me examples of how to do this in access? I want all books taken out have an automatic 7 day renewal date from the current day! and all out standing books on loan to be printed off in a mail merge. Fine in table On_loan should be the cost of x amount after each day over the renew date. so if its 20p per day then after 3 days fine would be 60pAnd a page to add new customers/books.:)
View 5 Replies View RelatedAnother Library Database
Feb 28, 2005Hello,
I'm trying to set up a database for a library but I'm having a lot of difficulties and I'd be very greatful of any help. Well my main problem is the loaning and returning of books (which is a pretty big problem considering...). Anyway I can't figure out a way of having multiple orders (a maximum of 3 books at a time) and then being able to update tables for when the books loaned out and returned. Then another problem is how fines would work, ie [('returndate'-'datedue')*whatever] but how would this actually be displayed and used. I apologise for not really explaining myself well, but here is what my tables and relationships look like (which I think maybe where my problems are starting):
http://homepage.ntlworld.com/k.mcareavey/Database/relationships.bmp
and the actual database:
http://homepage.ntlworld.com/k.mcareavey/Database/Monro%20Library%20Version%202.zip
One last thing - I had a look at some of sample library databases but I the only one that did really what I wanted used to much VBA and I couldn't really figure out how it worked. Thanks a lot for any help.
School Management Database
Apr 10, 2006Hi Forum,
I am trying to create a access database system which will show classes, students, attendance, progress report, teachers, departments etc...
i have repeatedly failed in accomplishing this database as i dont have the knowledge.
the place that i get messed up is for example the attendance, i want it so that i can select a date and then all the students associated with that class showup. so 1 date and a list of student only on that class.
another problem was adding a progress report for every class and individual students.
this is for a community based school which teachings on saturdays, there are over 15 volunters who do not get paid to teach but are still willing to give something back to the society.
i beg you guys out there, you all are geniuses!!! please help us design this simple system. please if somebody already knows where i can get a system like this free of charge then let me know ASAP!
I would like to thankyou in advance for reading thins messge.
Daycare Management Database
Dec 17, 2007Hi all, does any one one have or knows of a daycare attendance tracking and management database. We are a non profit org. Action for children out of Columbus, Ohio.
Thank you in advance for your cooperation.
Ronny Medina
Ronnymedina@actionforchildren.org
614-224-0222 ext 163
Contact Management Database NEED HELP
Oct 30, 2006Hi,
I'm new to this forum so if I ask something stupid please forgive :)
I want to do something like the contact management database which is offered by microsoft for download.
I played a little with it and my problem is I copy-pasted the "calls" tab and on the pasted tab when I browse throug the different calls the call notes field below wont change / update. I thought there is maybe a macro behind it but I looked at every macro and did not find anything appropriate in my opinion.
It is maybe only a minor but I can not figure it out,
Thanks for any help in advance,
Leslie
PS.: I uploaded the database to rapidshare : http://rapidshare.com/files/1305209/Contact_management_database.mdb
Contract Management Database
Dec 11, 2006Hi all,
I need your help.
I am in process of designing a Contract Management database.
I have three tables
The first one is Contracts Details table, with these columns:
Contract ID, Contract Name, Vendor ID, Vendor Name, Start Date, End Date, Type, and Description.
The second table is Vendors table, with these columns:
Vendor ID, and Vendor Name.
The third table is VendorContact table, with these columns:
Vendor ID, Contact Person, Phone, Mobile, Fax, Email, and id.
I want you to help me to construct the relations?
Kindly, see the attached database.
Help With Incident Management Database
Feb 18, 2008Hello,
I am a newbie,
I am create Incident Management Database for our office.
I have sorted relationships & a form in the database but i need more help with a form.
The main table in the database is INCIDENT and there are lots of lookups and 3 tables with one to many relationships.
Now in my database, i must save the Incident entry first and only then i can add info in witness table. Is there any way that the data about the incident gets saved as soon as users try to enter witness info regarding that incident?
Please see attached two images to get better idea.
Any help is appreciated.
See the link below (copy n paste in web browser)
docs.google.com/Doc?id=df4ks7hh_21gxccsng4
Property Management Database Needed!!!
Mar 14, 2006I am looking for a database that can keep up with the full management issues relating to single family houses. Some are on a lease. Some are on owner-financed by use. Any help would be great!
I am willing to pay a designer to program this database for me. Email any samples or questions to babyfacedavid@yahoo.com
Regards,
David
Help With Clothing Order Management Database
Jun 12, 2007Hi,
I am trying to design and build an orders management database for a clothing wholesaler.
Has anyone got any ideas on what entities i should have.
I thought:
Clients (Customer Details)
Orders (Inc. order date, ship via etc)
Order Details (sizes, quantity of orders per size)
Product Details (Product Code, colour, size, stock numbers per size)
Catergories (Shorts, Jackets, Jeans etc)
Suppliers (Supplier Information)
Delivery (Delivery Method etc)
However, loads of problems when i come to planning the sizes part. I have different product catergories with different sizes
And when i do the order details table, i need to enter order quantities for each different size for one clothing unit.
Any ideas?
I would also ideally want to link the order details and products tables by the product code number. I.e. When filling out an order In the order details table i want to type in the product code then have information from the product table automatcially fill in the gaps in the order details table, such as unit price, colour etc.
Hope you understand and can help me!!!
Thanks for your time
J
Modules & VBA :: Setting Up Database Library File
Jul 28, 2013I am using Access 2010.
I want to set up a Library File containing code that I can call from numerous access databases.
I try to make reference to the newly created Library.accdb file in Tools - References and get the error message: Name conflicts with existing module, project or object library.
I have checked the names of all of these and there does not appear to be a conflict.
Patient Management Database, Help Needed For Tables And Relationships
Jan 16, 2008Hi,
I am new to this post. I am a physician with interest in database designing. I have been trying to design a database for my clinic for few months but am unable to make one. I have been searching/ reading alot of info and came across this thread. Maybe someone can help me.
Actually, I want to make a database regarding ultrsound scan examinations of patients.
I have five tables.
1. Patients. (patinetid*, patientname, age, sex, address, contact no)
2. Physicians. (physicianid*, physicianname, speciality, address, contact no)
3. Scans. (Scanid*, scanname, charges)
4. Scan orders.(scanorderid*, patientid*, physicianid, scanordernumber, scandiscount, totalcharges)
5. Scanorder details.(scanorderdetailid*, scanorderid, scanid, charges, discount)
I want to have primary key for scanordernumber which wil be the patient number and should this be placed in patient table??
All the ids have been linked with one to many reltionships. Actually I am unable to set proper relationship.
So when the patient arrives he is registered with a unique number, a physian name with date added and scan ordered is entered. Sum calculated. I have done the later part with the form all designed but the relationships and primary key are all messed up.
I can post an image of relationships or blank database.
Kindly advise. Thanks in advance.
List Management
Nov 4, 2006Hello - I have a list of approx. 500,000 numbers and want to:
1) Highlight any duplicates
2) Test one list against another for common numbers
Can anyone suggest how this can be done in Access?
Thanks,
Cameron
Project Management
Dec 1, 2006I have over the last few months been building my own Project management system.This is based around A Phase task principle but the phases and tasks are used to create an estimate for a project depending on how much time is assigned to each Task.The system can use multiply Estimates with different billing codes plus their is a billing code system where billing can be done by a default list of codes (Rates 1-5) Or assigned rates for a client.I'm not after any money for it and will make it available to members hear.If anybody want to look at it and maybe make suggestions on improvements or let me know of any errors that would be greatIt would be an mde with an mdb back end.You should be able to update the back end that I don't think will be a problem LOL When it comes to new versions.As I said I don't want ANYTHING For you using it but would be nice to get it working better.mickp.s Ill Post some pictures if ya want. And It is a work in progress?Please use this topic from now on http://www.access-programmers.co.uk/forums/showthread.php?t=121117 this is where the beta 1 downloads available from.
View 14 Replies View RelatedDuplicates Management
Nov 10, 2005I get this from a query
date___ name
1_______1
2_______1
3_______2
4_______3
5_______4
6_______4
field date is unique while field name has
what can i do to get the following such that there are no duplicates for
the name field
_________________________________________________
| name | date1 | date2 | date3 | date4 | date5 | date6 |
-------------------------------------------------------|
|1 ____|1 ____ |2 ____| ____ | ______| ______| _____|
|------------------------------------------------------|
|2 ____| _____ | _____|3 ___ | ______| ______| _____|
|------------------------------------------------------|
|3 ____| _____ | _____| ____ |4 ______| _____| _____|
|------------------------------------------------------|
|4 ____| _____ | _____| ____ | _______|5 ____|6 ____|
|------------------------------------------------------|
Best Regards
manolo
Date Management
Feb 21, 2005Hi
i have 2 fields
order date and delivery date using a calender operation
does anyone know how to make it so that the delivery date cannot be sellected on a date before the order date?
cheers
kev
Code Library .Net
May 28, 2005I ran into this the other day and thought that I would post it here if anyone is interested.
CodeLib is an application that helps you to easily find and information gathering.
Support Notes, Code, Files, Pictures, Web, URL save. 6 in 1 Utility.
A database for all your information.
* A Personal information manager (PIM).
* A Knowledge manager (KMS).
* A Document manager (DMS).
* A Bookmark manager.
* A Pictures manager.
* A Notes manager.
* A Code manager.
* A Files manager.
* A Web manager.
* A Blog Writer.
* ... and much more
Screenshot: Here (http://codelib.threeus.com/Manual/images/Snap90.gif)
Video:Here (http://codelib.threeus.com/Demo.htm)
News source:Here (http://codelib.threeus.com/)
Download free version for Access/Firebird/MySQL/MSSQL:Here (http://codelib.threeus.com/Manual/DownOld.htm)
There is a shareware version for $39.
I have always wanted one of these and free is a very good price and if you want more functionality, there is the shareware version.
Enjoy.
MSDN Library
Jun 13, 2005Is it possible to download the MSDN Library from the Net from offline viewing ?
Cheers,
Library Dependency
Nov 29, 2005Hi
Apologies, if something similar has been posted.
I have created a databse, that handles, names,addresses, items bought, and so on.
Because of this, the database uses the internal variable Date().
I recently fitted a new hard drive, and when I came to run the database, to print out addresses, it complained that a missing DLL (Iaiexplore.dll) was needed. I clicked OK, and every field or line of code that uses the Date() variable no-longer works without this DLL. Which is off because this particular DLL belonfs to the Intervideo WinDVD player!
My database handles a lot of things, but it doesn't play DVD's!
If I create a new database, the Date() variable works, it juswt doesn't work in mine without that DVD player being installed.
This has baffled me.
I did have this app installed, but I switched to another DVD player, after fitting the new Hardrive.
For one-reason-or-another my database has a dependency for this DLL, and the Date() string won't work without it. And this of course, has a knock-on effect of stopping something else from working.
I went to Macros/Tools/References, and removed it from there, but it still didn't cure the Date() problem. Although it didn't ask for this DLL again.
I cured it the last time by re-installing the DVD player, but this is ridiculous, and seems overkill.
Thanks
Missing Library
Dec 20, 2006Hi,
i've developed a program in access 2003, but now i'm on access 2000 and seems that one / more library is/are missing..
i've this part of code
Private Sub List0_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
Dim strOrd As String, strSql As String
If Button = 1 Then
If Y <= 225 Then
If Right$(List0.RowSource, 5) = " Asc;" Then
strOrd = " Desc;"
Else
strOrd = " Asc;"
End If
strSql = "SELECT cliente.CLI_ID, cliente.CLI_TITOLO, cliente.Cognome, cliente.Nome, cliente.Indirizzo, cliente.Cap, cliente.[Citta'], cliente.Regione, cliente.Nazione, cliente.CLI_SOCIO FROM cliente WHERE (((cliente.CLI_SOCIO)=Yes)) ORDER BY "
Select Case X
and this is the screen with the libraries currently installed ..
http://img246.imageshack.us/img246/7383/libreriaum5.th.jpg (http://img246.imageshack.us/my.php?image=libreriaum5.jpg)
i was wondering which one is missing....i'm quite far from my laptop right now..
thanks in advance
bye
DAO Object Library - Not Sure What It Is
Feb 16, 2008Hi,
I've downloaded a database which creates cascading combo boxes; it's called CreateCascadeCombo, for which I am grateful to whoever took the trouble to create it.
However, after it has done it's work and vreates the form in my own datbase, it says to make sure the latest DAO Object library must exist in the same database. How do I ensure that is is? I'm using access 2003.
Budget Management Program
Oct 12, 2005I'm just wondering if anyone has made a very advanced budget management program using just access?? I tried to make one for myself but I just want it to advanced for my little knowledge of access. I would love to be able to keep track of all my expenses including everything bought from groceries to hair cuts. I would love to be able to take my receipt from walmart and enter everything bought and the price for each item. Then I would love to be able to at anytime search for soap and thing with soap in the Item name will be displayed with the location and the date and price. This way I can keep track not just what I spend on groceries but what I spend on mountain dew or what i spend on hamburger in a given time. This is just way to complicated for me! I hope someone can help me out here maybe give me a shell and let me try to fill in certain parts or if someone already has one that works kind of like this maybe i could just change a few things to the way i want it! I really appreciate this!!
Bass
Order Management System
Jul 29, 2006I have little experience using Microsoft Access, but am attempting to create an order management system.
I have designed a system to store customer details and allow the entry of orders. I now want to develop this so that the system can handle delivery notes.
There are currently two tables for order information, since each order can consist of multiple items. So, general information, like the order date, order number and salesperson are stored in an orders table. A second table, Order Detail lists the items and item specific information along with the order number of which they are a part.
A whole order (i.e. all items assigned to one order number) may be delivered at once, or in smaller consignments. However, every consignment must have a delivery note with a unique number. So, there may be several delivery note numbers associated with each order, relating to different shipments.
I therefore need to create a system which allows the user to select which items from an order are being dispatched and then get Access to do the following:
Create a new record in the delivery notes table. The delivery note number will therefore be created (it's an autonumber). The user should be prompted to enter the delivery date and this should be stored in the date column of the delivery notes table, alongside the delivery note number.
Enter the delivery note number in the "Delivery Note Number" field of the Order Details table, for every item that the user selected as dispatching.
Once this is in place, I will then be able to pull all the required details together with a query and then print the delivery note.
Bearing in mind that I'm very new to Access and so don't have any knowledge of scripts/macros etc, can anyone tell me how I can achieve this?
Many thanks in advance,
Gary
Linked Table Management
Jan 24, 2005Does anyone know if it possible to create a command button, which when pressed has an event procedure to bring up the linked table manager window?
Am not sure what code i would need to place in the event "on click" property of the button?
Employees Leave Management
Nov 2, 2005Hai guys Iam looking out for a sample DB for employees leave management.
# With leave application form
# Leave approval form
# Leave status
# All with username and password
Kindly help me out.