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 Replies
ADVERTISEMENT
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
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
Apr 25, 2005
I have tables and forms setup but I have 3 general questions on how to finish the project.
1. Should I create a folder where all the files reside for instance, create a phone log folder, put the DB file into the folder and export XML's into the same folder?
2. How do I get the form to launch as a self-contained form without the Access application in the background?
3. How can I get this form and table to automatically update an XML spreadsheet whenever records are added?
4. How can I get the form to sort all records according to time logged? The time will be entered in manually and we need all the records to sort automatically by time in ascending order.
View 5 Replies
View Related
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
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
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
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 5 Replies
View Related
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
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
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
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
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
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
Apr 18, 2006
Hi guys. Back on the development trail having enjoyed a long break after the birth of my son :)
How quick one forgets!!
Project: My father-in-law would like me to develop a DB for his new company. They buy and sell plant hire (all done the old fashioned way, on paper).
His requirements are a little beyond anything I have attempted in the past so was hoping for some sound advice.
He would like to be able to record both Sales and Purchases. I have never worked with Stock before. What is the best method, any examples (did a search on stock prior to posting). He would also like to have VAT as an option (this stumped me on my last project!!).
Many Thanks,
Phil.
View 5 Replies
View Related
Mar 13, 2007
Hi People, great forum here and i've learned loads in a few hours ive found it :D
im just wanting a bit of information or some pointers as i cant seem to find anything on the forums about it, first off i have a DB (access) with a list of employees in i have variuos reports and other tables etc, what i want to be able to do is get access to work along side Word, -
i need each employee to fill out variuos forms that come in word format , i want to know if A, is it possible to auto fill a word document out with variuos information from the DB, as im pretty new to access and have no working knowledge of VB then im stumped - then B, i want to be able to save this in a folder on a network drive and have access to the form etc or scanned form etc for each employee.
any help would be great on this as my brain is havin an overload and i only have a certain time cale for the project
thanks in advance to anybody who can show me any pointers
View 1 Replies
View Related
Nov 12, 2007
this Project about computer company , the Boss of this company want from me to make database help him to know :-
Customer's Information.
what the customer's invoce , pay , remain.
Supplier's Information.
money come , money go.
that's not all , but it's the main points , I just want the any project similar to my project....... or at least , sites have examples for what I want.
NOTE : I attached Company.zip that contain Company.mdb and Company.accdb (they are the same) that what I made until now.
waiting for answer , and thanks in advance
View 3 Replies
View Related
Mar 13, 2008
Hey guys, new here and I need a little help with a project my boss wants me to complete.
Basically right now, he has a huge directory of quote sheets that he fills out whenever he wants to generate a quote for a customer (they are excel files, i've attached a picture of one). He wants me to create something that will scan through this directory file by file and extract certain pieces of information from each excel file, and put them into a database. The company I work for isn't too big, so i'm going to use access as the database.
I've also suggested building a new quote sheet in VB, and programming it so everytime the form is closed, the certain pieces of information he wants will be saved into the database. So I guess after this we can forget about Excel. But also, he wants to be able to bring up the entire quote sheet again if need be.
If you guys could please help me out, what would be the best way of going about doing this? Am I heading in the right direction as far as my thinking goes?
View 14 Replies
View Related
Mar 20, 2008
See wip,
28-Mar-08, 06:07 AM
View 8 Replies
View Related
Mar 27, 2008
hi every one,
how r u all
i really need your help
i asked my friend and he told me about u guys
my problem is :
i want to create a database for entering student marks ^^
but i don't know much in access so could u plz help me
i want to u make the Relations so that i can make any form to enter the data i made the relationships but there is problem " i can't enter marks for new student "
Please help i have to submit it this Saturday
i will appreciate for u guys if u make as soon as possible
The prince
this is my file
http://www.tntup.com/file.php?file=1fa534bffc053e8cc460cb9d27c34c5c
View 3 Replies
View Related
Sep 30, 2006
Hi,
I have a project about creating a data base of Foreign Trade, where I have to choose the country, then to determine the period (years).
so, could you please tell me how:
1- to link a combo box with a query (comob box of list of countries)
2- to link 2 combo boxes with a query of starting date and ending date
(the criteria is: >=[start date]and<=[end date] ).....should I separate this criteria and put it in to 2 columns of same data (years)...I tried it but it didn't work.
3- to link a Run Query command button with conditions mentiond above. When I established the command button, it showed the whole data base, so how can I link it with 2 conditions above.
Waiting your appreciated replies a.s.a.p.
Thanks,
View 9 Replies
View Related
Nov 27, 2005
Ok first off thank you for anyone who even reads this.
Iv been assigned a project in using Access 2003 and only Access 2003. Im stuck and getting frustrated and was wondering if anyone would mind helping me.
What my Prof wants is a Access database with a form to do the following
HE wants us to have menue with
5 sandwitch combinations
5 Side (combinations)
3 drink Combinations
2 desert combinations.
Ok he wants us to input 1 of each category as if we were ordering
then he wants us to order it and print out a Recipte with the following info.
Sub total
Tax
Total Purchase
How many Calories the entire order is.
Im attaching a .mdb file with what i have come up with but im not sure if its even going in the right direction. I would forever be in debt if someone would help me.
rename the wendys.txt in the zip file too wendys.mdb
View 1 Replies
View Related
Nov 27, 2005
mods could you please del this thread. thx
View 14 Replies
View Related
May 31, 2006
Ok, well basically i am trying to write my own database. and i have not the a very good working knowlage of access and some many bits that are over my head, Would any of you guys be willing to help me out with this?
I would be willing to pay someone to do this, if you could give me prices per hour ether here if permited. or via Private Message.
for comunication purposes i could use skype or msn messanger. as there will probably be some bits i would need to explain. I am a little bit of a perfectionist so i would try and explain as clearly as i can as to what i want. there is no desparate rush on this project altho july would be great, one of my friends was meant to be helping do this as he is good with access but i have been waiting for him to do this for about 6 months.
Thanks
Shrew
View 10 Replies
View Related
Jun 13, 2006
Lately I have been using my db's on computers which did not create them (my db's). I've been seeing this message sometimes;
Microsoft Access
You have modified a signed project. you do not have the correct key to sign this project. the signature will be discarded.
can someone point me in the right direction. I think I've been down this road before but forget the correct path:confused:
View 1 Replies
View Related
Dec 1, 2006
I 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 Related
