Hi to all.
I’m new here and am coming to you from Melbourne Australia.
So a big
HELLO 2 ALL.
Thanx for having me here. TOP forum you guy's have here!
Can anyone answer my problem? Please.
I am trying to create a parameter query in the SQL designer of my VB.6
Although I have studied VB to a certain level most of my work has been in MS Office applications using VBA.
In MS Access when designing a query in the criteria column all I have to do to create a parameter query that prompts for input in the form of a standard input box is write an expression like this
Like [] & “*”
So in say the surname field of a query in the criteria section that’s what I would write to create an un-named parameter that prompts for input when run.
But doing this in the SQL designer grid of VB is reliant upon me naming the parameter characters, which I understand and have done but when I do this I get a can not derive parameter info from provider.
Do I need to declare the parameters in the actual coding of the query?
If so in which event would I do this?
Again all I am trying to achieve is an input box that prompts for parameter information to run the query.
Once “HOPEFULLY” having achieved this later I will or would like to use a control as the input of the parameter query just as I do when creating custom parameter input forms in MS Access.
I do that by stating in the criteria column of a given field something like this which points to the control a user would use.
Like [Form1!Combo1.Va lue] & “*”
So if anyone can help me achieve this in SQL design of VB I would be MOST GREATFUL.
GREAT FORUM.
THANX
I’m new here and am coming to you from Melbourne Australia.
So a big
HELLO 2 ALL.
Thanx for having me here. TOP forum you guy's have here!
Can anyone answer my problem? Please.
I am trying to create a parameter query in the SQL designer of my VB.6
Although I have studied VB to a certain level most of my work has been in MS Office applications using VBA.
In MS Access when designing a query in the criteria column all I have to do to create a parameter query that prompts for input in the form of a standard input box is write an expression like this
Like [] & “*”
So in say the surname field of a query in the criteria section that’s what I would write to create an un-named parameter that prompts for input when run.
But doing this in the SQL designer grid of VB is reliant upon me naming the parameter characters, which I understand and have done but when I do this I get a can not derive parameter info from provider.
Do I need to declare the parameters in the actual coding of the query?
If so in which event would I do this?
Again all I am trying to achieve is an input box that prompts for parameter information to run the query.
Once “HOPEFULLY” having achieved this later I will or would like to use a control as the input of the parameter query just as I do when creating custom parameter input forms in MS Access.
I do that by stating in the criteria column of a given field something like this which points to the control a user would use.
Like [Form1!Combo1.Va lue] & “*”
So if anyone can help me achieve this in SQL design of VB I would be MOST GREATFUL.
GREAT FORUM.
THANX