Search results

Ok, I decided to go another route for the time being. Have a look at my MasterClassScheduler form. I can get every Professor and every class that is currently assigned to show in my combobox, but I actually need all of the Professors and all of the classes to show in their respective comboboxes...

It was a graphic they wanted added on all of the forms. I removed it and voila! 1.4 MB... :rolleyes: I'll give that a look tomorrow. Thanks again. You have been a life saver!

Ok, so for some reason, the DB grew from a few MB to over 140 MB since I uploaded it the last time. Even though I compacted it on close. So I can't upload it anymore. Weird... Anyway... Well, I found a bug in the classroom location form. I made a copy and fixed all of the different moving parts...

Can I ask a stupid question? :cool: So, I want to prompt the secretary on the MasterTable form which year and term she wants to see in the history form. How can I make the form prompt her to input which year and quarter she wants to filter the data by? I've tried "Filter on Load", but I can't...

Dude! You are my hero. Here is my finished product. I hid the Location Code text box and just use the new combobox for the display on the form. Works like a charm.

Many thanks. I was wondering if just hiding the Location Code text box would make the form look better while still maintaining the functionality you provided above...

Ok, changed that, but it now says "To make changes to this field, first save the record."

So, when I try to add a new record, can select the Professor, class, and location just fine, but when I try to select the classroom, it tells me the "join key of table 'Locations' not in recordset"

Ok, here is the latest revision with some additional non-required text boxes added.

Yeah. That's what they need to do.

So, I figured out the binding for the text box. Had to change the row source to add the extra column and then bind the text box to the Column(1). Still can't figure out the classroom assignment. I also will need to filter the classrooms based on the location I select since each location has...

Ok, I actually got that part figured out. Was using the ProfessorID from the Professor's table. Either way, now I am a bit further along and I am trying to bind the Campus Location field to the Location Code combobox on my MasterClassScheduler table, and I don't know how to do that. :confused...

Re: Working on a form with filtering Yes. I created a form and just added the two combo boxes for testing purposes. I need to have a new record get created in my link master table when I select the data for both combo boxes. I can figure out the filtering stuff later.

Good evening. I have a Professor's table with the professor's unique employee ID as my primary key on the Professor's table. I also have a "Classes" table with the unique class ID as the primary key. I have a linked master table with professors getting assigned to classes. I need to be able to...

Got the answer. I coded a button with this: Private Sub cmdMyButton_Click(...) Dim rstClasses As DAO.Recordset Dim rstMemberClasses As DAO.Recordset Dim strSQL As String ' "ClassID" below should be the name of the primary key field in the Classes table strSQL = "SELECT ClassID FROM Classes"...

On your section header, right click on properties and click on the format tab. The first field is force new page. Select the "Before Selection" option. It should do what you want it to do Good luck and God Bless!!:D Bill

Figured out a much better way to do what I needed than a drop down. Thanks for all the advice

Yep, Got it right YIPPEE!!!

I wrote a macro and ran it from my switchboard. Thanks all!!!

Sorry, I'm kinda thick!! I've built my append query. I have no idea where to go from here. Here's a picture of the query. When I add a new MemberID in Members table, I want it to add the new id with each class (each member ID is listed 33 times , once for each ClassID) to the end of my training...