|
 |
access thread: Access Project Combo Box
Message #1 by "Tom Abel" <tabel@u...> on Thu, 19 Jul 2001 10:12:55 -0400
|
|
Hello List,
I am trying to make a combo box display different choices based on the
values of another control on the same form.
In Access I could do this fairly easily by placing the control name directly
into the combo box query. In and Access Project, it is a different story
because the front-end does not have access to back-end views.
One approach I tried: Use a stored procedure as the source of the combo box.
I can place a stored procedure name in the row source in the combo box, and
that works fine. However if I want to pass it a parameter it appears that
the combo box is now not parsing the string correctly and not recognizing
that it is a stored procedure.
I've tried a number of formats for the row source string, but nothing works:
dbo.spr_Division_Dropdown '0100'
dbo.spr_Division_Dropdown('0100')
dbo.spr_Division_Dropdown ?0100?
Etc.
Any ideas or better approaches to this? Thanks!
TA
Message #2 by "Peter Kaufman" <kaufman@l...> on Fri, 20 Jul 2001 19:17:31 +0700
|
|
Have you tried cstr?
Peter
> -----Original Message-----
> From: Tom Abel [mailto:tabel@u...]
> Sent: Thursday, July 19, 2001 9:13 PM
> To: Access
> Subject: [access] Access Project Combo Box
>
>
> Hello List,
> I am trying to make a combo box display different choices based on the
> values of another control on the same form.
> In Access I could do this fairly easily by placing the control
> name directly
> into the combo box query. In and Access Project, it is a different story
> because the front-end does not have access to back-end views.
> One approach I tried: Use a stored procedure as the source of the
> combo box.
> I can place a stored procedure name in the row source in the
> combo box, and
> that works fine. However if I want to pass it a parameter it appears that
> the combo box is now not parsing the string correctly and not recognizing
> that it is a stored procedure.
> I've tried a number of formats for the row source string, but
> nothing works:
> dbo.spr_Division_Dropdown '0100'
> dbo.spr_Division_Dropdown('0100')
> dbo.spr_Division_Dropdown ?0100?
> Etc.
>
> Any ideas or better approaches to this? Thanks!
> TA
>
>
Message #3 by "Tom Abel" <tabel@u...> on Fri, 20 Jul 2001 10:33:38 -0400
|
|
Do you mean CStr(), the expression from Expression Builder? I've never used
it and the Help in Access 2000 doesn't give any help!
Boy do I miss the Expression Builder. I used it like crazy in forms and
queries. In Project it is gone (I think it popped up somewhere?)? That was
useful stuff, and I don't know what Microsoft thinks can replace it.
-----Original Message-----
From: Peter Kaufman [mailto:kaufman@l...]
Sent: Friday, July 20, 2001 8:18 AM
To: Access
Subject: [access] RE: Access Project Combo Box
Have you tried cstr?
Peter
> -----Original Message-----
> From: Tom Abel [mailto:tabel@u...]
> Sent: Thursday, July 19, 2001 9:13 PM
> To: Access
> Subject: [access] Access Project Combo Box
>
>
> Hello List,
> I am trying to make a combo box display different choices based on the
> values of another control on the same form.
> In Access I could do this fairly easily by placing the control
> name directly
> into the combo box query. In and Access Project, it is a different story
> because the front-end does not have access to back-end views.
> One approach I tried: Use a stored procedure as the source of the
> combo box.
> I can place a stored procedure name in the row source in the
> combo box, and
> that works fine. However if I want to pass it a parameter it appears that
> the combo box is now not parsing the string correctly and not recognizing
> that it is a stored procedure.
> I've tried a number of formats for the row source string, but
> nothing works:
> dbo.spr_Division_Dropdown '0100'
> dbo.spr_Division_Dropdown('0100')
> dbo.spr_Division_Dropdown "0100"
> Etc.
>
> Any ideas or better approaches to this? Thanks!
> TA
Message #4 by "Peter Kaufman" <kaufman@l...> on Sat, 21 Jul 2001 17:33:14 +0700
|
|
Yeah, I know what you mean. I missed a lot for a while too. But I meant the
cstr VBA function (change to string).
HTH,
Peter
> -----Original Message-----
> From: Tom Abel [mailto:tabel@u...]
> Sent: Friday, July 20, 2001 9:34 PM
> To: Access
> Subject: [access] RE: Access Project Combo Box
>
>
> Do you mean CStr(), the expression from Expression Builder? I've
> never used
> it and the Help in Access 2000 doesn't give any help!
>
> Boy do I miss the Expression Builder. I used it like crazy in forms and
> queries. In Project it is gone (I think it popped up
> somewhere?)? That was
> useful stuff, and I don't know what Microsoft thinks can replace it.
>
>
> -----Original Message-----
> From: Peter Kaufman [mailto:kaufman@l...]
> Sent: Friday, July 20, 2001 8:18 AM
> To: Access
> Subject: [access] RE: Access Project Combo Box
>
> Have you tried cstr?
>
> Peter
>
> > -----Original Message-----
> > From: Tom Abel [mailto:tabel@u...]
> > Sent: Thursday, July 19, 2001 9:13 PM
> > To: Access
> > Subject: [access] Access Project Combo Box
> >
> >
> > Hello List,
> > I am trying to make a combo box display different choices based on the
> > values of another control on the same form.
> > In Access I could do this fairly easily by placing the control
> > name directly
> > into the combo box query. In and Access Project, it is a
> different story
> > because the front-end does not have access to back-end views.
> > One approach I tried: Use a stored procedure as the source of the
> > combo box.
> > I can place a stored procedure name in the row source in the
> > combo box, and
> > that works fine. However if I want to pass it a parameter it
> appears that
> > the combo box is now not parsing the string correctly and not
> recognizing
> > that it is a stored procedure.
> > I've tried a number of formats for the row source string, but
> > nothing works:
> > dbo.spr_Division_Dropdown '0100'
> > dbo.spr_Division_Dropdown('0100')
> > dbo.spr_Division_Dropdown "0100"
> > Etc.
> >
> > Any ideas or better approaches to this? Thanks!
> > TA
>
>
>
|
|
|
View Cart
