473,326 Members | 2,815 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

can't find "add new field" column in access 2007

i converted an access 2003 db to 2007. it opens w/a switchboard, which then opens a form. when i switch to the table, there is no "add new field" column. the db option is set to enable design changes. how do i get the "add new field" column?
Jan 30 '10 #1
5 5168
RuralGuy
375 Expert 256MB
Is your db in a "Trusted Location"? http://www.btabdevelopment.com/main/...7/Default.aspx
Jan 30 '10 #2
yes. i have to have at least 20 charcters, so sorry for the nonapplicable, empty words part.
Jan 31 '10 #3
RuralGuy
375 Expert 256MB
Are you saying that a table in design view will not let you add another field?
Jan 31 '10 #4
yes. i think it may have something to do with the fact that it was converted from the original access and its succeeding iterations.
Feb 1 '10 #5
RuralGuy
375 Expert 256MB
Not in Datasheet view but in Design view where the fields are listed vertically and you create a new field in the row below that last entry in the list. If you create a new test table, does it let you create new fields?
Feb 1 '10 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Bruce | last post by:
I have three tables in SQL serve tblareas (w/autoincrement ID tblprograms (w/autoincrement ID tblphases (w/autoincrement ID I've build cascading relation from tblareas <one-many> tblprograms...
1
by: p175 | last post by:
People, I have the following table and I need to add a column that uses a the listed UDF to count the number of days within specific quarters by year. CREATE TABLE HISTORY_MB (...
5
by: Mike L | last post by:
Hello all I'm trying to migrate a BE from Access to SQL Server. I've been making changes to the Access BE from the FE with SQL statements, and want to do the same with the BE in SQL Server. ...
0
by: Hai Nguyen | last post by:
I have a datagrid. Now I want to add a new to column to the last column of the grid, how can i do that? I can add a new column but it adds to the front of the grid. Thanks for helping me
1
by: Matthew Hood | last post by:
When updating an access table using the ADD COLUMN sql statement, my routine may encounter an OleDbException stating that the field already exists. How can I test for this error to allow the...
6
by: gdjoshua | last post by:
New to C##.. All I want to do is add spaces to a string I'm displaying in label? Anybody know the easiest way to do this. char(32) doesn't seem to be working...
2
by: Max2006 | last post by:
Hi, I have a DropDown bound to a DataTable and I would like to add "Please Choose" as the 1st default item. I know that I can add "Please Choose" to the DataTable; but I wonder if I do the same...
4
kcdoell
by: kcdoell | last post by:
Hello: I have the following afterupdate event: Private Sub GWP_AfterUpdate() 'Updates the Total calculation in the control "SumGWP" on the quick reference 'table that is located on the form...
1
by: Heather | last post by:
I keep selecting and selecting, but it just doesn't show up. I also have no button in the ribbon for this, or any ability to get into other modes via the Office button. It's very frustrating; I had...
1
by: Ronald S. Cook | last post by:
I bring back a list of Employees as an IEnumerable of Employee... columns include EmployeeId, EmployeeLastName, etc. I want to bind the IEnumerable to a datagrid BUT I want the grid to have an...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.