473,385 Members | 1,355 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

vb6-Runtime error

3
Tell me what's wrong in the statement
recordset.open "select name from tablename where birthdate=4/3/2007",con
runtime error as :no value is given to 1 or more parameters required.
Apr 18 '07 #1
2 1699
hariharanmca
1,977 1GB
Tell me what's wrong in the statement
recordset.open "select name from tablename where birthdate=4/3/2007",con
runtime error as :no value is given to 1 or more parameters required.

which Database MS Access or Sql Server
Apr 18 '07 #2
hariharanmca
1,977 1GB
Tell me what's wrong in the statement
recordset.open "select name from tablename where birthdate=4/3/2007",con
runtime error as :no value is given to 1 or more parameters required.

Change the QRY like

Expand|Select|Wrap|Line Numbers
  1. "select name from tablename where birthdate= '4/3/2007' "
this
Apr 18 '07 #3

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

Similar topics

4
by: Kieran Benton | last post by:
Hi everyone, I'm just looking into this for my boss (and myself I suppose). What is the current state of VB6 to VB.NET converters out there and what are they? I'm trying to convince our company to...
3
by: Peter | last post by:
Hi, My C# application is supposed to cooperate with legacy VB6 code, but I am little bit worried if and how far C# strings, double etc. in the method interfaces will work smoothly from VB6...
66
by: Mitchell S. Honnert | last post by:
In some recent posts, I've seen people who seem to be waxing nostalgic with respect to the "ease of use" of Visual Basic 6. I can't quite put my finger on it, but they seem to be implying that VB6...
4
by: Kieran Benton | last post by:
Hi everyone, I'm just looking into this for my boss (and myself I suppose). What is the current state of VB6 to VB.NET converters out there and what are they? I'm trying to convince our company to...
9
by: Terry | last post by:
I am converting (attempting) some vb6 code that makes vast use of interfaces. One of the major uses is to be able to split out Read-only access to an obect. Let me give you a simple (contrived)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

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.