Hi I have two tables. Table A has team members in it. Each row in the table has the member id and the team id. Tables B is the users table. In table B there are multiple fields that can have a Team ID in it, 6 fields to be exact. This is all in an MS Access Table. I want to have a query that will product...

I get an invalid operation in the line "fld.Size = bytFieldSize". How can I change the code below to work? Code Snippet: 1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: Private Function ChangeTextFieldSize(strTableName As String, strFieldName As String, bytFieldSize As Byte) Dim dbs As DAO.Database...