Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Posts
    81

    Unanswered: SQL function on an Access Form

    I have a SQL function that take input params and return a single value. I want to call this function from an Access Form/Report and have the value displayed in a control on the Form. The input params for the function comes from data in the table the Form is bound to.

    I can get the form to show a record set based on a control on the form from stored procedures but I don't understand how to display the data directly from a SQL function on the .adp Form. How do I do this?

    Bjorn

  2. #2
    Join Date
    Aug 2003
    Posts
    39
    Try this. create a stored procedure that takes in the same parameters as the function, then run the function in the sproc, and return the value you want, and bind that to the control.

  3. #3
    Join Date
    Jan 2003
    Posts
    81
    I understand that this is an option, but it's binding it to the control that's giving me problems.

    Bjorn

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •