Ok, I know I've done this, but it doesn't seem to work
for me anymore.
I have a form based on a stored proc, usp_PubsAuthors
and it has a single parameter, @FilterState varchar(2) which
defaults to CA. I put a combo box on the form with a list
of states, and named it to the param, FilterState.
Isn't this supposed to ... auto-negotiate, as Aaron Kempf
says? I've seen this work, but it no longer does. Is there
some simple step I'm missing?
Danny Lesandrini 10 1344
On Mon, 16 Jul 2007 18:24:04 -0600, "dlesandrini"
<da******@comcast.netwrote:
In the InputParametersProperty write:
@FilterState=Forms!YourForm!YourCombobox
-Tom.
>Ok, I know I've done this, but it doesn't seem to work for me anymore.
I have a form based on a stored proc, usp_PubsAuthors and it has a single parameter, @FilterState varchar(2) which defaults to CA. I put a combo box on the form with a list of states, and named it to the param, FilterState.
Isn't this supposed to ... auto-negotiate, as Aaron Kempf says? I've seen this work, but it no longer does. Is there some simple step I'm missing?
Danny Lesandrini
Yeah, that's what I did, but I thought the other method worked, and
Aaron Kempf had said he used it exclusively. It has some advantages.
That InputParameter property loses it's value if you look at it cross-
eyed. Plus, I hate referencing forms like that. It's not so reuseable.
Anyhow, I'm preparing info for a presentation at the Denver Area Access
User's Group this Thursday, and I just wanted to demonstrate the various
methods. I was sure it was possible, but maybe it's not.
Danny
"Tom van Stiphout" <no*************@cox.netwrote in message news:4q********************************@4ax.com...
On Mon, 16 Jul 2007 18:24:04 -0600, "dlesandrini"
<da******@comcast.netwrote:
In the InputParametersProperty write:
@FilterState=Forms!YourForm!YourCombobox
-Tom.
>>Ok, I know I've done this, but it doesn't seem to work for me anymore.
I have a form based on a stored proc, usp_PubsAuthors and it has a single parameter, @FilterState varchar(2) which defaults to CA. I put a combo box on the form with a list of states, and named it to the param, FilterState.
Isn't this supposed to ... auto-negotiate, as Aaron Kempf says? I've seen this work, but it no longer does. Is there some simple step I'm missing?
Danny Lesandrini
"dlesandrini" <da******@comcast.netwrote:
>Anyhow, I'm preparing info for a presentation at the Denver Area Access User's Group this Thursday,
Does Sco Scofield attend those? If so please say hi.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Yup. We're having dinner tomorrow night with the group board. Great guy.
"Tony Toews [MVP]" <tt****@telusplanet.netwrote in message news:0t********************************@4ax.com...
"dlesandrini" <da******@comcast.netwrote:
>>Anyhow, I'm preparing info for a presentation at the Denver Area Access User's Group this Thursday,
Does Sco Scofield attend those? If so please say hi.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
"dlesandrini" <da******@comcast.netwrote in
news:Xs******************************@comcast.com:
Isn't this supposed to ... auto-negotiate, as Aaron Kempf
says?
From what I've read of Aaron Kempf's posts, the fact that he says
it's true is a likely indication that it's completely false.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
On Mon, 16 Jul 2007 21:55:28 -0600, "dlesandrini"
<da******@comcast.netwrote:
Getz et al never mention this "trick". I would be surprised if it
works.
-Tom.
>Yeah, that's what I did, but I thought the other method worked, and Aaron Kempf had said he used it exclusively. It has some advantages. That InputParameter property loses it's value if you look at it cross- eyed. Plus, I hate referencing forms like that. It's not so reuseable.
Anyhow, I'm preparing info for a presentation at the Denver Area Access User's Group this Thursday, and I just wanted to demonstrate the various methods. I was sure it was possible, but maybe it's not.
Danny
"Tom van Stiphout" <no*************@cox.netwrote in message news:4q********************************@4ax.com...
>On Mon, 16 Jul 2007 18:24:04 -0600, "dlesandrini" <da******@comcast.netwrote:
In the InputParametersProperty write: @FilterState=Forms!YourForm!YourCombobox
-Tom.
>>>Ok, I know I've done this, but it doesn't seem to work for me anymore.
I have a form based on a stored proc, usp_PubsAuthors and it has a single parameter, @FilterState varchar(2) which defaults to CA. I put a combo box on the form with a list of states, and named it to the param, FilterState.
Isn't this supposed to ... auto-negotiate, as Aaron Kempf says? I've seen this work, but it no longer does. Is there some simple step I'm missing?
Danny Lesandrini
"dlesandrini" <da******@comcast.netwrote:
>Yup. We're having dinner tomorrow night with the group board. Great guy.
Fabulous. Agreed. And ask him to tell you my embarassing story about the alarm
clock.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
"dlesandrini" <da******@comcast.netwrote in
news:QM******************************@comcast.com:
[re: Aaron Kempf:]
Yeah, he's a bit of a rogue, as I recall, but seems like he uses
ADPs exclusively.
He says lots of things about ADPs and SQL Server that are
nonsensical and wrong.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Well, I haven't been monitoring the group closely for a few years. I remember he
was passionate to the point of impertinence, but don't recall him being wrong. But
as I said, I haven't read him lately and my memory may have softened with time.
Danny
"David W. Fenton" wrote ...
>
[re: Aaron Kempf:]
He says lots of things about ADPs and SQL Server that are
nonsensical and wrong.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
"dlesandrini" <da******@comcast.netwrote:
>Well, I haven't been monitoring the group closely for a few years. I remember he was passionate to the point of impertinence, but don't recall him being wrong. But as I said, I haven't read him lately and my memory may have softened with time.
He definitely got a *lot* more monomaniacal lately. ADP was the answer for
everything including, for example, importing data from Excel.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: ColdCanuck |
last post by:
Greetings!
I am VERY new to DB2 but not Orable, Sybase and SQL Server.
I am trying to call a stored procedure via VB 6 and ADO/OLEDB. But when I
try to execute
|
by: Dave Sisk |
last post by:
I've created a system or external trigger on an AS/400 file a.k.a DB2 table.
(Note this is an external trigger defined with the ADDPFTRG CL command, not
a SQL trigger defined with the CREATE...
|
by: wackyphill |
last post by:
Using ADO.NET Or regular queries on SQL Server, is there a good way of
determining if a Stored Proc will be returning a result set or if it is
a non-query that does all I/O through parameters?
...
|
by: Mike Hutton |
last post by:
I have a rather odd problem.
I have a SP which uses temp. tables along the way, and then returns a
table of results:
CREATE PROCEDURE dbo.usp_myproc(
@pNameList VARCHAR(6000)
)
AS
|
by: David Lozzi |
last post by:
Here is the proc:
CREATE PROCEDURE .
@CID as int,
@Netname as nvarchar(25),
@Return as int OUTPUT
AS
IF EXISTS (SELECT DISTINCT netname FROM computers WHERE CompanyID = @CID AND...
|
by: Rob Meade |
last post by:
Hi all,
I was wondering if anyone could give me a small example of running a stored
procedure with both output and input parameters via asp.net (vb).
I have tried a couple of things, one of...
|
by: Paul M |
last post by:
Hi All,
I'm currently writing a z/OS DB2 Stored Proc in C, using an example from the
IBM Stored Procedure guide (SG24-7083-00). The database calls to read and
update the database work...
|
by: ashtek |
last post by:
Hi,
I have a generic function that executes a stored procedure & returns a
data table.
Code:
===
public static DataTable ExecuteStoredProcedure(string
strProc,SqlParameter paramArray)
{...
|
by: mirandacascade |
last post by:
Questions toward the bottom of the post.
Situation is this:
1) Access 97
2) SQL Server 2000
3) The Access app:
a) sets up pass-thru query
b) .SQL property of querydef is a string, the...
|
by: jamesclose |
last post by:
My problem is this (apologies if this is a little long ... hang in there):
I can define a function in VB.NET with optional parameters that wraps a SQL procedure:
Sub Test(Optional ByVal Arg1...
|
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...
|
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...
|
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,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
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...
|
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...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
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...
| |