User Profile

Collapse

Profile Sidebar

Collapse
aakash
aakash
Last Activity: Aug 14 '06, 03:01 PM
Joined: Jun 28 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • aakash
    started a topic calling access form control in ms sql function
    in Access

    calling access form control in ms sql function

    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(c har(8), [Date sampled], 110) AS Sampled, Jobs.Sites, Jobs.Tests,...
    See more | Go to post
    • aakash
      started a topic Accessing form controls values through ms sql fuction
      in SQL Server

      Accessing form controls values through ms sql fuction

      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(c har(8), [Date sampled], 110) AS Sampled, Jobs.Sites, Jobs.Tests,...
      See more | Go to post
      • aakash
        replied to conversion from Access query to mssql query
        in SQL Server
        Sites Union Controls, was query in old ms access project which was connected to ms access database i am changing connectivity to ms sql 2000 ,none of the above solutions seem to be working ,
        please help
        See more | Go to post

          Leave a comment:

        • aakash
          started a topic conversion from Access query to mssql query
          in SQL Server

          conversion from Access query to mssql query

          Hello Guys


          I am chaging the connectivity of MSaccess2K to sqlserver
          the code is written in vb editor of access
          i have established the connection string
          but the following query is generating error of
          invalid object name

          strSQL = SELECT DISTINCT [Sites Union Controls].Description,
          [Sites Union Controls].[Rous Reportable Site], [Sites Union Controls].[Type], Samples.Sequenc eNumber...
          See more | Go to post
          No activity results to display
          Show More
          Working...