Form variables

  • Thread starter Thread starter Sapphire
  • Start date Start date
S

Sapphire

Hi

How do I convert access queries which have form variables
to Sql Server query?

Example:
SELECT Plus.*
FROM Plus
WHERE ((([Plus].[Date]) Between [Forms]![DialogBox]!
[Beginning Date] And [Forms]![ReportDialogBox]![Ending
Date]))


Please help!

Thanks
 
Take a look at the Input Parameters property of the form...

It should read something similar to:

@BeginningDate = [Forms]![DialogBox]![Beginning Date],
@Ending Date = [Forms]![ReportDialogBox]![Ending Date]

Of course, you need to create a stored procedure that accepts those two
parameters...

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
 
Thanks a lot Kevin. I will implement it.
-----Original Message-----
Take a look at the Input Parameters property of the form...

It should read something similar to:

@BeginningDate = [Forms]![DialogBox]![Beginning Date],
@Ending Date = [Forms]![ReportDialogBox]![Ending Date]

Of course, you need to create a stored procedure that accepts those two
parameters...

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

Hi

How do I convert access queries which have form variables
to Sql Server query?

Example:
SELECT Plus.*
FROM Plus
WHERE ((([Plus].[Date]) Between [Forms]![DialogBox]!
[Beginning Date] And [Forms]![ReportDialogBox]![Ending
Date]))


Please help!

Thanks
Click to expand...


.
Click to expand...
 
My syntax may be off....that is aircode :-)

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

Sapphire said:
Thanks a lot Kevin. I will implement it.
-----Original Message-----
Take a look at the Input Parameters property of the form...

It should read something similar to:

@BeginningDate = [Forms]![DialogBox]![Beginning Date],
@Ending Date = [Forms]![ReportDialogBox]![Ending Date]

Of course, you need to create a stored procedure that accepts those two
parameters...

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

Hi

How do I convert access queries which have form variables
to Sql Server query?

Example:
SELECT Plus.*
FROM Plus
WHERE ((([Plus].[Date]) Between [Forms]![DialogBox]!
[Beginning Date] And [Forms]![ReportDialogBox]![Ending
Date]))


Please help!

Thanks
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top