Recent content by AirCounsel

I've been trying to set the time format for a date/time type of field to medium time while in table design view. I select the field and go to the field properties tab below and choose "Medium Time" and save. When I go and try to enter data, it always turn the time entered into the "Long Time"...

Pat, I clicked on the link provided by PNGBill and followed those instructions to normalize the database. However, in the original design I had a field in my "workers" table named "Day Availability" and used the lookup wizard to get the days of the week from a separate table. Now, I have a third...

PNGBill, Great suggestion! The link you provided led me to a tutorial that explains exactly what I'm trying to do. Thanks!

I've created an Access database to manager the activities of a school. I have a "contacts" table where I enter general information about all contacts and a "workers" table linked to the contacts table, containing specific information about workers, such as availability, abilities, etc. I've set...

Vila Restal, Thanks again!

Thank you Vila Restal, it workerd like a charm! For my education, would you mind explaining what was going on and what your code actually did?

Thanks FuzeK3! I added the code to the form Load event. Still didn't work. Right now, the only time that it works is when I'm checking or unchecking the checkbox. Otherwise, when the form loads it shows the ckeckbox with a check mark, but the subform is not visible. Same thing if I navigate to...

Hi, I'm new here and somewhat inexperienced with Access VBA, so any instructions will need to be as detailed as possible. I want to be able to hide or show a subform on a main form with a checkbox bound to a table field. I've used the following code in the form current event and the checkbox...