Same contents in all rows

[sigmundlo]

I am very new to Access and I tried to make a project database based on one of built-in templates. Then I entered design view to add new columns, but the new columns wont work properly. When I enter data in my new column, it automatically fills all rows in that column with the same data. The other columns from the template works fine.


Why is this happening?

[aytee111]

Do you have the correct value in the Control Source property? This sometimes happens when the text box is not bound to a column on the table.

[sigmundlo]

The control source is empty. So that's the problem? But I don't know what to put there, because it only lists up the other columns. Is it related to the columns in the table? Is it so that when I add a column in the design view, it's not added to the underlying table itself? Is it possible to add columns in a template table?

[aytee111]

I'm not sure what you are trying to do. The form is bound to a table (form properties: RecordSource) and each field on the form is bound to one of the columns on that table (control source). So if you do not bind a field on the form to a column on the table then it populates all records with the same value because it is meaningless to Access, just some data floating around. By putting a real column name into the control source property then it applies to that one record on the table and the data will be stored there.

Are you trying to store the data or is there some other reason for having the field on the form?

[sigmundlo]

I want to add a column to the table, and I hoped that was done when I add a field in design view. I can't find any way to add a column to the table. If I create a table myself, I can add columns in the data sheet view, but with template tables I'm stuck. I'm sure it's possible somehow.

[aytee111]

I've never worked with template tables. If you can't make it look like you want it to then I would suggest creating your own table. Go to "Create" then table design. Copy all the fields from the template table and paste them into the new table design, then you can add any columns you want.

Columns can only be added to tables manually or else using VBA code.

[sigmundlo]

Ok, thank you for helping! Then I will not fight more with the template. I hope it's easy to import the data from the template table into the one I will make myself then. My employeer handed me this database which is based on templates, and we need to add more columns to the tables...

[aytee111]

Here is a chance to learn about queries:

Create a Make Table query, all it will be is bringing in the template table and making a table containing all the data from the template table (you can use the "*" to denote all fields). Then the table will be created for you and you can then add any new columns you want.

You could also design the new table yourself and then use and Append query to append the old data.

Then there is always the good old Copy and Paste!

[sigmundlo]

Thank you very much! That helped!