By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,101 Members | 1,335 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,101 IT Pros & Developers. It's quick & easy.

calling access form control in ms sql function

P: 4
Hello Guys
I am upsizing ms access project to give it a ms sql connectivity
I am having problem in accessing form control values in ms sql function

CREATE FUNCTION "ReportList DateRange"()
RETURNS TABLE
AS
Begin

RETURN
(SELECT TOP 100 PERCENT Jobs.JobSerial AS Report, ReportTemplates.Name,convert(char(8), [Date sampled], 110) AS Sampled, Jobs.Sites, Jobs.Tests, Jobs."Date Sampled"
FROM ReportTemplates INNER JOIN Jobs ON (ReportTemplates.ReportSerial=Jobs.ReportTemplate)
WHERE (
((ReportTemplates.Name)<>"Customer Test Values")
AND (
(Jobs.[Date Sampled])<=[Forms]![Report Selector Form]![EndDate]
And (Jobs.[Date Sampled])>=[Forms]![Report Selector Form]![StartDate])
AND (
(ReportTemplates.Component) Like [Forms]![Report Selector Form]![ComponentName]) AND ((ReportTemplates.Frequency) Like [Forms]![Report Selector Form]![PeriodText])
AND ((Jobs.Status)=3) )

the function is accessed in the rowsource property of combobox
query works fine with access database but fuction is causing problems
because of form control
what Is used in accessing form control in ms sql function
Please Provide Solution for this

:)Thanks In Advance :)
Aug 12 '06 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.