Form variables

[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

 

[Kevin3NF]

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.

 

[Sapphire]

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

.

 

[Kevin3NF]

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.

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

.