By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,456 Members | 1,505 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,456 IT Pros & Developers. It's quick & easy.

record a macro in Access 2000

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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" <as****@home.nl> wrote in message
news:c6**********@news1.tilbu1.nb.home.nl...
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

Nov 12 '05 #2

P: n/a
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" <as****@home.nl> wrote in message
news:c6**********@news1.tilbu1.nb.home.nl...
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

Nov 12 '05 #3

P: n/a
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" <te*********@mps.co.uk> wrote in message
news:Ee********************@karoo.co.uk...
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" <as****@home.nl> wrote in message
news:c6**********@news1.tilbu1.nb.home.nl...
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


Nov 12 '05 #4

P: n/a
True but hardly relevant.

--
Terry Kreft
MVP Microsoft Access
"Claude" <Cl***********@quickpic.net> wrote in message
news:hDSic.32830$aQ6.1716505@attbi_s51...
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" <te*********@mps.co.uk> wrote in message
news:Ee********************@karoo.co.uk...
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" <as****@home.nl> wrote in message
news:c6**********@news1.tilbu1.nb.home.nl...
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



Nov 12 '05 #5

P: n/a
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" <te*********@mps.co.uk> wrote in message
news:J4********************@karoo.co.uk...
True but hardly relevant.

--
Terry Kreft
MVP Microsoft Access

Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.