I am using Access 2003 ADP with SQL Server 2005. Just upgraded from
SQL 2K. I have a combo box on the form where the row source is a user
defined function. Now that I'm working with 2005, the ORDER BY does
not work. What is the quickest/best way to fix this? Is it best to
change this to a stored procedure? Thanks for any advice.

Jenn

JEM <(E-Mail Removed)> wrote in
news:e04ab9d6-5516-481b-a7fe-(E-Mail Removed):

> I am using Access 2003 ADP with SQL Server 2005. Just upgraded
> from SQL 2K. I have a combo box on the form where the row source
> is a user defined function. Now that I'm working with 2005, the
> ORDER BY does not work. What is the quickest/best way to fix
> this? Is it best to change this to a stored procedure? Thanks for
> any advice.

I can't quite figure out why you'd use a user-defined function
instead of a SQL statement as the rowsource.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

I inherited the database from another consultant. The records that
appear in the combo box need to be filtered based on the form's
record. He used a function to accomplish this.


On Jun 21, 9:12*pm, "David W. Fenton" <XXXuse...@dfenton.com.invalid>
wrote:
> JEM <J...@JEMConsulting.org> wrote innews:e04ab9d6-5516-481b-a7fe-(E-Mail Removed):
>
> > I am using Access 2003 ADP with SQL Server 2005. *Just upgraded
> > from SQL 2K. *I have a combo box on the form where the row source
> > is a user defined function. *Now that I'm working with 2005, the
> > ORDER BY does not work. *What is the quickest/best way to fix
> > this? *Is it best to change this to a stored procedure? Thanks for
> > any advice.
>
> I can't quite figure out why you'd use a user-defined function
> instead of a SQL statement as the rowsource.
>
> --
> David W. Fenton * * * * * * * * *http://www.dfenton.com/
> usenet at dfenton dot com * *http://www.dfenton.com/DFA/

David;

SQL UDFs are extremely powerful.

If you don't know what they do, then why don't you STFU and go and
play with your baby-sized databases?

Thanks

-Aaron

On Jun 21, 6:12*pm, "David W. Fenton" <XXXuse...@dfenton.com.invalid>
wrote:
> JEM <J...@JEMConsulting.org> wrote innews:e04ab9d6-5516-481b-a7fe-(E-Mail Removed):
>
> > I am using Access 2003 ADP with SQL Server 2005. *Just upgraded
> > from SQL 2K. *I have a combo box on the form where the row source
> > is a user defined function. *Now that I'm working with 2005, the
> > ORDER BY does not work. *What is the quickest/best way to fix
> > this? *Is it best to change this to a stored procedure? Thanks for
> > any advice.
>
> I can't quite figure out why you'd use a user-defined function
> instead of a SQL statement as the rowsource.
>
> --
> David W. Fenton * * * * * * * * *http://www.dfenton.com/
> usenet at dfenton dot com * *http://www.dfenton.com/DFA/