Access Projects....HELP!!!!!!!

[randusoleis]

I have upsized a database to SQL7.0 and am now using an Access Project as a front end. Here is why I am pulling my hair out.
In a regular Access 2000 database, if I wanted to run a report based on a query(now called a "VIEW" in SQL7.0) and have criteria in the query based on a field on a form I was using....[FORMS]![FormName]![TextBoxName].
What is the proper format for this now in the Access 2000 Project.
Any and all suggestions welcome

 

[TerpFan2001]

Why not use a Query in Access to populate your report. If you have your SQL Server table linked, you should be able to build the query as if it were using an Access table.

 

[randusoleis]

In an Access Project that uses a SQL Server as a backend, you can no longer plainly use Access querys. The tables are linked for information but not like you are thinking.
I must be done in a view.
Randusoleis.....

 

[TerpFan2001]

I have always been able to use Access(97 - XP) queries to pull data from linked SQL Server 7 tables. I currently have several databases that do exactly what you are trying to do using linked SQL Server Tables, Access Forms, Access Queries and Access Reports.

 

[randusoleis]

I am using a .adp(Access Data Project) that "connects" directly to a SQL7.0 Server.
Everything you are telling me will work but only on a database with linked tables. Randusoleis.....

 

[jfischer]

ADPs are very different from MDBs. ADPs are pretty much a sophisticated VBA front-end for SQL Server databases. You're going to have to change your thinking, design models, and coding to use ActiveX Data Objects (ADO) instead of Data Access Objects (DAO) technology.

If you need to pass parameters to your report queries, you should change the Record Source for your report to a Stored Procedure instead of a View. Then, use either 1) the InputParameters property of the Report, or 2) build SQL strings in code (for the Report's Record Source) to pass the parameters you need to use.

 

[randusoleis]

How do you use the input parameters? Randusoleis.....

 

[jfischer]

Look in Access online help under "InputParameters". This is a lengthy discussion.

 

[randusoleis]

jfischer.....you are the MAN!!!!
Randusoleis.....