Passing Access query parameter to SQL view 1

[snoopy80]

Hi Everyone.

Let say I have an Access DB with a report when run, would request to enter a parameter (as criteria filter) then would display a list of people. For ex: when i open the report it then run a query that will ask me the enter a first name and when I enter John, it will then display a list a people with first name John in the report.
Now I have convert the DB to SQL to hold the tables and use view to replace queries. My question is how can I run this same report from Access to prompt to enter a First Name and then pass it to a SQL view to filter data and display it back with the report?
Thank you for your help.

 

[dhookom]

Is this an ADP or MDB? Have you linked the view or are you using a pass-through query?

IMO, never use parameter prompts faq701-6763. Always use controls on forms for user interface.

Duane
Hook'D on Access
MS Access MVP

 

[snoopy80]

Thanks Duane for your reply.
It's a ADP.
I took a look at your FA701-6763 link. The codes are the SQLcode for Access not for SQL right?

 

[dhookom]

The basis of FAQ is for all software development. Don't use parameter prompts.

You may find some good information on passing parameters at

http://msdn.microsoft.com/en-us/library/aa235171(office.10).aspx.

Duane
Hook'D on Access
MS Access MVP

 

[snoopy80]

I did found what I need through your link. THANKS Duane