471,122 Members | 1,124 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

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

HELP! VB SQL Design Parameter PROBLEMS Arr

Hi to all.
I’m new here and am coming to you from Melbourne Australia.
So a big

Now I am encountering an annoying problem in the SQL builder of the copy of VB.6 that I am using at home.

My problem is that it’s driving me NUTS NUTS NUTS.

I am connected to a data connection within my computer that accesses tables & views from a MS Access file.

I have achieved the connection and can run the SQL builder without problems.

My problem is that I CAN NOT, NOT, NOT! Create parameter queries within the SQL builder environment contained in VB.

I should say that I am most comfortable & qualified as a developer in MS Office applications namely Access & Excel and have some VB qualifications as well.

In Access a parameter query is fundamental & easy to achieve.
When I create a parameter query in SQL builder & try to use a placeholder as an unnamed parameter I get this message saying something like this.

“Unable to derive parameter info from provider!”
I have used the help files extensively. I follow the steps but still receive this message.

I am aware of creating parameter characters in the criteria column & indeed the help files recommend using the “[ and ]” characters as parameter placeholders.

But regardless of what characters I use as place holders I can run a parameter query in the SQL builder of VB!

I can successfully run hard coded queries like searching for surnames Where surname like ‘[b]’%

This returns all records within the criteria of surnames starting with b or B.

But when I try to do what even the help files recommend, syntax like

Where surname =?

Can anyone PLEASE HELP.

Thanx heaps.
Jun 1 '06 #1
0 2035

Post your reply

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

Similar topics

9 posts views Thread by Tom | last post: by
4 posts views Thread by Sarir Khamsi | last post: by
6 posts views Thread by wukexin | last post: by
3 posts views Thread by Colin J. Williams | last post: by
7 posts views Thread by Corepaul | last post: by
5 posts views Thread by Steve | last post: by

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.