Results 1 to 3 of 3
  1. #1
    vicrauch is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2011
    Location
    Sacramento
    Posts
    27

    Function to return a set of records?

    As I understand, within SQL Server a stored procedure can be written to provide a recordset as though it was an actual table or view. Is there anything in Access 2010 that would allow the same functionality? I know I could do it in SQL Server, then link Access to that SQL Server view, but I need to keep this in Access.


    If this functionality is not available in Access, I plan to build a temp table with records generated from a function and added to the temp table.

  2. #2
    jgelpi16 is offline Expert
    Windows XP Access 2010 32bit
    Join Date
    Mar 2010
    Location
    Charlotte, NC
    Posts
    544
    I am not familiar with SQL Server, but you may want to look up DAO Recordsets. These allow you to reference a table/query in VBA. Forgive me if I am way off base on this.

  3. #3
    vicrauch is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2011
    Location
    Sacramento
    Posts
    27
    Thank you for your input! I already know about DAO, but what I'm looking for is some way to address a function as if it were a table or query. That way, I can use a function to "create" a dynamic recordset without having to have an actual table to base it on. I really do not believe there is a way to do this in Access, but I am hoping to get some input from senior Access developers.
    Again, thank you very much for your input. It is the giving and sharing that makes forums so very helpful.
    Vic

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Search records and return message.
    By sYn in forum Programming
    Replies: 4
    Last Post: 01-07-2011, 11:21 PM
  2. Replies: 1
    Last Post: 06-23-2010, 09:45 AM
  3. Access not return the records
    By ashutoshNetsity in forum Access
    Replies: 1
    Last Post: 05-09-2010, 04:27 AM
  4. Return all records from Query
    By ysrini in forum Queries
    Replies: 1
    Last Post: 01-15-2010, 09:52 PM
  5. Return 0 if no records found
    By skwilliamson in forum Programming
    Replies: 1
    Last Post: 12-01-2009, 10:54 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums