Form Parameters in queries - and Web applications

[snielson]

A question for all you Access gurus:

In my database aplication I have a form/vba code where the user can select
various options from dropdowns, and then I use their selections in my
queries/subqueries like this:

Select * from [Supplier list DDP BOB]
WHERE vendor=Forms!StartForm!frm_vendor_name;

.... where "frm_vendor_name" is selected by the user from the form.

But I would like to build a .NET app so that I can run the quieries from a
web page and manipulate the resulting datasets outside Access. I know how to
pass in parameters via the web page, but I have a complex heirarchy of
queries calling other queries which in turn call other queries, and they all
use different variables from the user interface form, like the example above.

If I execute a "top level" query from a web page, obviously the user
interface form is not created, and the so none of the form variables are set,
so my sub queries fail.

Is there a way to somehow set some kind of "global variables" (of some sort)
within Access from a web page? So that I could pass in seveal parameters from
the webpage, and then access those parameters within my subqueries?

Thanks for any advice!

 

[pietlinden]

A question for all you Access gurus:

In my database aplication I have a form/vba code where the user can select
various options from dropdowns, and then I use their selections in my
queries/subqueries like this:

Select * from [Supplier list DDP BOB]
WHERE vendor=Forms!StartForm!frm_vendor_name;

... where "frm_vendor_name" is selected by the user from the form.

But I would like to build a .NET app so that I can run the quieries from a
web page and manipulate the resulting datasets outside Access. I know howto
pass in parameters via the web page, but I have a complex heirarchy of
queries calling other queries which in turn call other queries, and  they all
use different variables from the user interface form, like the example above.

If I  execute a "top level" query from a web page, obviously the user
interface form is not created, and the so none of the form variables are set,
so my sub queries fail.

Is there a way to somehow set some kind of "global variables" (of some sort)
within Access from a web page? So that I could pass in seveal parameters from
the webpage, and then access those parameters within my subqueries?

Thanks for any advice!

Using Access forms and using web forms are different animals
entirely. Access forms use DAO under the covers, which is one data
access method, and web forms use ADO, which is different. ADO has
*no* connection to the expression service, which DAO uses to resolve
references to values of controls on forms. But you can use stored
procedures, which can accept parameters.