473,395 Members | 1,616 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,395 software developers and data experts.

A97: Importing AutoExec macro from Access 2.0

MLH
I have problems getting the CTRL-d, CTRL-w and other 'hotkey combo'
assignments to work in Access 97. I just imported the autoexec macro
directly from Access 2.0, so its no surprise.

Some are really simple, though... For instance, CTRL-w should just
launch ScreenDump(). I can run the FN by calling it this way...
dim y as variant
y = screendump()

But I cannot get the CTRL-w to launch it the way it did in Access 2.0.

Ideas?
Nov 13 '05 #1
5 1854
MLH
BIG OOPS...

I'm really concerned with the AutoKeys macro...
I inadvertently referred to it as the AutoExec macro
in the main thread. Sorry. AutoKeys is what I'm trying
to make work.
Nov 13 '05 #2
There's not really enough info here to help with any degree of
certainty. Here's how it should be.
Your macro name (you may need to go View...Macro Names to see this
column) should be: ^w
Your action should be: RunCode
Function Name: ScreenDump() (not =Screendump or anything like that).
The name of the macro object in the database window should be: AutoKeys
(not to be confused with the macro name column in macro design)

Close the database and re-open it to activate the autokeys macro.

It should work.

Nov 13 '05 #3
MLH
I did all that with the imported macro.
I think I'll blow it away, recreate an
AutoKeys macro from scratch (and
from within Access 97) and try it again.

Everything you said was right. That's
how I had it set up in Access 2.0 and
it "looked" like it was just the same
way after the import.

Will fill U in.

Nov 13 '05 #4
MLH
I sure hate to say it, but it definitely does NOT work. I restarted
Access 97 after building the new autokeys macro. I tried setting
macro names of ^4 and ^w. Nothing worked. Something is
awry. Are there any settings that might disable autokeys macro?

There's not really enough info here to help with any degree of
certainty. Here's how it should be.
Your macro name (you may need to go View...Macro Names to see this
column) should be: ^w
Your action should be: RunCode
Function Name: ScreenDump() (not =Screendump or anything like that).
The name of the macro object in the database window should be: AutoKeys
(not to be confused with the macro name column in macro design)

Close the database and re-open it to activate the autokeys macro.

It should work.


Nov 13 '05 #5
MLH
I even set up a macro to RunCode on the function
just by calling the macro with the RunMacro method.

It worked just fine.

I don't understand why my macro names in the macro
group (IE, ^a, ^g, +4, etc...) are not causing the macro
code in the named macros inside the autokeys macro
to be invoked. Its a mystery.
Nov 13 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Christoph Sticksel | last post by:
Hi, I'm having problems with attaching two tables stored in an SQL Server 2000 to an Access 97 database. It worked well for all other tables except those two. This is what I did: Choose the...
4
by: mvivar | last post by:
Hi everybody: This will be not easy to explain as my mother language is not english, so my apologies in advance if it sounds confusing. We have a database access 97 wich controls time of...
6
by: MLH | last post by:
Did A97, perchance, do away with the need for an AutoExec macro to initiate an autoexec sequence for databases? Or, must we still suffer with that hideous macro?
18
by: MLH | last post by:
I have an A97 app that automatically sends eMail using OutLook Express. Each installation requires the user to reconfigure Outlook Express to avoid prompts waiting for them to authorize or deny...
11
by: MLH | last post by:
Anyone ever experiement importing WAB data directly into A97? Would lke a chance to look at any work done in this arena.
2
by: CDMAPoster | last post by:
I'm putting out some more experimental software. When creating PDF files from A97 I often have a static layout consisting of PDF commands along with PDF commands that are dependent on the data...
5
by: dick | last post by:
I can't seem to get AutoExec to run a function. Per an article on this group, I: 1) built a boolean function in a module that simply issues a MsgBox, then returns True 2) in AutoExec macro, I...
6
by: Takeadoe | last post by:
Dear NG, Can someone assist me with writing the little code that is needed to run an update table query each time the database is opened? From what I've been able to glean from this group, the...
1
by: Pittsford | last post by:
I used Sendkeys extensively in Access 97 to enter repetitive text into fields directly in a table. I am now using Access 2000 and none of the SendKeys macros work. I allowed Access to "convert" the...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
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...
0
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...
0
tracyyun
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...
0
agi2029
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,...

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.