record a macro in Access 2000

[asd987]

Hi,

I'm now working with Access 2000 (English) and I'm searching for an option
which I can't find. I used to work with Acces 97 (Dutch) and there was a
possibility to record a macro. I used this to load a textfile into a table.
You had to follow all the steps once and then they were recorded by Access.
The next time you could play this sequence of commands.

I searched in Access 2000 but couldn't find the option. Probably also due to
the language. Can anyone help me?

Thanks,

Sjoerd

[Tom Farmen]

Re: record a macro in Access 2000

I'm not a 100% sure, but I don't think there is one. At least I haven't been
able to find one browsing through all my books and searching the Internet.

Tom


"asd987" <asd987@home.nl > wrote in message
news:c63o27$4hp $1@news1.tilbu1 .nb.home.nl...[color=blue]
> Hi,
>
> I'm now working with Access 2000 (English) and I'm searching for an option
> which I can't find. I used to work with Acces 97 (Dutch) and there was a
> possibility to record a macro. I used this to load a textfile into a[/color]
table.[color=blue]
> You had to follow all the steps once and then they were recorded by[/color]
Access.[color=blue]
> The next time you could play this sequence of commands.
>
> I searched in Access 2000 but couldn't find the option. Probably also due[/color]
to[color=blue]
> the language. Can anyone help me?
>
> Thanks,
>
> Sjoerd
>
>[/color]

[Terry Kreft]

Re: record a macro in Access 2000

I think you're mistaken you can record macros in Excel, Word etc, but I've
never known a version of Access in which you could record macros.


--
Terry Kreft
MVP Microsoft Access


"asd987" <asd987@home.nl > wrote in message
news:c63o27$4hp $1@news1.tilbu1 .nb.home.nl...[color=blue]
> Hi,
>
> I'm now working with Access 2000 (English) and I'm searching for an option
> which I can't find. I used to work with Acces 97 (Dutch) and there was a
> possibility to record a macro. I used this to load a textfile into a[/color]
table.[color=blue]
> You had to follow all the steps once and then they were recorded by[/color]
Access.[color=blue]
> The next time you could play this sequence of commands.
>
> I searched in Access 2000 but couldn't find the option. Probably also due[/color]
to[color=blue]
> the language. Can anyone help me?
>
> Thanks,
>
> Sjoerd
>
>[/color]

[Claude]

Re: record a macro in Access 2000

No, but you can create macros then covert them into code.

OR

You can use the various control wizards to get code ideas started.




"Terry Kreft" <terry.kreft@mp s.co.uk> wrote in message
news:EeednWPJe4 WZ5hvdSa8jmA@ka roo.co.uk...[color=blue]
> I think you're mistaken you can record macros in Excel, Word etc, but I've
> never known a version of Access in which you could record macros.
>
>
> --
> Terry Kreft
> MVP Microsoft Access
>
>
> "asd987" <asd987@home.nl > wrote in message
> news:c63o27$4hp $1@news1.tilbu1 .nb.home.nl...[color=green]
> > Hi,
> >
> > I'm now working with Access 2000 (English) and I'm searching for an[/color][/color]
option[color=blue][color=green]
> > which I can't find. I used to work with Acces 97 (Dutch) and there was a
> > possibility to record a macro. I used this to load a textfile into a[/color]
> table.[color=green]
> > You had to follow all the steps once and then they were recorded by[/color]
> Access.[color=green]
> > The next time you could play this sequence of commands.
> >
> > I searched in Access 2000 but couldn't find the option. Probably also[/color][/color]
due[color=blue]
> to[color=green]
> > the language. Can anyone help me?
> >
> > Thanks,
> >
> > Sjoerd
> >
> >[/color]
>
>[/color]

[Terry Kreft]

Re: record a macro in Access 2000

True but hardly relevant.

--
Terry Kreft
MVP Microsoft Access


"Claude" <ClaudeVerwink@ quickpic.net> wrote in message
news:hDSic.3283 0$aQ6.1716505@a ttbi_s51...[color=blue]
> No, but you can create macros then covert them into code.
>
> OR
>
> You can use the various control wizards to get code ideas started.
>
>
>
>
> "Terry Kreft" <terry.kreft@mp s.co.uk> wrote in message
> news:EeednWPJe4 WZ5hvdSa8jmA@ka roo.co.uk...[color=green]
> > I think you're mistaken you can record macros in Excel, Word etc, but[/color][/color]
I've[color=blue][color=green]
> > never known a version of Access in which you could record macros.
> >
> >
> > --
> > Terry Kreft
> > MVP Microsoft Access
> >
> >
> > "asd987" <asd987@home.nl > wrote in message
> > news:c63o27$4hp $1@news1.tilbu1 .nb.home.nl...[color=darkred]
> > > Hi,
> > >
> > > I'm now working with Access 2000 (English) and I'm searching for an[/color][/color]
> option[color=green][color=darkred]
> > > which I can't find. I used to work with Acces 97 (Dutch) and there was[/color][/color][/color]
a[color=blue][color=green][color=darkred]
> > > possibility to record a macro. I used this to load a textfile into a[/color]
> > table.[color=darkred]
> > > You had to follow all the steps once and then they were recorded by[/color]
> > Access.[color=darkred]
> > > The next time you could play this sequence of commands.
> > >
> > > I searched in Access 2000 but couldn't find the option. Probably also[/color][/color]
> due[color=green]
> > to[color=darkred]
> > > the language. Can anyone help me?
> > >
> > > Thanks,
> > >
> > > Sjoerd
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]

[Claude]

Re: record a macro in Access 2000

Sorry Terry for sending it to you direct..I hit the reply instead of reply
to group.

well, superficially yes, but not necessarily..

I was hoping that perhaps this is what the original poster might have meant
and had been confused about what he thought he had did in the past. The
sbit about transfering text hit a note of familiarity. Doing the macro first
which is akin to basically selecting different options in the macro (not
recording exactly - but going through the motions) and then converting it to
code.

"Terry Kreft" <terry.kreft@mp s.co.uk> wrote in message
news:J4GcnSs7fr NATRHdSa8jmw@ka roo.co.uk...[color=blue]
> True but hardly relevant.
>
> --
> Terry Kreft
> MVP Microsoft Access
>
>
>[/color]