User Profile

Collapse

Profile Sidebar

Collapse
ninodgg
ninodgg
Last Activity: Jun 7 '11, 09:19 AM
Joined: Apr 21 '11
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • Dear MacDonald,
    Tanks very much... simply but is what i need
    See more | Go to post

    Leave a comment:


  • ninodgg
    started a topic Manage toolbox created at runtime

    Manage toolbox created at runtime

    Hi to all,
    i just made an form where with button add 10 textbox whith this code:
    Code:
    For X = 1 To 10
                Me.Controls.Add(tx)
                tx.Visible = True
                tx.Width = 300
                tx.Name = "TxtBox" & X
                tx.Text = tx.Name '"testo che appare nella box" & X
                tx.Location = New Point(300, 30 * X)
    ...
    See more | Go to post

  • ninodgg
    started a topic use for each in subform

    use for each in subform

    Hi to group
    I have an form(form0) with 2 subforms(form1 & form2), with VBA, apply filter to form1.
    Now I tried update second form with filtered data of form1 with this code:
    Code:
    For Each field1 In Forms!form0.Form!form1.Form
      sqlstr = "UPDATE Forms!form0.Form!form2.Form SET 
      Forms!form0.Form!form2.Form!fieldWW = forms!form0.form!form1.form!field1 
      where ........ 
      DoCmd.RunSQL sqlstr
    ...
    See more | Go to post
    Last edited by TheSmileyCoder; Apr 22 '11, 07:01 PM. Reason: Remember to put square brackets around the [code] tags.
No activity results to display
Show More
Working...