School Library System

Dec 8, 2004

Hey guys,

I am designing a library system for an A2 project and i was just wondering if i could have a validation rule to prevent a copy from bieng borrowed if there was allready a record for a book in the database with no value for returned field. (meaning it hasnt been returned and its currently out) Im pretty noobie at access

LOAN__PUPIL_COPY___BORROWED_____Returned
100001 1001 10001 17 November 2004
100002 1002 10002 20 November 2004
100003 1003 10003 17 November 2004
100004 1004 10004 18 November 2004
100005 1005 10005 20 November 2004
100006 1006 10006 20 November 2004
100007 1007 10007 20 November 2004
100008 1008 10008 20 November 2004
100009 1009 10009 20 November 2004
100010 1010 10010 20 November 2004

This is how it looks at the moment. Im not sure where you would add a validation rule. The records in this table will be kept, and when a book is returned a date is added to the returned field. MANY thanks for anyones input, ive been brain storming it for weeks but i dont think i can do it without any code of some some sort.

Fenny

View Replies


ADVERTISEMENT

Tables :: Primary Web Based Inventory System - Update Raw Data From Another System

Mar 13, 2014

I have our primary web based inventory system that I am exporting to Excel and using this as an import to Access for the main raw data for my database. This being inventory it changes daily so I am updating this table every day. When I try to append the table it ads all the records. I am wanting an easy way to add only the new records/take out the ones that are no longer there. Basically update the table with what is currently there.The only have I have found to do this is by running non-matching queries and update queries.

View 2 Replies View Related

Project For School Help!

Apr 13, 2006

Hi all

I am new to this forum and to Access. I have expierience with visual basic.

I am making a program in access for saving data when someone borrows something from you, to keep track of all your borrowed stuff.

Here are my questions.

1) How can I write code for buttons to change the records (movenext, movelast,...) + how can I change the current record? + how can I control a scrollbar via code?

2) How can I change the current recordsource via code and how can I run previously made query statements via code?

3) How can I change the ShowDropButtonWhen property from a combobox via code?

4) How can I control a FlexGrid via code?

5) How can I open another Form with a press on a button via code?

6) How can I save and load an OLE/object image and how can I show them via an ActiveX control?

Thats about it folks

If anyone can point me in the right direction or can give me an example database, I would be very happy:)

Greetz
Frederik

View 2 Replies View Related

Help With School Project...

Oct 30, 2007

Hi,

I am responsible for creating a database for a school project, and am having some problems relating the two tables of the database together. Please keep in mind that I have no prior Access experience, and know very little about the program. Here is my situation, any help would be greatly appreciated:

Taking the perspective of a product vendor in a store (i.e. selling soda to a grocery store), I am trying to create a database which allows me to run a query for authorized products in certain stores. I have a products table which has all available products the company sells, and then I have a Stores Table for the different stores which carry the company's product. I want to know how to set up and join each table so that if a certain product is not authorized in a certain store, it will not show up in a query.

Again sorry for the shallow description, any help would be greatly appreciated.

Thanks,

View 10 Replies View Related

Pre-school Register

Feb 7, 2008

Help! I am trying to think of a way I can use an excel worksheet as a data form in Access. A little background to the problem. A pre-school that I have been helping have a excel spreadsheet in place that they use as a kind of booking register which also works out the termly costs for each child based on the number of sessions attended. Is there any way I can inport or link this to a database so monthy invoice's and goverment figures can be printed automatically.

View 1 Replies View Related

School Management Database

Apr 10, 2006

Hi 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.

View 2 Replies View Related

Please Help, Question On My School Coursework.

Apr 23, 2006

OK I'll start by giving some background detail. This is my major project and I am creating a system for the school library. I am using Microsoft Access 2003. I have made a query and my end user will type in the date that a book is loaned out. My database then automatically fills in the duration it is loaned for, the date is due back. What I hope someone on here can tell me is:

Can I get the current date on my database. So that it updates all the time to always keep the current date. Then I can make it automatically work out how many days late the book is (if it is).

Anyone who can answer this question or point me in the right direction is a hero!
Thanks, Michael.

EDIT: OK I have found how to make the late field update automatically. Late: Date()-[DateDue]. But surely if it can do this and know the current date for use in an equation it can display the current date? Anyone know how to do this?

View 4 Replies View Related

Community Help Required Please Help! School Database

Apr 10, 2006

Hi 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.

View 14 Replies View Related

General :: Columns Break For School Year?

Feb 15, 2013

I have a report that needs to be set up in 2 columns using the school year, 2012-2013, 2013-2014, etc. My issue is this. The columns go down the page and continue on the right side for column 2 in the correct order. Is there a way to have the columns break for the school year?

I currently have this:
2012-2013 2014-2015
2012-2013 2014-2015
2012-2013 2014-2015
2013-2014 2015-2016
2013-2014 2015-2016

I need this:

2012-2013 2012-2013
2012-2013
2013-2014 2013-2014
2014-2015 2014-2015
2014-2015
2015-2016 2015-2016

View 1 Replies View Related

Printing Date In Words On School Certificate

Mar 10, 2012

I am trying to create a report which is basically a School Certificate. The requirement is that I need to print the Issue Date, means the current system date be printed in ENGLISH WORDS rather Alpha-numeric format, i.e.: instead of 11 Mar 2012, I need some thing like this: Eleven March Two Thousand and Twelve.

View 4 Replies View Related

Need Urgent Help! School Project...can't Figure Out Calculated Field

Nov 2, 2005

Most of the project is done...I am stumped on calculating a field for the report...any help is greatly appreciated..thanks so much.

Use a Microsoft Access database to create the tables and column headings show in Figures 1-3 and discussed in the Background section. Create the tables in the design view. Populate the tables with the data as shown. Make sure you create a composite primary key field for the ORDERS table. The key should consist of the fields Invoice Number and Product Number to allow customers to order more than one item.


