Hello to everyone on this site. I am a new member and i am concerning myself with access2003 and VBA. But i have a problem with macros. As the matter of fact the issue is the following:
is there any possile way to give the macro name (in autokeys macro) which will begin with the keyboard button: ALT. Or i would like to ask u how to disable the buttons:ALT+ENTER and consequently stop the user from using Properties( ALT + ENTER gives properties of the object).
Thank u very much
Vlado from Macedonia

There's no way to create a macro with the alt key, you could use the KeyDown event to trap this in a form to block the alt-enter or create your own shortcut.
The easiest way to stop the user viewing/editing the properties of a object on a form is to set the "Allow design changes" property of the form to "only in design mode".

The code below will do this for all forms in your database.


Public Function AllFormsDesignViewOnly()
Dim doc As DAO.Document
Dim db As DAO.Database

On Error Resume Next
Set db = CurrentDb
DoCmd.Hourglass True
Echo False

For Each doc In db.Containers("Forms").Documents
DoCmd.OpenForm doc.Name, acDesign
Forms(doc.Name).AllowDesignChanges = False
DoCmd.Close acForm, doc.Name, acSaveYes
Next

MsgBox "Disabled AllowDesignChanges for all forms when not in edit mode!!", vbInformation + vbMsgBoxSetForeground

Set db = Nothing
Echo True
DoCmd.Hourglass False

End Function