Web Development

General discussion

Locked

Access 97 Runtime - controlling options

By martil ·
I generated a runtime version of a database, and when it is installed, all the Action Queries request confirmation. That option is not checked in Options on my system. How do you turn it off in the runtime version. If need VBA code, what is the code?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Access 97 Runtime - controlling options

by acwiz In reply to Access 97 Runtime - contr ...

Not a good idea to leave warnings off all the time. Here are two sub's I use where I need to turn the warnings and hourglass on and off

Sub HgOffWarnOn()
On Error GoTo HgOffWarnOn_ERR
DoCmd.SetWarnings True
DoCmd.Hourglass False
ExitSub

HgOffWarnOn_ERR:
MsgBox "An error has occurred.: " & Error$
Resume Next
End Sub


Sub HgOnWarnOff()
On Error GoTo HgOnWarnOff_ERR
DoCmd.SetWarnings False
DoCmd.Hourglass True
Exit Sub

HgOnWarnOff_ERR:
MsgBox "An error has occurred.: " & Error$
Resume Next
End Sub

Collapse -

Access 97 Runtime - controlling options

by martil In reply to Access 97 Runtime - contr ...

The question was auto-closed by TechRepublic

Collapse -

Access 97 Runtime - controlling options

by martil In reply to Access 97 Runtime - contr ...

This question was auto closed due to inactivity

Related Discussions

Related Forums