Customer
Customer NumberCustomer SchoolCustomer StreetCustomer CityCustomer StateCustomer ZipContact Name
105Central High123 Main StreetDenverCO80208Mary
107Central Middle35 South ParkDenverCO80278Sue
423JKF Elementary69 5th AvenueCheyenneWY90200Pat
516Toddler Time8000 ParkwayFt. CollinsCO80487Jan
799Georgetown High819 Rt. 909BoulderCO80303Jack






Product
Product NumberProduct NameProduct Price
10001Paper Plates$10.00
10002Paper Cups$20.00
10003Plastic Knives$18.00
10004Plastic Glasses$25.00
10005Paper Napkins$12.00


Orders
Invoice NumberCustomer NumberProduct NumberDateQuantity
1107100019/24/20054
21071000310/3/20053
31071000510/3/20055
44231000511/4/20054
57991000111/15/200510
67991000211/15/20052


Now establish relationships between your tables.

Creating Queries and Reports

Creating a Select Query

The owner wants to find out how much of each product is selling for the date ll/15/2005. Develop a query in the design view to give that information using the headings Date, Product Name, and Quantity. Save the query as Today’s Sales.

Creating another Select Query

Tomorrow, the owner is going to be in Denver, CO, and she would like to call on the customers there personally. Make a query to display the contact name, school, and street address ONLY for those schools in Denver. Save the query as Denver Schools.

Generating a Sales Report

Finally, make a report to show the dollar amount sold to each customer for each product. To create the report, you will need to:

•Make a query first and then bring that query into the Report Wizard.
•The query will contain a calculated field for Total Owed.
•The query should show the fields Customer School, Customer City, Date, Product Name, Quantity, and the calculated field, Total Owed.
•Name this query “Report Data”
•The report will be grouped by Customer School and Customer City, with subtotals for each school’s sales and a grand total.
•Make sure you delete any bogus total lines, and make all appropriate fields currency.


Deliverables

Three tables
Query output: Today’s Sales
Query output: Denver Schools
Query output: Report data
Report: Current School Sales
Defined relationships (I can press the relationships button and will see that the relationships between tables are defined)

View 2 Replies View Related

Adding Pass / Fail And Audit To School Database

Mar 22, 2012

I have inherited an Access project from a former employee. My school currently keeps all grades in an Access program. Right now we just assign numerical values and those are turned into grades (I cannot actually find this table). Overall it works well, however, we now have classes where we need to input Pass/Fail and Audit.

View 14 Replies View Related

Queries :: School Database - Student Rank In Individual Subject

Sep 25, 2013

I am developing database for my school. I am done with everything except the examination aspect where i need to indicate students position in every subject beside their overall position according to the sum of all the subject scores. How to indicate student position in subjects.

View 2 Replies View Related

Forms :: Merging Attendance In School Report Card And Also Picking Highest Score

Feb 7, 2014

I want to have a report card where I can have attendance embedded in for each students and also the highest score for each class each session.

View 4 Replies View Related

Code Library .Net

May 28, 2005

I 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.

View 2 Replies View Related

MSDN Library

Jun 13, 2005

Is it possible to download the MSDN Library from the Net from offline viewing ?

Cheers,

View 1 Replies View Related

Library Dependency

Nov 29, 2005

Hi

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

View 3 Replies View Related

Library Database Help

Dec 27, 2005

Hi. 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.

View 10 Replies View Related

Missing Library

Dec 20, 2006

Hi,
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

View 2 Replies View Related

Help On Library Database

Apr 4, 2007

Hi 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 Related

DAO Object Library - Not Sure What It Is

Feb 16, 2008

Hi,

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.

View 2 Replies View Related

Another Library Database

Feb 28, 2005

Hello,
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.

View 4 Replies View Related

Library Management Database

May 8, 2007

I’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

View 5 Replies View Related

Ms Access 9 To 10 Object Library

Oct 25, 2007

I created an app that used the 10.0 library and a field office that recieved the app is using the 9 library. They are having difficuties getting buttons on forms to work. They are getting a 2580 error something about the SELECT statement. Could the library be the problem and if so is there someway I can save mine using the 9 so it will be compatible?
Thanks.

View 14 Replies View Related

Can't Find Project Or Library

Nov 22, 2007

Okay, I have been away from in-depth access for several months and now I am transfering my project to a new computer with Office 2000 and latest patches installed.

When I try to run a screen, I get the error "Compile Error. Can't find project or library."

I check the references against the old computer and they are all the same.

The silly thing is that it is built-in functions like "trim" causing the error.

I know this is very basic but I forget what causes it.

Thanks much for the help!

View 1 Replies View Related

.mde File Cant Find Project Or Library

Jun 16, 2005

Please help!

Working on an Access 97 database that I have inherited, on win 2000. The database is converted into an .mde file for the users.

I need to convert my new version to an .mde file, it does convert, but then when trying to open it afterwards gives the error below. Believe it's connected with the startup form frmsplashscreen which has 'on current', 'on open' and 'on timer' events

The expression On Open you entered as the event property setting produced the following error: Cant find project or library.

I have gone back to the .mdb it was converted from and compared the startup form to that of a previous version. All the code is the same.
I have also tried commenting out the on open event, which then changes the error to

The expression On Current you entered as the event property setting produced the following error: Cant find project or library.

I don't understand why it does not work, this same form opens fine when it's an .mdb file.

This is the first time I have worked with .mde files...I've looked on the internet, can't locate the exact error but similar ones point to problems with files on my ws (references etc). Previous versions of this database as .mde files work fine though?
Just say if you want the code from the startup form.

Help! Can't see what is causing this issue.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved