473,500 Members | 1,929 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Debug SQL Statement

1 New Member
Expand|Select|Wrap|Line Numbers
  1. Private Sub lstTemplates_DblClick(Cancel As Integer) 
  2. Dim sql As String 
  3.  
  4. sql = "INSERT INTO tblDictation ( fldDescriptionOfProcedure, fldVisitNo, 
  5. fldCreator ) " & _ 
  6. "SELECT ( fldDescriptionOfProcedure , " & " Me.txtVisitNO, " & " & 
  7. Me.fldCreator ) " & _ 
  8. "FROM tblDictationLU " & _ 
  9. "WHERE tblDictationLU.fldDictationLUno = " & Me.lstTemplates.Column(0) 
  10. Me.Form.Refresh 
  11.  
  12.  
  13. DoCmd.RunSQL sql 
  14. End Sub
Sep 21 '07 #1
2 1277
Scott Price
1,384 Recognized Expert Top Contributor
Good afternoon, Rob.

For starters, could you tell us what you want this statement to do, and what happens when you try to run it?

Regards,
Scott
Sep 21 '07 #2
NeoPa
32,557 Recognized Expert Moderator MVP
Lose the parentheses ("(" & ")") from the SELECT clause (lines #6 & #7).
Sep 22 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

9
2010
by: Dan Perl | last post by:
Is there a mechanism or an idiom for adding code for debugging so that it can easily be removed in the production code? I am thinking of something similar to the C/C++ preprocessor statements with...
6
3561
by: Tom D. | last post by:
I just got a new computer. I transfered my web site files over and setup my access database system ODBC driver. I've compared settings on both computers. But when I run my web site code on new...
1
2065
by: Robert | last post by:
Simple way of writing debug print statements in your JavaScript code. You need to have enabled popups in your browser. I liked the ability to write to the java console in Netscape 4.x. This,...
5
2836
by: John Smith | last post by:
Sorry if this is the wrong forum... Does anyone know what the difference is between a debug build and an optimised debug build in Visual Studio 2003?
1
1993
by: Keith Clark | last post by:
When I load a csharp program into the MS DbgCLR.exe debugger and trace it everything is fine the first time. Assume now, I change somewhere a code statement in the source file (outside the...
4
1824
by: Malik Arykov | last post by:
Hello, All! how debug embedded javascript?
7
2880
by: Srinivasa Rao | last post by:
I have read in one article that when we compile the application in release mode, all the debug classes and properties will be automatically removed from the code. I tried to implement this thing by...
2
1066
by: Zanna | last post by:
Hi all, I hope I'm hot too OT. When I installed my copy of VisualStudio.net I was able to use, during the debug of a VB.net app, the featore of "jumping" to another statement (changing the...
11
36993
by: serge | last post by:
When i debug a trigger is it possible to add a WATCH on the INSERTED or DELETED? I think not, at least I couldn't figure out a way to do so. Does someone have a suggestion on how I can see the...
2
22835
by: Bill_DBA | last post by:
I have the following stored procedure that is called from the source of a transformation in a DTS package. The first parameter turns on PRINT debug messages. The second, when equals 1, turns on the...
0
7136
marktang
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,...
0
7182
Oralloy
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,...
1
6906
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...
0
5490
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
4923
isladogs
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...
0
4611
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...
0
3106
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1430
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 ...
1
672
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.