Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

SQL UPDATE Table

Discussion in 'Information Technology' started by fth, Jul 28, 2006.

Tags:
  1. fth

    fth
    Expand Collapse
    Guest

    Hello,

    I've a problem to solve this:

    FMainFmD is my main form with my contact list
    FSubMontDemDetail (Details) showing records link to my contact
    (relation 1-n) data provided by table "eventDetail"
    In FSubMontDemDetail (Form Header), I've some unbounded fields (DefTotNbr,
    DefmidiMange, ... with default value I want in all records visible in
    FSubMontDemDetail
    table EventDetail)

    then I make following code:

    Private Sub BtAttrib_Click()
    DoCmd.RunSQL ("UPDATE EventDetail " & _
    "SET " & _
    "EventDetail.TotalNbr =
    [Forms]![FMainFmD]![FSubMontDemDetail].[Form]![DefTotNbr]," & _
    "EventDetail.Rmidi =
    [Forms]![FMainFmD]![FSubMontDemDetail].[Form]![DefmidiMange]" & _
    "WHERE (((FSubMontDemDetail.IdBenev)= me![ID]));")

    My button is in FMainFmD form.

    Someone to help me on this?
    many thanks by advance

    Frédéric
     
  2. Loading...

    Similar Threads Forum Date
    Microsoft Brings 64-Bit Perks In SQL Server 2000 Service Pack (Ziff Davis) Interfaith Dialogues May 7, 2005
    Self Update On The Gurdwara Blogs Apr 3, 2017
    Sikh News BREAKING: Young Sikh Shot Dead In Jalalabad, Afghanistan . - Sikh24 News & Updates Breaking News Oct 2, 2016
    Update Blogs Oct 16, 2015
    Update Wikipedia Enteries On Sikh Socio-Political Topics Breaking News Jul 19, 2015

Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     


Share This Page