Access 97-macro to hide columns and sort

G

Guest

I use Access 97 and would like to create a macro to hide columns and sort by
eg.field1,and field 2,ascending. Is a macro the best way to do it?and if so
how do I do it?
 
S

Steve Schapel

Maud0361,

No, this probably does not involve the use of macros. This is a job for
a Query. Make a new query based on your table, add only the fields from
the table that you are interested in, and within the query design apply
any sorting and calculations required. You would then typically base a
Form or Report on the query, for the purposes of viewing or editing the
data.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA- Excel Programming:- 0
Print macro that hides rows before printing 1
Sorting a column in a spreadsheet 2
Hide columns based on row values 2
automating a set of macros 2
Excel How to preserve column fields in a specific order in a pivot table? 2
Macro to Hide columns 3
Change macro button text when macro is invoked. 2

Top