|
|
|
|
|||||
|
|
|
|
|
|
|||
| Welcome
to Tech Support Forum home to more then 136,000 problems solved. Issues
have included: Spyware, Malware, Virus Issues, Windows, Microsoft,
Linux, Networking, Security, Hardware, and Gaming Getting your
problem solved is as easy as: 1. Registering for a free account 2. Asking your question 3. Receiving an answer Registered members: * See fewer ads. * And much more..
|
| Want to know how to post a question? click here | Having problems with spyware and pop-ups? First Steps |
|
|||||||
| Web Design & Programming Discussion of web design, and server-side & client-side scripting |
 |
|
|
LinkBack | Thread Tools |
01-01-2008, 04:19 AM
|
#1 (permalink) |
|
Registered User
Join Date: Jan 2008
Posts: 1
OS: xp
|
vb6 ado/ sql HELP
Heya, the bold line below gives me a syntax error. Anyone got any ideas why?
Private Sub cmdClockOut_Click() Dim cn2 As New ADODB.Connection Dim rs2 As New ADODB.Recordset 'Connect to database cn2.Provider = "Microsoft Jet 4.0 OLE DB Provider" cn2.ConnectionString = "Data Source='\Thorpe Park ICT6\TP.mdb';" cn2.Open rs2.Open "Select * from tbl_TimeSheet WHERE Employee_Number = '" & lblEmployeeNumber.Caption & "' AND Date = '" & Date & "'", cn2, adOpenDynamic End Sub |
|
     
|
| Important Information |
|
Join the #1 Tech Support Forum Today - It's Totally Free!
TechSupportForum.com is a leading support website for your computer needs. We offer free, friendly and personalized computer support. Why pay to have your computer fixed when you can do it for free. Join TechSupportforum.com Today - Click Here |
|
| Thread Tools | |
|
|
