Results 1 to 3 of 3

Thread: [RESOLVED]How to add a data to a field on clicking a button

  1. Apr 24th, 2006, 10:21 AM #1
    arunb
    arunb is offline

    Thread Starter
    Addicted Member arunb's Avatar
    Join Date
    Jul 2005
    Posts
    131

    [RESOLVED]How to add a data to a field on clicking a button

    Hi,

    How can I set a field value (Yes no Type) by click on a button in a form in Access ???, the form derives its data from a table where all the fields are defined...

    thanks
    arunb
    Last edited by arunb; Apr 26th, 2006 at 12:17 AM.
    Reply With Quote Reply With Quote
  2. Apr 24th, 2006, 10:56 AM #2
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: How to add a data to a field on clicking a button

    Moved to Office Development
    Reply With Quote Reply With Quote
  3. Apr 24th, 2006, 04:05 PM #3
    salvelinus
    salvelinus is offline
    Frenzied Member
    Join Date
    Feb 2003
    Location
    Argentina
    Posts
    1,950

    Re: How to add a data to a field on clicking a button

    Is it a bound control, or in code? If bound, use a checkbox instead of a button, if you can. If not, say you don't display the value, try code (DAO, which is faster if you're staying in Access, & not in VB6, .Net, etc):
    [/Highlight]
    strSQL = "UPDATE tblFoo SET fldYesOrNo = True WHERE ID = 999"
    DoCmd.RunSql strSQL
    [/Highlight]
    Change the names to whatever is appropriate
    Tengo mas preguntas que contestas
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width