Search results

I don't understand what to change in my code to make it link like for like as you stated. Can anyone advise?

Thank you! I am not quite understanding though. I will mess with it and try to figure out what you mean. Hopefully by the time your meeting is over I will have figured it out :P

Oops! SELECT tbl_StudentInfo.StudentInfoID, tbl_StudentInfo.[Last Name], tbl_StudentInfo.[First Name], tbl_StudentInfo.[POST Reimbursable], tbl_StudentInfo.[POST ID], tbl_StudentInfo.Rank, tbl_CourseInfo.[Course Info ID], tbl_CourseInfo.[Course Type], tbl_CourseInfo.[Course Date]...

This? SELECT tbl_StudentInfo.StudentInfoID, tbl_StudentInfo.[Last Name], tbl_StudentInfo.[First Name], tbl_StudentInfo.[POST Reimbursable], tbl_StudentInfo.[POST ID], tbl_StudentInfo.Rank, tbl_CourseInfo.[Course Info ID], tbl_CourseInfo.[Course Type], tbl_CourseInfo.[Course Date]...

It is already set to Datasheet.

I have a form that shows data from tables tbl_AgencyInfo, and a subform showing data from tables tbl_CourseInfo & tbl_StudentInfo. Each agency can have mutliple students and multiple courses, so that is why it is set up this way. My subform will only display one record at a time, however...

You are my hero! This makes so much more sense. Thinking it over more, it's actually pretty similar to another database I created last year and had to work through some similar issues. Being over a year later, I seemed to have forgotten a lot of the steps with the process. Seems to happen often...

By the way, thanks for the video tutorials jdraw! I will definitely check those out.

Thank you both for your responses! Okay... this is getting me further but still a little lost. I have created the three tables Bob recommended. I have no idea what "long integer" means or how to make the StudentID & TestID this format in the tblStudentTest. I am assuming this is an automatic...

I don't know a lot about access so I need help, etc. etc.! I have a database for scheduling students' for tests. They can take up to six tests in a day. There are about 80 different tests that they can take. In my table, I created columns titled Test1, Test2, Test3, etc. They are lookup...

Well, the thing is, we currently aren't using a form for this table to enter data. This specific class requires that we register multiple people from each agency, so because a large handful of the students have the same agency/billing information, we enter them through the table for the sake of...

I have a "Course Date" field in my table. I want to limit the number of records in this field to 35 which is the maximum enrollment for that course. Is there an expression I can use to achieve this or some other way? Thank you!

Got it, thanks!

Hi all. My DB: I can't seem to get the queries to all work the same. Tier 3 and 4 queries work fine for the "greater than or equal to" criteria, but I can't make the exact same command work for Tiers 1 and 2. Any idea why it work work? They pull up all records instead of those equal to or...

Can you tell me how to do that? I thought I knew how but I must be doing it wrong because I still get the error.

Yes, I did add them to class offering. Here is my db. A note: I went ahead and removed the frm.Registration as I wanted to use frm.RegistrationAlternate instead. I renamed the latter to frm.Registration.

I am entering the new names/classes in frmClass and frmStudent. I can enter them there just fine, but when I go to frm.RegistrationAlternate to register the student in the class, it gives me the error. How would I go about removing them?

So, when I delete all of the dummy names that are in the DB and dummy classes, it wants me to enter a parameter value when I try to enter in new students and new classes. This has got to be simple, but can you tell me how to get around that?

Gotchya. Thank you so so much for your help! I was going crazy trying to figure this out. I'll let you know if I have more questions :p

I guess, from what I can see, not all classes I enter in the Add Class Option form get a ClassOptionID specific to the session/period. Why would that be?