Access is difficult first time user!!!

[Jewels]

How do you change the sequence of fields in Access 2007???

 

[Arvin Meyer MVP]

How do you change the sequence of fields in Access 2007???

In the Design View, just move them (drag and drop) Then click save. Surely,
that's not very difficult is it?

 

[Armen Stein]

In the Design View, just move them (drag and drop) Then click save. Surely,
that's not very difficult is it?

Or if you mean the sequence of fields as you tab through them, look at
the overall Tab Order, or check the Tab Index property of individual
controls.

Access may seem difficult at first, because it is an application
development environment that is very powerful and flexible. You may
want to look at some of the free templates to get you started.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com

 

[Noëlla Gabriël]

Hi jewels,

you can drag and drop them in the design view, or in the datasheet view. As
the column order or row order isn't important for the database design, you
can reorder them in any view. Remark that the column order in the design
view (= view on the table object) can be different from the column order in
the datasheet view( = view on the recordset object).

 

[AccessVandal via AccessMonster.com]

To re-order the Tab controls sequence, open the form in design view, if the
controls you wish to re-order are in the Detail section, right click on the
Detail Bar of the form. A pop up appears, select “Tab Order…â€, a Tab Order
box appears, on the right side of the listbox are your control order sequence.
On the right side of this listbox, there is a square box just like your
form’s record selector, click on it and drag it to the bottom or top position
of the next control. These will automatically re-order your Tab order. When
finish, save the form.

If you have controls you need to re-order in the Form Header or Form Footer,
you can also reorder them in the “Tab Order†box.

 

[Philip Herlihy]

How do you change the sequence of fields in Access 2007???

You haven't said if you want to change the sequence in a table, a query,
a form or a report.

If it's a table, don't bother. The important thing about tables is the
content and the relationships between tables, not the layout, as users
shouldn't normally be viewing tables directly - that's what forms and
reports are for.

Phil, London

 

[Fred]

In Access, data exists in structures (tables / table structure ) which are
independent of documents/views/printed things etc. This is the exact
opposite of Excell or tables in Word, and so those concepts in Word/Ecsel
are misconceptions if you try to use them in Access. So, when it comes to
the above issues, leave anything you learned in Word/Excel behind or you'll
unnecessarily make your job even tougher.