Search results

Wow. *smacks forehead* The "On Load" event for my Student form forced it to open to a new record. I'm an idiot.

Not sure if this helps, but the combo box is unbound, and I'm using Access 2010.

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...

Re: "Row level locking will be ignored" when I password-protect a split database? Ack, sorry for the delayed response. And thanks for the link, Bob. Will peruse that later. If I get incredibly lazy, I might just go back and remove the passwords entirely. It's more important that certain...

Re: "Row level locking will be ignored" when I password-protect a split database? Appreciate the response. Several users will be using it at the same time, so I have the Record Locks property set to Edited Record for some of the forms. Unless - that's still in tact, and the statement "row...

"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...

Wow. Didn't realize my subform had blank records to begin with. Just plugged in some random values, and I can see the subform just fine now. Thanks. =)

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...

Using Access 2010, my first and only experience with the system. :) I was actually a bit pressed for time, so I went ahead and started my own menu form. For now, I'm just making buttons and fiddling with their corresponding macros. But I do plan to explore this "Switchboard Manager" when I have...

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...

Problem solved! And I feel absolutely ridiculous. Dug around my coding and found this under the "On Load" event: DoCmd.OpenForm "FormName" DoCmd.GoToRecord acDataForm, "FormName", acNewRec My intention was to have the subform open to a new record, but the first line was also opening the...

Thanks for responding! And, oh boy. I think I see my problem now. (Maybe?) My form actually has two subforms on it, and only one of them has this issue of popping up. The difference is I created one using an existing form (which is the one opening in a new tab), and another using a table (which...

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...

Thanks for responding, Bob. I tried your suggestion, but the forms within my Navigation form are still opening up twice: once in a separate tab and then in the Navigation form itself. It automatically takes me to the new window, so would I just SetFocus to the one in the Navigation form...

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...

Might try that actually! I want to hide the subform, but then I can't SetFocus on a hidden object. Really appreciate the tip, JR. =)

Huh. I just decided to check the actual table for Class, and it's not showing that extra record. =D Otherwise, the standalone ClassID shows up on the datasheet in the subform, but it's not saved as an entry either way. Case closed. *noob in the house* Thanks for all the help, Tim!

I included the End If, and I'm still getting the same problem. :( My master field (ClassID) links to the ClassID on the subform, so once you go to a new record in the subform, it automatically plugs in a ClassID. I need to somehow prevent it from moving onto a new record entirely after the last...

And tried out your suggestion, but I'm still getting that extra record. *strokes chin* Still, appreciate your input. =) Gonna keep fiddling around with If-Then statements, and I'll drop a note if I stumble upon a solution. But if there's a better way to do this, I'd appreciate any hints...

Hello, I tried that just now, and it moved onto the next record in the main form, and then it plugged in seats 1 through 10, but with no ClassID. So I basically had one record with just a ClassID on the main form, and a second record with the seat numbers, but no ClassID. D: