Search results

  1. E

    Delete the current record

    Well I have put off embarrasing myself by writing to this forum with my dopey question but here goes: I have been trying to find a method of deleting the current record. My attempt so far is as follows: Dim MyDB As Database Dim MyRS As Recordset Set MyDB = CurrentDb Set MyRS =...
  2. E

    Move and renumber records

    Hi all I have a database that contains a list of records... ie: 1 | Question one text | Option 1 | Option 2 | etc... 2 | Question two text | Option 1 | Option 2 | etc... 3 | Question three text | Option 1 | Option 2 | etc... 4 | Question four text | Option 1 | Option 2 | etc... I am not...
  3. E

    reuse script

    Hi all Does anybody know of a way of reusing a chunk of VB script in other parts of my code. (So I don't to change all occurrences when I make changes)? Thanks
  4. E

    concatenating labels

    Can anybody give me some help: I have 5 labels (Label1 ,Label2...etc and I want to change their values on the click of a button). But I'm have trouble concatenating. Here is my idea: For j = 1 To 5 Me."Label" & j.Value = "Drop" & 1 Next j I know the code is wrong but the idea is...
  5. E

    Checkbox woes

    I have created an event proceedure attached to a drop down list, and when the value changes, I have created the following code: If QuestionType = "TF" Then For j = 1 To 5 If j < 3 Then Me.Controls("Correct" & j).Enabled = True Else Me.Controls("Correct" & j).Enabled = False...
Back
Top Bottom