User Profile

Collapse

Profile Sidebar

Collapse
Twinprabu
Twinprabu
Last Activity: Mar 6 '14, 08:04 AM
Joined: Aug 19 '13
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Twinprabu
    replied to How to pass parameter from text box to stored procedure
    in Access
    Hi,
    Actually am new to VBA. I know nothing about VBA. In my project all the applications(.a dp) are using Access 2007 as front end and SQL server 2008 as back end.In one of the applications it seems stored procedure directly fetched the input from a text box.The code is
    Code:
    strRowSource = "EXEC dbo.spr_Find_Project_by_Number '" & Me.tboProjectNo & "'"
    Me.lboOutputDatabaseProjects.RowSource = strRowSource
    ...
    See more | Go to post
    Last edited by zmbd; Aug 29 '13, 11:38 AM. Reason: [z{properly placed code tags... ;)}]

      Leave a comment:

    • Twinprabu
      started a topic How to pass parameter from text box to stored procedure
      in Access

      How to pass parameter from text box to stored procedure

      Hi,
      I have created a command button called Reports in Access 2007 using wizard for generating a report between two dates.The stored procedure behind the button is spr_Reports(SQL server 2008):

      Code:
      ALTER PROCEDURE [dbo].[spr_Reports] 
	@start_date date,@end_date date
AS
BEGIN
	select convert(varchar(20),date,103)as Date,d.Planned,d.Comment 
	from tbl_Calendar e join tbl_Calendar_Details d
      ...
      See more | Go to post
      • Twinprabu
        replied to How do I pass parameters from VB6 to a Query in MS Access?
        in Visual Basic
        Only thing I see that might be a problem is your where cluase has items that are not in the Group by, but if it runs in Access that way, great.

        I VB it will not prompt you for inputs the way Access does when it open. you need to pull the parameters from your VB form through input boxes or tect fields, combos, some means and place that in the query string.


        Hi

        I have created a Button called 'Reports'...
        See more | Go to post

          Leave a comment:

        No activity results to display
        Show More
        Working...