Search results

SOLVED - Button to open form to specific record not working I have a form that allows the user to drop or transfer classes for a student, and on that form I have a combo box that pulls up fields from the Student table. All of the columns are hidden except for the StudentID. The rest of the...

"Row level locking will be ignored" when I password-protect a split database? Afternoon, everyone. So I've run into a bit of trouble while encrypting my front and back-ends, and I'd appreciate any help at all! I'm using Access 2010 and just recently split my database. I set a password for my...

Evening, everyone. =) I have a MainForm with a subform on it, and the latter remains hidden until you check a certain check box (procedure in check box's After Update event, and another in the MainForm's On Current). Everything's working fine here. Here's where things get wonky. On a separate...

I'm nearly done with my database and just now starting to mess around with a tab-based navigation form. Huzzah! But, unfortunately, I'm having to go back and tweak a lot of the "links" and query criteria. For example, a criteria that used to reference the value in one form's combo box NOW has...

Let's say I have a form with a subform on it. Whenever I click to open the form from the navigation pane, it pulls up the form with the subform AND the subform again in a separate tab. Is there any way to prevent this? Otherwise, I want the subform to just open once on the main form, instead of...

Just started working on my database again, and I've run into a seemingly simple problem with a navigation form... I've assigned forms to my navigation buttons, but whenever I click a tab in Form View, it opens the form I want in the navigation subform AND in a new, separate window/tab (like a...

Hello, I've run into a smidge of a programming problem on my form, and I'd appreciate any help whatsoever. I have a table called "Class" with a subform called "ClassSeat". The ClassSeat subform has the following fields: ClassSeatID (AutoNumber), ClassID, StudentID, and SeatNumber. The field of...

Hey again. :) I've run into yet another problem on my form, and I'd appreciate any help at all! There's a text box on my form that is bound to another field called "SeatNumber", which basically reserves a seat for a registering student. The problem is that you have to blindly enter a seat...

Afternoon all. :) I've been working on a registration form where students can enroll in classes. So far, they can enroll in multiple classes through a subform in continuous form, and the tuition total is calculated in the subform's footer. I then created a text box in the main form that...

Afternoon all! I've been trying to create a Registration form (e.g. enrolling students into a class), and I just keep running into problems. So far, I have tables "Student" and "Class", and a third junction table called "Registration" with a composite primary key. I created a form based off of...

(e.g. enrolling one student in multiple classes.) Hello! I'm having a spot of trouble and would appreciate any help at all. (I'm still an Access novice, so apologies in advance if something doesn't make sense.) My three tables are Student, Class, and Registration. I created a separate form...

Hello. :) I'm fairly new at Access, so apologies beforehand if this sounds confusing! I originally set up a query that searches for classes in a directory based on four parameters: the location, grade level, semester, and year. However, I didn't want the query to pull up four separate pop-ups...