using VBA to set a keyboard option setting

[Paul]

Is there a way I can get VBA (Access 2003) to set a keyboard option setting
on the desktops of all users of an application?

I would like to set the "Behavior entering field" setting in the
Tools-Options-Keyboard (tab) dialog set to "Go to end of field", and I would
like to do it using VBA. Is there a way to accomplish this?

Thanks in advance,

Paul

 

[PieterLinden via AccessMonster.com]

Is there a way I can get VBA (Access 2003) to set a keyboard option setting
on the desktops of all users of an application?

I would like to set the "Behavior entering field" setting in the
Tools-Options-Keyboard (tab) dialog set to "Go to end of field", and I would
like to do it using VBA. Is there a way to accomplish this?

Thanks in advance,

Paul

You'll have to figure out what the option is called...

code stolen from Allen Browne...
'Note: Record confirmations need to be on. When opening the database:
' If Not Application.GetOption("Confirm Record Changes") Then
' Application.SetOption ("Confirm Record Changes"), True
' End If

 

[PieterLinden via AccessMonster.com]

Is there a way I can get VBA (Access 2003) to set a keyboard option setting
on the desktops of all users of an application?

[quoted text clipped - 6 lines]

Paul

something like...
Application.SetOption "Behavior entering field", "Go to end of field"

 

[Linq Adams via AccessMonster.com]

You have to understand that changing options individual users have set is
never a good idea. What you consider as needed for your database may royally
screw up another database that these users may be using. If you're going to
do this you need to find a way to save their original settings and reset them
when they exit your app.

 

[Paul]

Thanks for suggesting the Application.SetOption approach, Pieter.

After some experimentation, I found that

Application.SetOption "Behavior entering field", 2

would do the trick.

Paul

Is there a way I can get VBA (Access 2003) to set a keyboard option
setting
on the desktops of all users of an application?

[quoted text clipped - 6 lines]

Paul

something like...
Application.SetOption "Behavior entering field", "Go to end of field"

 

[Paul]

You have to understand that changing options individual users have set is
never a good idea.

Never? How can you be sure if you don't know anything about the workgroup
for which I'm doing this, or my role in that workgroup?