fancy a giggle..read this thread.. how to unlock a locked userform

[splreece]

Morning all

I have cunningly locked myself out of a userform by doing the following:

- Turning off menus and quick clicks in the settings options
- Turning off shortcut menus and naviation in the form settings
- Loading the form as a modal
- Hiding the navigation pane




So there doesn't seem to be a way to get access to the menus or the navigation pane to edit and update the form.

Any idea how I could do this (I can access vba via alt f11 and have the immediate window, but I only have a couple of buttons on the form itself that close the dbase or save the entry)... so no vba as such to hijack.

 

[Minty]

If you go the the vba window you can "view an object" which will normally bring it up in design view.

 

[CJ_London]

you should have two versions, a production version and a development version. Only apply the 'lockout' settings to the production version.

Alternatively, create another button that reverses the locking code which is hidden in the production version an only visible if you are logged in.

If you have locked yourself out, to unlock do the following (be aware any moderately access savvy user may also know this)

create a new db, open the vb window and create code along the following lines

Sub unlock()
dim db as dao.database

    set db=dbengine.opendatabase("path to the locked db")
    'whatever properties you have set - check the syntax, this is freetyped code e.g.
    db.properties("Allowbypasskey")=true
    db.properties("AllowSpecialKeys")=true

end sub

then hit F5 to run it

 

[gemma-the-husky]

can you open the dbs with the shift key held down?