473,322 Members | 1,314 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

record a macro in Access 2000

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
5 4378
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
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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: asd987 | last post by:
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...
2
by: Pete | last post by:
In Access 95/97 I used to be able to create pull down menus (File,Edit ...) from a macro. It seems there used to be some wizard for that. However in Access 2000 it seems you have to build your...
0
by: Jim Caddy | last post by:
Hi all, I have an Autokeys Macro that's all in a sudden not working in access 2000 when pressing the key combinations. Open up the database in Access 2002 and the macro works, reopen the...
3
by: Randy | last post by:
I have been able to set up a Find Record Button on my switchboard to take me to a form with the correct case number by using a parameter query and macro. When I try to run the Find Record button...
1
by: paul.hanti | last post by:
This board has been a plethora of information. Thanks to all that respond! I have a quick question regarding the built-in OutputTo macro. I've built a shared database in Access 2003 (in Access...
5
by: Bill | last post by:
This database has no forms. I am viewing an Access table in datasheet view. I'd like to execute a macro to execute a function (using "runcode"). In the function, I'll reading data from the record...
19
by: Genalube | last post by:
I have an application that will produce a Word document based on five separate queries this has required that I create a ADODB connection: 'Create connection to current database Dim Conn As...
3
by: Nicolas Boretos | last post by:
Hello, Beginning access user here. I am displaying the table and its existing form at the same time. I would like to double-click on a row in the table and have the form go to/display the...
10
by: MLH | last post by:
Suppose, in a multi-user environment, you have append query SQL in a VBA procedure that looks like INSERT INTO MyTable... and the next line reads MyVar=DMax("","MyTable... You can never be...
4
by: Bad Horsey | last post by:
Windows XP MS Access 2000 Hello folks. First timer here. Have a problem with a form. I am trying to open a report using a button on a form. The report will use information from a table...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.