Recent content by clloftus

There are 173 fields and a user could have one or more of these fields checked in their individual record. Does that make sense?

It should be more than one table, I just haven't figured out how to move cert fields to another table without 1) losing the data and/or 2) messing up the joins. I have a users table that contains certain data. USER TABLE Username Organization Project Role NETWORK TABLE Network1 Network2...

I have about 173 fields, and tried to add 6 additional. I only have 2 tables in the entire database with approximately 1600 records. I know I probably need to redo it and split the table into several tables. I will say I am not a guru by far, so taking that leap to making more table and...

I created my DB in MS Access 2007, but recently converted to 2010. I don't think my issue is based on this conversion. When adding new fields in a table, I am receiving the "too many fieds defined" error. I tried compating/repair; also copying the table and deleting the old. All with no...

No luck. Problem 1: When I click the VM checkbox, all of the fields I've requested to be disabled are; however, when adding a new record all of the fields remain disabled until I check/uncheck the checkbox in the new record. Problem 2: I have a second checkbox (ITxHub) and have used the...

Thank you I will try this and see what happens :)

Where do I place this code in the code that I've shown above? I'm sorry, I'm fairly new to this. Thanks for your help. Cindy

I'm sorry, that url is a forbidden url from work. Is there something you can provide on this forum? Thank you for your assistance.

I was able to figure out how to disable a field when another field was filled out; however, when the field is modified to be blank, the 2nd field does not reenable. Below is my code; any assistance you can provide is greatly appreciated. Private Sub Form _Current() If Me.VM = -1 Then...

Thank you for your response. That is correct, I do not have any forms in the back-end, only the front end. So if I'm understanding you correctly, I can only make changes to the tables in the back-end if everyone is logged out?

Hello .. I have a split database, and several users have a copy of the front-end on their desktop. I need to make updates to the back-end (tables and forms). Is there a way I can do this when the users have the front-end open? A locked file is created, and when I try to access the back-end...

I got it figured out ... thank you for your efforts and assistance. I'm sure I'll be posting to this forum again in the future. It's a wonderful tool.

I also tried and still get the same results: Record 1, checkbox checked, textboxes greyed, Record 2, checkbox unchecked, textboxes greyed. Again, thank you for your assistance. Private Sub VM AfterUpdate() If Me.VM = -1 Then Me.NSAID.Enabled = True Else Me.NSAID.Enabled = False End If End...

Thank you for your response. I made the change, however, the boxes are still greyed out once the checkbox is checked for every record. The checkbox is not checked for every record, just the boxes are greyed out. Below is the change that I made. I'm fairly new to this, so I apologize in...

I have searched through the various forums, and have figured out how to disable a textbox when a checkbox is checked. The problem I am having is, this carries on to every record. When I go to the next record (record 2, 3, and so forth), the textbox is disabled, even though the VM checkbox is...