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 5 2855
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
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
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*********@mp s.co.uk> wrote in message
news:Ee******** ************@ka roo.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
True but hardly relevant.
--
Terry Kreft
MVP Microsoft Access
"Claude" <Cl***********@ quickpic.net> wrote in message
news:hDSic.3283 0$aQ6.1716505@a ttbi_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*********@mp s.co.uk> wrote in message news:Ee******** ************@ka roo.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
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*********@mp s.co.uk> wrote in message
news:J4******** ************@ka roo.co.uk... True but hardly relevant.
-- Terry Kreft MVP Microsoft Access This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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 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...
|
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 menus by
customizing a toolbar. With this method you have to create a separate
macro for every single menu and sub menu. The old method would allow
me to include several menus (File/ print/ page setup ...) all within
one macro. Now it seems I...
|
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 database in Access 2000 again and the macro
doesn't work again. It will work by double clicking the macro in the
database window.
Created a new database in Access 2000 and made a Autokeys macro for testing,
this didn't work either. Opened the new...
|
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 from the macro on the form I
want to find the record in it just sits there and does not run.
Could someone tell me how to fix this? Please be specific as I am new
to Access.
|
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 2000 file format)
that resides on a shared network drive. This OutputTo macro is
essentially setup to export one small table to an Excel spreadsheet
once a user clicks a command button on the switchboard. Another user
and I (both of us have...
| |
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 the
cursor was on in the datasheet at the time I executed the macro.
So, the questions are: 1) In the macro, how to I get my hands on the
record key or record data of the record the cursor was on in the
datasheet at the time I executed the...
|
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 ADODB.Connection
Set Conn = CurrentProject.Connection
There are five separate recordSets, one for each query. The record sets each fill out a table in the Word document, utilizing bookmarks. Some areas of the Word document have repeating...
|
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 selected record.
tia,
nikos
|
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 which is particular to the record being viewed on the form at the time. I want to include any data that the user has input into the form directly before clicking the button. For this reason, I am using the requery function in the macro before...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |