Add a column in an Access template
elle78
Posted messages
12
Status
Member
-
zenon Posted messages 729 Status Member -
zenon Posted messages 729 Status Member -
Hello,
I need to set up and manage a database. I started from an existing Access template (contacts) but I'm unable to add columns.
In fact, I can add columns in the design view, but when I input data into one of the cells, it repeats indefinitely.
Basically, my column becomes pointless since it just duplicates the data endlessly.
Does anyone have a solution to create columns?
Best regards,
I need to set up and manage a database. I started from an existing Access template (contacts) but I'm unable to add columns.
In fact, I can add columns in the design view, but when I input data into one of the cells, it repeats indefinitely.
Basically, my column becomes pointless since it just duplicates the data endlessly.
Does anyone have a solution to create columns?
Best regards,
Configuration: Windows Vista Internet Explorer 8.0
7 answers
Hello,
I imagine you are adding an independent field in a form.
For the data to be stored in the database, you first need to add a field in the corresponding table, and then add the corresponding field in the form...
(sorry if my assumption is incorrect)
I imagine you are adding an independent field in a form.
For the data to be stored in the database, you first need to add a field in the corresponding table, and then add the corresponding field in the form...
(sorry if my assumption is incorrect)
yes, but how do I add the corresponding field in the form?
Sorry, I really don't know much about databases.
Sorry, I really don't know much about databases.
When you open the form in creation mode, you can display the list of fields. In principle, the new field should appear, and you just need to drag and drop it.
If the field does not appear, it means that the form is based on a query.
In the properties sheet of the form, under the Data tab, Source, you can verify this.
If the form is based on the table, you will see the name of the table; otherwise, you will see the SQL code of the query.
Then you click on the three dots... on the right.
You will see an interface that displays the tables at the top and the fields chosen for the query and the sort filters at the bottom.
You just need to double-click on the field you want to add.
Once done, it becomes visible in the list of fields (which you need to refresh by closing and reopening it)... (phew!)
If the field does not appear, it means that the form is based on a query.
In the properties sheet of the form, under the Data tab, Source, you can verify this.
If the form is based on the table, you will see the name of the table; otherwise, you will see the SQL code of the query.
Then you click on the three dots... on the right.
You will see an interface that displays the tables at the top and the fields chosen for the query and the sort filters at the bottom.
You just need to double-click on the field you want to add.
Once done, it becomes visible in the list of fields (which you need to refresh by closing and reopening it)... (phew!)
Thank you for your response.
I can follow you up to "You then click on the three... on the right."
At that point, I no longer understand what to click on.
Otherwise, the form is indeed based on the "contact" table.
Thanks again.
I can follow you up to "You then click on the three... on the right."
At that point, I no longer understand what to click on.
Otherwise, the form is indeed based on the "contact" table.
Thanks again.
So the following explanation is not necessary.
You should directly see the field added to the list.
If you click to the right of "source," Access will ask if you want to create a query based on the table.
Just drag and drop the field you want to add to the detail section of the form.
(You will have to move the label "manually")
You should directly see the field added to the list.
If you click to the right of "source," Access will ask if you want to create a query based on the table.
Just drag and drop the field you want to add to the detail section of the form.
(You will have to move the label "manually")