Hello,
I've developed a Microsoft Access 2000 database. In a lot of events
Docmd.RunSQL is used. In my database options the 'Confirm' options are
turned off, so I don't have to confirm action queries. The SQL statements
are executed behind the scenes this way.
But When I run the same database with a runtime version of Microsoft Access
2000, I have to confirm the actionqueries that are executed with
Docmd.RUnSQL again. For each SQL statement, the confirmation-question is
shown on the screen. Since I don't see the option to change this settings in
the runtime version I wonder how to solve this?
Does anyone know how to solve this problem?
Greetings,
Chris
2  2974 
hi, Chris,
when working with access runtime and you need to change options you must use
code.
try this:
if application.get Option("Confirm Action Queries") = true then
Application.Set Option ("Confirm Action Queries"), False 'change
parameter to false (don't have to confirm action queries)
end if
Regards
"Remco Groot Beumer" <te***********@ 12move.nl> escreveu na mensagem
news:ce******** **@news2.tilbu1 .nb.home.nl... Hello,
I've developed a Microsoft Access 2000 database. In a lot of events
Docmd.RunSQL is used. In my database options the 'Confirm' options are
turned off, so I don't have to confirm action queries. The SQL statements
are executed behind the scenes this way.
But When I run the same database with a runtime version of Microsoft
Access 2000, I have to confirm the actionqueries that are executed with
Docmd.RUnSQL again. For each SQL statement, the confirmation-question is
shown on the screen. Since I don't see the option to change this settings
in the runtime version I wonder how to solve this?
Does anyone know how to solve this problem?
Greetings,
Chris
Thanks very much...this is exactly what i'm looking for. I'm currently
searching some other settings which can be adjusted like this.
Thankxs very much
"Jimbras" <al****@microso ft.com> schreef in bericht
news:41******** **************@ news.telepac.pt ... hi, Chris,
when working with access runtime and you need to change options you must
use code.
try this:
if application.get Option("Confirm Action Queries") = true then
Application.Set Option ("Confirm Action Queries"), False 'change
parameter to false (don't have to confirm action queries)
end if
Regards
"Remco Groot Beumer" <te***********@ 12move.nl> escreveu na mensagem
news:ce******** **@news2.tilbu1 .nb.home.nl... Hello,
I've developed a Microsoft Access 2000 database. In a lot of events
Docmd.RunSQL is used. In my database options the 'Confirm' options are
turned off, so I don't have to confirm action queries. The SQL
statements are executed behind the scenes this way.
But When I run the same database with a runtime version of Microsoft Access 2000, I have to confirm the actionqueries that are executed with
Docmd.RUnSQL again. For each SQL statement, the confirmation-question is
shown on the screen. Since I don't see the option to change this
settings in the runtime version I wonder how to solve this?
Does anyone know how to solve this problem?
Greetings,
Chris
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: LRW |
last post by:
Having a problem getting a onSubmit function to work, to where it popsup a
confirmation depending on which radiobutton is selected.
Here's what I have:
function checkdel() {
if (document.getElementById"].value=='1') {
confirm('Are you sure you want to delete this file?');
}
}
......
|
by: Hans |
last post by:
Hi!
I have an asp application where I use a lot of javascript for validations
etc and as it is today I use alert, confirm and prompt dialogs. Now we are
adding support for unicode and I have problems with the font used to present
messages in alert, prompts and confirm dialogs. If I for examle paste a
chinese value in a prompt dialog it is...
|
by: Nanda |
last post by:
hi,
I am trying to generate parameters for the updatecommand
at runtime.
this.oleDbDeleteCommand1.CommandText=cmdtext;
this.oleDbDeleteCommand1.Connection =this.oleDbConnection1;
this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_ApplicantName",
dataset.Tables.Columns.DataType, 50,
|
by: Rameshika |
last post by:
Hi All
How can I select a particular row in a datagrid.Where when the user double clicks the data in that row should appear in the corresponding text boxes in runtime
And how can the user insert,delete and edit fields in a datagrid at runtime
Please be kind enough to help me
Thanks
Rameshika
|
by: TJS |
last post by:
javascript "confirm" fires after deletion instead of before deletion.
how do I get this to stop the processing ?
code
==================
Sub ShowAlert(ByVal s As string)
RegisterClientScriptBlock("CSP-showconfirm-function", _
"<s"+"cript language=""JavaScript"">" & vbCrLf & _
| | |
by: zfraile |
last post by:
I'm getting this error from the JIT compiler at runtime, but only on my boss'
machine, not my development machine. I believe the error is generated from a
call to an Excel object, but I can't tell why or what specific action on the
object is causing it.
We both are running version 2.0 of the .net framework with Office 2003
installed,...
|
by: tfsmag |
last post by:
Okay, I have a project management app i'm writing and in the left hand
menu i have a treeview control that is populated with each project...
in child nodes under each project node I have an "edit" and a "delete"
node. I have the functionality of the edit and delete working fine, my
issue is now however that I cannot seem to find a way to add...
|
by: Iain |
last post by:
Hi All
I am witing a web app using Delphi developer 2006 (C# app) and I have a
datagrid. Excuse the numptyness of the question. I have a datagrid with
the ability to Insert, Edit/Update and Delete records.
The following is the datagrid definition
<asp:datagrid id="Livery"
runat="server"
|
by: mamun |
last post by:
Hi All,
I have the following situation and am looking for answer in C#.
I have a datagrid and putting checkbox next to each record. In the
header I have a Delete button.
I want users to checkchekboxes and click the Delete button. That will
show a confirmation dialog message with the items they choose to
delete.
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
