General discussion
-
CreatorTopic
-
March 23, 2000 at 10:52 pm #2082140
Access 97 Runtime – controlling options
Lockedby martil · about 24 years, 11 months ago
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?
Topic is locked -
CreatorTopic
All Comments
-
AuthorReplies
-
-
March 23, 2000 at 11:17 pm #3901603
Access 97 Runtime – controlling options
by kempj · about 24 years, 11 months ago
In reply to Access 97 Runtime – controlling options
If you are calling the action query in a macro or in vb then you can turn off messages either by using the command SetWarnings in the macro before running the action query or using an equivalent in vb
Hope this helps-
September 20, 2000 at 7:03 pm #3741307
Access 97 Runtime – controlling options
by martil · about 24 years, 5 months ago
In reply to Access 97 Runtime – controlling options
The question was auto-closed by TechRepublic
-
-
April 10, 2000 at 11:44 pm #3896641
Access 97 Runtime – controlling options
by irishtlr · about 24 years, 10 months ago
In reply to Access 97 Runtime – controlling options
You can also include YOUR system.mdw file in your distribution. This stores whether confirmations are on or not
-
September 20, 2000 at 7:03 pm #3741308
Access 97 Runtime – controlling options
by martil · about 24 years, 5 months ago
In reply to Access 97 Runtime – controlling options
The question was auto-closed by TechRepublic
-
-
May 3, 2000 at 12:38 am #3898973
Access 97 Runtime – controlling options
by crowmoor · about 24 years, 9 months ago
In reply to Access 97 Runtime – controlling options
If you just dubbelklick on an actionquery then its more difficult but if you run them from a form just add the following code to the clickevent on your button (or the event that you use)
DoCmd.SetWarnings False ‘turns warnings off
(your code here eg DoCmd.OpenQuery “QueryName”
DoCmd.OpenReport “ReportName”)DoCmd.SetWarnings True ‘turns warnings on
If you use Macro then include
SetWarnings with parameter False first and
parameter True Last.If you have more questions then feel fre to mail me.
Jesper Kr?khede
-
September 20, 2000 at 7:03 pm #3741309
Access 97 Runtime – controlling options
by martil · about 24 years, 5 months ago
In reply to Access 97 Runtime – controlling options
The question was auto-closed by TechRepublic
-
-
May 16, 2000 at 2:57 am #3895872
Access 97 Runtime – controlling options
by mcorr · about 24 years, 9 months ago
In reply to Access 97 Runtime – controlling options
The best answer to this is to set the program options the way you want them when the program starts. Then if you are nice you set them back the way they were when you started.
1. Declare globals (in a module) to hold the initial states of the options.
Public OPTIONRecChanges As Variant
Public OPTIONActionQueries As Variant2. Read initial values in FormOpen of first form (splash, switchboard, etc.)
‘ Get the options for this location
OPTIONRecChanges = Application.GetOption(“Confirm Record Changes”)
OPTIONActionQueries = Application.GetOption(“Confirm Action Queries”)3. Set desired values in same event as #2.
‘ Now set the confirm options off
Application.SetOption “Confirm Record Changes”, False
Application.SetOption “Confirm Action Queries”, False4. Make a close program event that the switchboard or other form calls to close. Reset the initial values found in #2.
‘ Set the confirm options to their state when started.
Application.SetOption “Confirm Rec-
September 20, 2000 at 7:03 pm #3741310
Access 97 Runtime – controlling options
by martil · about 24 years, 5 months ago
In reply to Access 97 Runtime – controlling options
The question was auto-closed by TechRepublic
-
-
May 21, 2000 at 8:24 pm #3895515
Access 97 Runtime – controlling options
by mickfranzen · about 24 years, 9 months ago
In reply to Access 97 Runtime – controlling options
Get the SQL script for the query (You may already have it)
run theis piece of code (short an simple)
Dim dbsdb as database
set dbsdb = currentdb
dbsdb.execute (SQL)And query will run
-
September 20, 2000 at 7:03 pm #3741311
Access 97 Runtime – controlling options
by martil · about 24 years, 5 months ago
In reply to Access 97 Runtime – controlling options
The question was auto-closed by TechRepublic
-
-
August 11, 2000 at 2:42 am #3771446
Access 97 Runtime – controlling options
by acwiz · about 24 years, 6 months ago
In reply to Access 97 Runtime – controlling options
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
ExitSubHgOffWarnOn_ERR:
MsgBox “An error has occurred.: ” & Error$
Resume Next
End SubSub HgOnWarnOff()
On Error GoTo HgOnWarnOff_ERR
DoCmd.SetWarnings False
DoCmd.Hourglass True
Exit SubHgOnWarnOff_ERR:
MsgBox “An error has occurred.: ” & Error$
Resume Next
End Sub-
September 20, 2000 at 7:03 pm #3741312
Access 97 Runtime – controlling options
by martil · about 24 years, 5 months ago
In reply to Access 97 Runtime – controlling options
The question was auto-closed by TechRepublic
-
-
September 20, 2000 at 7:03 pm #3741306
Access 97 Runtime – controlling options
by martil · about 24 years, 5 months ago
In reply to Access 97 Runtime – controlling options
This question was auto closed due to inactivity
-
-
AuthorReplies