Registered users    
MembershipMembership:
Latest New UserLatest:Chris Naylor
New TodayNew Today:10
New YesterdayNew Yesterday:11
User CountOverall:23325
Private messaging    
You must be logged in to use this module.
Top 10 posters    
NamePosts
Mariette Knap12894
Marina Roos12507
Eriq Neale2114
Stan Guinn1913
Michael Patrick1912
Robert Pearman1771
Nick Pieters1425
Stewart Brown616
william warren601
Kevin D.579
Welcome unauthorized visitor    
If you want to join us in the discussions on this forum you need to register first. Registration is free! If you are already a registered user please login to join the forum.
Small Business Server Support Forum    
Forums > Microsoft Small Business Server 2003 & 2000 > SQL Server 2000
Subject: Passing Access 2007 Form value to SQL Server 2005 Procedure or Function
Prev Next
You are not authorized to post a reply.

Author Messages
Terry Lynn User is Offline
United Kingdom
Member since
4/16/2007

Platinum Membership
Posts: 17
12/10/2007 11:20 AM  
I have an Access 2007 Form which displays the Sunday of each week. For which ever Sunday I have displayed in the Access Form I would like to be able to click a Command button on the form which will then pass the date to a Sql 2005 Procedure or Function (preferably a Function) as a parameter and enable a view to just select records from the SQL table which apply to that particular day.
Any help would be appreciated
Many thanks
Terry
Tim Saunders User is Offline
United States
Member since
7/16/2007

Platinum Membership
Posts: 45
3/14/2008 12:36 PM  
An easy start would be to just link to the SQL Server table and then run the query against that linked table.
You are not authorized to post a reply.
Forums > Microsoft Small Business Server 2003 & 2000 > SQL Server 2000 > Passing Access 2007 Form value to SQL Server 2005 Procedure or Function


ActiveForums 3.7
Forum policy    
These Discussion Forums are dedicated to the discussion of the Small Business Server and related server and client software. For the benefit of the community please observe the following posting guidelines:
  1. No Advertising. This includes promotion of commercial products and non-commercial products which are not directly related to Small Business Server and related server and client software.
  2. No Flaming or Trolling.
  3. No Profanity, Racism, or Prejudice.
  4. Site Moderators have the final word on approving/removing a thread or post or comment.
Copyright 2002-2008 Concentrix b.v.    :   Page generated in 0.2812518 seconds.   :   Terms Of Use   :   Privacy Statement