J
Jewels
How do you change the sequence of fields in Access 2007???
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Arvin Meyer MVP
Jewels said: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?
A
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
N
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).
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).
P
Philip Herlihy
Jewels said: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
F
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.
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.