User Profile

Collapse

Profile Sidebar

Collapse
begnar
begnar
Last Activity: Nov 17 '13, 02:45 PM
Joined: Nov 12 '13
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • begnar
    replied to What is wrong with this code..
    in Access
    i think now u ve understand my problem , actually that is a requirement...i ve to provide that facility to my client...
    See more | Go to post

      Leave a comment:

    • begnar
      replied to What is wrong with this code..
      in Access
      Thanx for your kind responses ... i am attaching the actual database this will clears my idea..and requirement....
      See more | Go to post

        Leave a comment:

      • begnar
        started a topic What is wrong with this code..
        in Access

        What is wrong with this code..

        Code:
        Private Sub Sno_AfterUpdate()
Dim dbs As DAO.Database
Dim rs As DAO.Recordset
Dim sql As String
Dim tmp As Variant
Dim bno As String
bno = Me.BookNo.Value
area = Me.area.Value

Set dbs = CurrentDb
    'sql = "select s_no from customer_info where [book_no]='bno';"
    Set rs = dbs.OpenRecordset("select s_no from customer_info where bookno='" & bno
        ...
        See more | Go to post
        Last edited by zmbd; Nov 13 '13, 12:09 AM. Reason: [z{second post added some information to code - Normally this thread would have been closed without such info to begin with!}]
        No activity results to display
        Show More
        Working...