Search results

thanks Alex, this looks pretty good - my big problem is, how to bring up the students record to input the data. I need to have a field where I can enter the student number and the existing form appears for that student - but I have no idea how to do it - there are too many to scroll through -...

Hi Gina, not sure what happened to the reply I had sent on Friday so I will redo it and hope it makes sense- here goes: I could in the first instance ignore the counsellor and reason tables as I use them from a combo box although I do have a relationship with the appointments table 2015_16...

Hi Gina; table 2015_16 has 2000 plus records - none are duplicated as the studentID (student number) is specific to each student. other items in this table can be duplicated ie names, the program and academic level we could in a sense ignore the counsellor or reason table just now...

It may be my terminology that is wrong as a non-DB person.. the 2015_16 table stores all the student data which was supplied to us by our central registrar's office The form is created based on two tables - appointment as the main and reasons as the sub form When I type in the student number...

all my 5 tables: 2015_16 - list all the academic details of the student, id, name, program, year - this is the MAIN table for nearly everything. TblAppointments - lists: studentID, first name, last name, program and year - it is linked on a one to one relationship with the 2015_16 table as the...

I split the excel file into two sheets - the first contained all the information for the top form - Appointments - which lists the students that come to visit us and includes their studentID, name, last name, program and academic year - in this one they only show once as it records that they...

I am trying to self teach myself many of these tasks using all the wonderful youtube videos - so I welcome any advice more specific to my situation. I think my initial problem was I imported all the data from excel, and forgot to remove duplicates for the data that would go in the main form -...

I created my form with two sub forms (so far) the top form has the: studentID. firstname, lastname, acadplan, acadlevel. On one of the sub forms I have the date they came into the office, counsellor, reasons and notes. The second form will record the courses each student signs up for, the year...

whoop whoop I got it, I added in the control source under 'All". I thought linking it to the table when creating the combo box was enough. A small victory but eventually I will get the hang of this - one step at a time....

I apologise for my complete ignorance to what you have said - I am trying really hard to pick things up from youtube videos and some really good books but even when I copy things exactly (using my record names!!) they do not seem to work - so far the one thing I have got right is the...

is there a way I can fix it or should I change the design completely and not use combo boxes

HI all, I have created a form with a sub form that we will use to record the number of times a student comes to meet with a counsellor and why. The top form has: studentID, name (f & l), program and academic year - this auto fills through a combo box using the student id and some code (I...

Hi, My name is Irene and I presently live in London, Ontario having moved from Scotland in 2007. I reviewed some of your excellent YouTube videos and found them so helpful I had to find out more. I have been struggling to set up an Access DB for our student records and watching just one video...