Using Combo Boxes As control sources for SQL views and stored proc

[Guest]

My database was just moved onto an SQL server, and I have very little
experience with SQL servers. Before the switch, I used combo boxes on a form
to narrow data in a query. These combo boxes could be changed by the user,
and they could then view a report based on their selections in the combo
boxes. Since the database has been moved to the SQL server, the queries that
used the combo boxes for criteria have been lost. When I tried to re-create
the queries in a view or stored procedure it would not return any records
based on the combo boxes. A link to an informative web-site or any help
would be greatly appreciated. Thank you in advance.

 

[Guest]

How are you connecting to SQL Server? Through ODBC or with an ADP? If you've
upsized and are using ODBC, you should still be able to use Access queries.

Here's a page that might help:
http://www.microsoft.com/technet/prodtechnol/sql/2000/Deploy/accessmigration.mspx

Also, there's an excellent book that covers the whole topic:
http://www.amazon.com/Microsoft-Acc...ef=sr_1_1/002-3334837-9911242?ie=UTF8&s=books

Hope this helps,
Barry

 

[Guest]

Thank you very much Barry, that book is exactly what I am looking for.

Thanks,
Zack