We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

how do I insert a row in Database

asked 2021-04-26 08:48:39 +0200

Soltee1 gravatar image

updated 2021-05-10 23:04:51 +0200

Alex Kemp gravatar image

When I try to set up a table in design view and wish to change the order of my fields, or insert an extra field, I can't do it. Basically I have to either write out my fields in longhand and arrange them or delete fields and start again from scratch.

edit retag flag offensive close merge delete


I too have never been able to arrange the fields in the order I want when editing the definition of a table...

But I try not to see this as an issue!... Because...

We are told that it is a Bad Idea to access tables directly. That we should ALWAYS use a form.

If you want access that looks like the simple "direct" access, that's easy: Use the form wizard. Accept the default suggestion of "As Data Sheet" for the arrangement of the controls.

If you re-sequenced the selected fields in the first step of the wizard, that's the job done. if you didn't, you can edit the form, to move columns left and right. Not with a simple drag, alas, but by using "Insert Column" (You want to insert a "formatted field", I think. And you need to "attach" the required data, using the columns properties ...(plus)

MSPhobe gravatar imageMSPhobe ( 2021-05-11 11:10:47 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2021-04-26 17:26:37 +0200

Longi gravatar image

It seems to be not posible at the moment. if you want to put a new field you have to put it at the end of the wizard. It is possible by direct SQL (Alter table), but it doesn't really seems neccessary if you use queries or views.


edit flag offensive delete link more


I think @Longi meant "design tool" (arrived at by opening a table for edit) where he/she said "wizard". Pedant? Moi? Sorry... but I have seen such things confuse and confound novices to whom navigating a new tool isn't second nature.

MSPhobe gravatar imageMSPhobe ( 2021-05-12 09:47:21 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2021-04-26 08:48:39 +0200

Seen: 36 times

Last updated: Apr 26