Recent content by KenRob

--> This worked so wonderfully! I don't think I have ever implemented code found on a forum to easily. Thank you sooo much! EXACTLY what I needed!!:D

Great thought Minty! I would not have thought of that... It seems like the nested subform does not inherit it's parent's behavior though because it doesn't lock when its parent is locked. I am not sure if that is proof either way though. Thanks for giving it some thought. I will post...

If you see my original post, you will notice that I have utilized me! and "understand" it. Using the control source builder did not give me a RELATIVE reference to the nested subform--- it "skipped" over the subform that contains the nested subform and therefore does not work.

Thanks for your reply... But this doesn't work in this instance. I need to reference a nested subform from the main (parent) form. When I attempted your suggestion, I just ended up with the basic reference... Forms![fsub_Subform2]... instead of the full "relative" reference. Any other ideas...

Hi Minty-- Thanks for your reply. I actually used that website for reference as well. I could go the route of referencing every single control, but I want to just be able to toggle allow edits etc on and off using the button. This works on the main form and the subform1 but not subform 2... Not...

Hello All, I am working on vb code for a MAccess form that would enable/disable editing on toggle. This button lives on the main form, so it needs to reference everything from there. There is a main form, a sub form, and a sub-sub form. The code works perfectly for the main form and subform...

Gina! It works! I used the input mask wizard to create a new input mask. Even though I had used the same mask (00:00:00;0;_) before, when I added it with the wizard, it asked me when I wanted to save the characters (colons) or not. This allowed me to save the time in a way that SQL Server...

My thoughts exactly Gina. time(0) requires hh:nn:ss, but when I apply that format I still get the error message.... I am wondering now if formatting, or input masks actually store the punctuation (colons in this case). Hmm... it's a head scratch-er!

Hi Gina, Thanks for your reply. I was entering the time through an Access form with a field that was formatted as a date. I tried to enter the time directly to the table and realized I have to include the colons. This seems clunky. But at least I got the data into the table. I just wish my...

Hello all! I have an Access front end linked to a SQL Server 2008R2 database. I am having a lot of trouble with the time field. I have a few time data type fields in a few tables. I have chosen the time(0) data type in SQL server, but whenever I attempt to add test data to the time fields via...

jollofrice set me on the correct course to finding a solution. I have having the same problem as addressed in this thread. My form was also built on a query. But I did not have quite that same situation as jollofrice. I did use tbl.* in my query, but I did not the use tbl.field to sort...