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.
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.
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:)
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.
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.
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.
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?
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.
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 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.
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
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)
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.
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.
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.
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.
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
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 ..
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.:)
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.
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):
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.
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.
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.
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.