Recent content by JohnHBooth

  1. J

    VBA RunSQL to update field in table from Form

    I think this would work for you: CurrentDb.Execute "UPDATE TABLE2 SET [TABLE2].SURNAME ='" & Me.Surname & "' WHERE [TABLE2].ID= " & Me.ID, dbFailOnError
  2. J

    If any fields in a form is empty then

    I think if you amend your code like this you will get what you want: Private Sub Form_BeforeUpdate(Cancel As Integer) Dim blnAllEntered As Boolean blnAllEntered = True For Each ctl In Me.Controls Select Case ctl.ControlType Case acTextBox, acComboBox, acListBox...
  3. J

    Referencing text-box name

    I think this is the syntax you want: FORMS!FORM1!Controls.Item(myControlName) = myList
  4. J

    John from London, UK

    Hi all, I'm John. I am relatively new to Access, using it for about 3 months now, but I have used SQL server and C# in the past. I have found this forum very helpful it getting me over some initial problems and misunderstanding so I thought I ought to join up. I work with research data at...
See more
Back
Top Bottom