by: PJ |
last post by:
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.open application("dtat_motor_connectionstring")
set rs = new adodb.recordset
'Set RS = Conn.Execute(' "exec spcn_update_transactions &...
|
by: ano1optimist |
last post by:
I'm using Access 2000 and have tried Access 2003 front-end to execute
the stored procedure sp_password on SQL Server 2000. I continue to
receive the following message: "The old (current) password...
|
by: Doohan W. |
last post by:
Hi,
I'm now working with DB2, and I can't find out how to execute the
contents of a string Statement, without using a Java/... procedure,
only using SQL statements.
I know that some SQBDs such...
|
by: Nabil |
last post by:
I am new to DB2 and here is my situation.
I have 2 temp tables where I am trying to insert data (from 2 select
statements)
DECLARE v_t1 VARCHAR(50);
DECLARE v_t1 VARCHAR(50);
DECLARE stmt1...
|
by: sjallard |
last post by:
Hi,
I'd like to do something like that (see explanations after the code
snippet) :
Sub mainSub (foo as String)
Dim msScript As New ScriptControl
msScript.Language = "VBScript"
Dim someVar...
|
by: marktm |
last post by:
Would "someSubProcedure" execute in the following example?
Or is the rest of the function ignored once the Return statement is
hit?
Thanks
Fucntion doSomething() As String
Dim strTemp As...
|
by: HeislerKurt |
last post by:
I'm getting the infamous error, "Too few parameters. Expected 2", when
executing an update SQL statement in VBA. I assume it's a SQL syntax
issue, but I can't find the problem, and I used a VBA...
|
by: gmazza |
last post by:
Hi there,
I am trying to insert 4 fields into a table grabbing the 4 fields from a form,
here is my code:
Private Sub LastPaymentAmount_AfterUpdate()
Dim CurrentProject As DAO.Database
Set...
|
by: fungazid |
last post by:
Help help help please
I’m using DBD::mysql, and I want to insert a record into clients table (id, address, and phone-number of a client):
my $str= “?,?,?,,,”;
my...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM).
In this month's session, the creator of the excellent VBE...
|
by: Aftab Ahmad |
last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below.
Dim IE As Object
Set IE =...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: marcoviolo |
last post by:
Dear all,
I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|