Re: Macro recording in Access?

Tech-Archive recommends: Speed Up your PC by fixing your registry

"Destin Richter" <DestinRichter@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C0DB2E7A-22D3-4A5F-B44D-2521E10860DE@xxxxxxxxxxxxxxxx
> Stargate, as an example, you can build a command button that runs a macro.

Yeah, the command button thing is easy (it's the rest that's going to be
tough I predict! <g>).

> The macro runs a single ApplyFilter command that only shows you records
that
> meet certain criteria. For example, I have a field called Class on my
form
> that is a drop down list of values...Clients, Friends, etc. My
ApplyFilter
> condition might say "ClassID=5" or "ClassID=7" depending on which records
I
> want to show (whether it is just friends or just clients I want to see).
> Does that help?

Well, theory always does, yes, thanks. But without the recorder, it's going
to be tough to know how Access translates these types of things. I mean, I
might be able to eventually figure out how to do the sort thing, but it's
going to be really nifty (_not_) to see how I'm going to manage everything
in Access without that recorder <sigh>. The trouble with the vb help file
is that you need to know what to search for and without the recorder giving
us clues on what Access VB calls things, I foresee challenges ahead. And I
thought Excel Vb was hard! <g>

Thanks much! I'll keep plugging away. Still can't afford any courses (but
I can still hope to one day manage it). :oD

> Destin Richter
> richter@xxxxxxxxxxxxx
>
> "StargateFanFromWork" wrote:
>
> > I'm finding Access so fascinating. I'm understanding it so much more
now
> > with this last year's tremendous experience in really working with Excel
and
> > some vb coding I've learned to do, though still quite rudimentary.
That's
> > the trouble I ran into today. I was trying to put a SORT ASCENDING
button
> > into a form so that all our users could easily sort the records. But
the
> > trick I usually use in Excel doesn't seem to exist in Access (?). I
could
> > record a lot of events in Excel and that's how I've been learning a lot
of
> > code. But we don't seem to have that function in Access (or it's hidden
> > (?)). How does one get simple code like "sort ascending", for example.
> > Where would we go to build simple events?
> >
> > TIA.
> >
> >
> >


.

Quantcast