Is Keyboard option available in MS Access Runtime?

C

cubicle

In MS Access, if select Options then Keyboard tab, Move After Enter allows
Next Field or Next Record option. Is this option allowed in MS Access
Runtime? If it is not, is there any workaround/alternative?

Thank you for your help!

New User
 
A

Albert D. Kallal

cubicle said:
In MS Access, if select Options then Keyboard tab, Move After Enter allows
Next Field or Next Record option. Is this option allowed in MS Access
Runtime? If it is not, is there any workaround/alternative?

Thank you for your help!
Click to expand...

Yes, you can generally set most, if not all of the options. The a2003 help
is REALLY nice in this regards.

In the code editor, simply hit f1, and type in

set options

The 1st hit will be

setup startup options and options in code...

cut/paste from this help file we get:

Keyboard Tab

Option String argument
Move after enter Move After Enter

Behavior entering Behavior Entering Field
field

Arrow key behavior Arrow Key Behavior

Cursor stops at Cursor Stops at First/Last Field
first/last field


So, in your startup code, a typical runtime setup will look
like:

On Error Resume Next

Application.SetOption "ShowWindowsInTaskbar", False
Application.SetOption "ShowWindowsInTaskbar", False
Application.SetOption "Themed Form Controls", True
Application.SetOption "Show Startup Dialog Box", False
Application.CommandBars.AdaptiveMenus = False

Application.SetOption "Move After Enter", 1 <---- here...

Options follow the same as the options menu, so:

0 = don't move
1 = Next field
2 = next record
 
C

cubicle

Hi Albert,

Thank you for your response! Forgot to mention some more details:

It is MS Access 97, not a2003.

The MS Access Runtime that we have is a compiled one, so access to code
editor is not possible.

Any workaround/alternative?

Regards,

Cubicle
 
C

cubicle

Is it possible to change it in the runtime (in the utility.mda or in registry)?
Regards,
cubicle
 
A

Albert D. Kallal

cubicle said:
Hi Albert,

Thank you for your response! Forgot to mention some more details:

It is MS Access 97, not a2003.

The MS Access Runtime that we have is a compiled one, so access to code
editor is not possible.

Any workaround/alternative?
Click to expand...

Well, you could just create a mdb that runs the above code, and then copy to
the target machine, and run it....

(I would test it with error handing turned off, as I don't have the
list/options for a97 with me anymore...that a very old version now).

Remember, the runtime is simply a version of ms-access, and there is not a
particular "connection" between the runtime and the actual application.

So, you could still give the above a try on the target computer, and see if
it does the trick...
 
Top