College Student Struggling With Simple Combo Look Ups Arggh!
Mar 9, 2006
Hello people,
I'm not a programmer, I am infact a 17 year old College Student from the United Kingdom - Studying ICT!
For my major project I have to design, build and test a camera loans system for my photography department. Except, I am having problems with Combo box lookups. It's been over 6 months since I learnt this, and it's all a blank. Something as simple as this is simply not working...
e.g. in the Studentloans table, I wish to enter the Student ID number from the student ID card inside the combo box, and hit enter so that it brings up the relevant specific loans of that student.
I enter the id, hit enter and the student name, class etc does not change. Why? The same goes for my Camera Maintenance Table, Camera + Maintenance tables are combined to a CAMERAMAINTENANCE TABLE - Therefore I wish to enter the Camera ID number so that if i hit enter, it brings up the relevant service histories of that specific camera...
The relationships are all ok, the fields for Student ID are lookup, etc.
I don't understand. It's driving me insane. I need help with this, I'm struggling so much.
Help much appreciated.
Thanks - Neil.
View Replies
ADVERTISEMENT
Mar 9, 2006
Hello people,
I'm not a programmer, I am infact a 17 year old College Student from the United Kingdom - Studying ICT!
For my major project I have to design, build and test a camera loans system for my photography department. Except, I am having problems with Combo box lookups. It's been over 6 months since I learnt this, and it's all a blank. Something as simple as this is simply not working...
e.g. in the Studentloans table, I wish to enter the Student ID number from the student ID card inside the combo box, and hit enter so that it brings up the relevant specific loans of that student.
I enter the id, hit enter and the student name, class etc does not change. Why? The same goes for my Camera Maintenance Table, Camera + Maintenance tables are combined to a CAMERAMAINTENANCE TABLE - Therefore I wish to enter the Camera ID number so that if i hit enter, it brings up the relevant service histories of that specific camera...
The relationships are all ok, the fields for Student ID are lookup, etc.
I don't understand. It's driving me insane. I need help with this, I'm struggling so much.
Help much appreciated.
Thanks - Neil.
View 2 Replies
View Related
Nov 30, 2005
Probablly easier for me to explain via email. I have a class assignment due ASAP, and I am completely lost.
Thanks in advance you can reach me on yahoo.. Marketsharez@yahoo.com
View 3 Replies
View Related
Jul 6, 2006
Hello
I have a query that I'm trying to run.
The first field is a date/time field (tbotime) which is updated hourly
I want to get the results to show just the data from 07:00 and no other times, although I need it to show for each day. So I'd get the data for 07:00 yesterday, today, tomorrow and so on.
I'm beleive the criteria should be some sort of timevalue but everything I've tried either throws up and error and returns no data. I've searched the forum most the afternoon but still seem to be getting no where and now I'm rather confused as to whether I write some code or just put a line into the query criteria.
Currently I have my criteria as TimeValue("07:00"), yes all afternoon for this, I got fed up of seeing errors on my other efforts and this just gives me no data.
Any help greatly appreciated, thanks
View 14 Replies
View Related
Sep 17, 2006
Hi all,
I'm new to Access and I've been struggling with this matter for a really long time and would really appriciate any help. Anyways here goes,
I am trying to make a field ( [NIVEA1A] ) become visible in a form where particular Products selected in the combo box [cboproduct] ( located in [colproducts] ) is selected. The [colproducts] is located in [tblProducts] and I would like those values that contain a "yes" value in the [NIVEA1] coloumn make the [NIVEA1A] field appear. The [NIVEA1A] Field populates a [colNIVEA] located also in tblProducts. So what I have so far is as follows:
IIF(Dlookup("colNIVA1]" , "[tblProducts]", "[cboProduct] = [colProduct]").Value = Yes, [NIVA1A].visible = True, [NIVA1A].Visible = False)
I hope it all makes sense
And any help would be really appriciated!
View 2 Replies
View Related
Jan 29, 2007
Is there any clear cut way to directly access a cell in a table via code?
Ive looked as far as my eye can look to try and find something quick and easy that allows me to cherry pick data out of a table, but ive had no luck.
For instance, I have a table named tblSANConnections with a field in it named fldServername.
I want a command button to go into tblSANConnections and snag information from fldServername of the current record displayed on my form, and hell, I dont know put it into a variable.
Can someone toss out a few key codewords that I can lookup to accomplish what im after? thank you
View 2 Replies
View Related
Jun 22, 2007
Can someone help, please?
I have a simple form to add a new record.
Form is
Single
Bound
DataSource is a simple select query which includes all records in a table.
All I want to do is validate what is typed into the textbox.
I have the following code in the BeforeUpdate Event of txtTest:
Private Sub txtTest_BeforeUpdate(Cancel As Integer)
If Me.txtTest = "Test" Then
Cancel = vbCancel
Me.txtTest.Undo
End If
End Sub
It works fine on an Edit but when I type "Test" into a new record and try to move or save I get the error: The value in the field or record violates the validation rule blah blah BLAH.
Why doesn't vbCancel kill this nonsense?
View 14 Replies
View Related
Jan 12, 2015
I'm currently making a database for college about a driving school.
I have a table that stores the following: booking id, student id, lesson id, student forename, student surname, cost per hour and date paid.
How to create a query that calculates the total of the lessons taken in a month.
View 4 Replies
View Related
Oct 18, 2005
I am trying to get a combobox to appear in a querie. I created a querie and a form with a combobox using the wizard. When I run the form alone it works like it should. However, when I try to run the form from the querie, it does not run the combobox. Instead it runs a little box with what I typed as the criteria in the querie as its label. Make sense?
The syntax I use in the criteria is:
[forms]![formname]![comboxname]
:mad:
View 2 Replies
View Related
Sep 29, 2005
Hi all,
Im back again for more advice. What it is I hava a combo box yes/no and I was wondering how to disable and enable a button depending on if yes or no is selected. Hope someone can help
thanks
J
View 14 Replies
View Related
Oct 26, 2004
Hi
I have a combo box that is used to update a table with string values . I have the opportunity to select values already in the table and also to type new ones. The problems are :
a) If i have many records with the same string value, the combo shows them multiple times and I want them to be shown only once. I've uploaded a jpg from my db, showing the combobox. Do you see ,for example, how many times the "t-shirts" are shown? I only want "t-shirts" to be shown once. And
B) how can I omit these empty lines in the top of the combo? It's probably due to the fact that I have set the line numbers of the combo box to 255. But I don't know how many lines I will need in advance. Is there any chance of auto expanding/adding lines ? Or any other solution?
thanx in advance
View 1 Replies
View Related
Oct 17, 2013
I am building a simple form with a few Combo Boxes, text boxes and a picture. When two out of the three Combo boxes updates a few text boxes, labels but not all and the picture flikers/blink. I do have one other combo box that does not cause anything to flicker once it updates. This is getting annoying and it makes my form look unprofessional I do not have any vba or macros running yet on the form - I have tried different ways to creat the form IE. Form Wizard and Blank Design. I used the Look up wizard for creating the text boxes/ Combo boxes in the database.
The other thing I noticed is that when in design view the same objects blinks when I scroll up or down loger than the other objects.
I did search this site and the web but did not find anything that did not metion VBA code and the Echo on/off.
Access 2010
Windows 7
View 10 Replies
View Related
Sep 22, 2014
I have a combo box on my form that passes criteria to a simple select query. There are four possible selections to make from the combo box. For some reason, when I select the first option on the list the query runs perfectly. However, if I select the second, third or fourth option from the combo box, the query returns no records, even though I know there are records in my table which should be returned.
View 5 Replies
View Related
Aug 18, 2007
Hello everyone. I am a new member and need help with a database that I am working on. Let me first say that my knowledge of Access, SQL, and databases in general is very limited. I work in the Academic Success Center at my college and they use an access database for sign in/out. My job is to redesign this database so that there are two forms instead of one. The first form will just be the first and last name of the student along with the date and time that are generated automatically. Currently the student must type in there info and when they are done working in center they must sift back through the records on the form to find their sign in info and type in a sign out time. My task is to make two forms one that has just the students first and last name along with the current date and time. This will be the student sign in. Once the student is done they should be able to find there name in a list of currently signed in students, select themselves, and be taken to their sign in record. The student will then be required to click a button to be taken to the sign out form which will automatically fill in there name, date, and current time not sign in time. The will then be required to select the resources that they used and what courses they worked on and any comments if they wish. Once they have filled out everything they will need to click a button that will close the sign out form and update the student table with their info. The actual design of the forms is not the problem, the problem is getting all of this to function the way it is supposed to. When I fist agreed to this it really didnt seen like it would be that difficult but apperantly it is, I am becoming very frustrated and desperate. If anyone can give any help at all or point in a direction that will help I would greatly appreciate it. Thanks in advance, and sorry to be so long-winded.
View 5 Replies
View Related
Jun 10, 2005
I am handling a group of students and I want to calculate the fees coming from the student. Does anyone knows how to develop a tables and forms in microsoft access?
View 1 Replies
View Related
Feb 28, 2008
Hi folks,
I'm building a database to store student exam results so that transcripts can automatically generated. This is a final year project for university so the database will never be used. I am a complete amateur when it comes to designing databases.
20885
I have attached the relational schema for the database. I'd be grateful if someone who knows about proper design could tell me if its ok (from the point of view referential integrity and normalization etc).
I'd really appreciate helpful comments.
Regards,
sabatier
Just to explain a few things:
1) In the OverallMarks table, MarkType refers to whether the overall mark (i.e. 1st honours, 2nd honours) is for JF (Junior Freshman), SF(Senior Freshman) and so on.
2) In the ExamResults table, YearOfStudy refers to JF, SF, JS or SS. Year refers to the actual year the exam was sat e.g. 2007.
3) The data in the database will be coming from Excel spreadsheets, so my database will not be doing any calculations on the data. That's why I'm storing the overall mark instead of calculating it from the ExamResults table.
View 3 Replies
View Related
Nov 24, 2014
I am working on a Student database for a school. Need changing the student status e.g. A student was enrolled in class Prep. and now promoted to grade 1. How do I solve the problem. I need this for a report (Student Details) Like on 1/1/2014 the student was enrolled in prep and on 1/1/2015 he/she was promoted to grade 1.
View 3 Replies
View Related
Apr 13, 2013
I want to prepare a query which gives me the ranking of the classroom according to their average. (also there are classrooms in the table, if possible, query should consider the grades) you can see the attached sample document..
View 1 Replies
View Related
Nov 13, 2006
Hi
I have a DB for students.
I'm making notes each time we've had a chat.
Is there a possibillity to make a relationsship between 2 tables so I can make multiple records for one person? (or any other way)
For ex. 03-04-06 there were a couple of things I wrote down.
and 03-06-06 there were some other things I wrote down about the same person.
and then I will be able to backtrack this information
How do I do this.
Mikael
View 6 Replies
View Related
Feb 25, 2007
This idea has been sending me nutty for months!
I’m a travelling music teacher. So my many pupils are split into many small groups (of 1, 2 or 3 pupils).
What I want is to open a form with lesson details. I’d select a date and then a group and then the details of the pupils in that group would come up (probably in a subform). I could then enter data for each pupil for each lesson e.g. whether they were absent.
That’s it!
My current tables are
[pupils]
pupilID (pk) (autonumber)
pupilname (text)
[groups]
groupID(pk) (autonumber)
[lessons]
lessonID (pk) (autonumber)
lessondate (date)
group (text)
[pupilinlesson]
pupilinlessonID (pk) (autonumber)
group (text)
pupilID (number)
absent? (Y/N)
lessonID (number)
This last table is supposed to store the data of each pupil in each lesson.
Relationships
[groups]groupID 1 – M [pupils]group
This is probably quite easy for someone who knows how. Lots of people must need registers of pupils!
Thanks
View 2 Replies
View Related
Jul 5, 2012
I run an after-school youth program for high school students. My issue is an accurate way to track attendance of students. We have MS ACCESS 2010 on our computers at work.
On any given day we may see between 30 to 50 students, so this is a small operation - - and the reason I'm adverse to buying fancy "custom" software and hardware "systems". Because students come and go and vary over time, we may see 100 kids in a given week, but in the past 2 years of operation, we have had well over 250 students come through our program, with some returning at various times.
What I would like is to be able to
1) Make a simple ID card with student photos and a unique ID # that can be ...
2) Scanned by a simple barcode system.
2b) Actually two barcode swipes ... one swipe at the front door / main entrance, and a 2nd swipe by a hand held bar code in the various four classrooms to be sure the student is not only in the building, but also went to the correct class.
3) That the input of that information dumps into our ACCESS database so we can track student attendance, and ...
3b) provide reports out to school counselors / principals of the numerous highs schools that our students come from, to let them know which of their kids are actively attending our program.
My questions are ...
A. Can this be done with ACCESS?
B. Would it be better to do this with EXCEL?
C. If ACCESS can handle it, which types of bar code devices would be the best choice for us to purchase? (We would need a total of five barcode scanners. One at the front desk, and one in each of our four classrooms.)
The system would need to be expandable seeing that this could easily be doubled in terms of classrooms and students within the next year or so. We are currently just 2 years old.
View 3 Replies
View Related
Jul 23, 2013
Me having a db which is having a student table which is keeping all student info, second i have a Van table which is keeping van info. I wanted to know how it is possible to calculate monthly van fee for each student on monthly basis which db do it itself based on system date/time and calculate monthly required fee for each student. I also would like to know that if a student do not pay in a month then checking the next month or checking unpaid student through date criteria it displays all due amount may be in sum.
View 2 Replies
View Related
May 9, 2015
how can I display the scores of a student in horizontal?
I have two tables, one with students information and another for students' score.When I query may table using this
Code:
SELECT Student.StudentName, WrittenScores.Score
FROM Student INNER JOIN WrittenScores ON Student.[ID] = WrittenScores.[StudentID];
It resulted to this
All I want to do is something like this
View 14 Replies
View Related
Aug 26, 2013
How to query the example in the image below. My problem is:
1. If the student get a mark 49 below in any of their subject they will not be included in the ranking.
2. If all of the student mark is above 49, I need to rank the student base on their average.
View 1 Replies
View Related
Mar 8, 2015
I created a list that grades students and I would like to be able to print out a report on a particular student that shows those grades in more of a graphical representation.
I originally used word to do this and all I did was create a heading that listed the marks along the top and the categories in the first column, for example:
Code:
Outstanding - Very Good - Good - Satisfactory - NS - Poor
Writing x
Reading x
Attitude x
etc..
I used this report function because it was easy for the parents to see. However, as you can imagine, using word was really not the right tool and I went with Access 2007 (it's what I have).
I'm really happy that I went to a database format, but I'm having problems showing the grades in a more graphical way. Right now, it just reports the grades but the parents preferred the other format.
Is there anyway to do this in Access? I'm sure some smart cookie out there knows how I can do this. I tried using the graph function, but I quickly got lost with that and it didn't seem to work the way I wanted.
View 12 Replies
View Related
Apr 2, 2013
I have a table called Attendance were information about the Student and the class they are attending is collected.
Another table called Student, this hold information about the student. I am using a Form called Attendance to input my information. What I am trying to achieve is:
BeforeUpdate on a text box:
When you input Student_ID it looks at the Student Table to see if the Student ID is valid before the information is updated to the Attendance Table.
View 4 Replies
View Related