What is ME

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Guys
I am a dummy for VBA programming. I notice a lot of codes in VBA using
"ME" reference. For example the code below. What doe ME refer to?

Private Sub HeatPoints_BeforeUpdate(Cancel As Integer)
If (Me.HeatPlace.Value = "1") Then
Me.HeatPoints.Value = "5"
Else
If (Me.HeatPlace.Value = "2") Then
Me.HeatPoints.Value = "4"
Else
If (Me.HeatPlace.Value = "3") Then
Me.HeatPoints.Value = "3"
Else
If (Me.HeatPlace.Value = "4") Then
Me.HeatPoints.Value = "2"
Else
If (Me.HeatPlace.Value = "5") Then
Me.HeatPoints.Value = "1"
Else
If (Me.HeatPlace.Value > "5") Then
Me.HeatPoints.Value = "0"
Else
If (Me.HeatPlace.Value = "DNF") Then
Me.HeatPoints.Value = "0"
Else
If (Me.HeatPlace.Value = "DNS") Then
Me.HeatPoints.Value = "0"
End If

Many thanks
Peddie

.

Relevant Pages

  • Like Operator does not work in VBA Acc2003
    ... I have a strange problem with this very simple Access 2003 database. ... The file was created in Acc2k format (I will need to share ... concatenated codes that I need to process my data, so the first thing I need ... Some of the codes refer to ...
    (microsoft.public.access.queries)
  • Re: 87 Reliant, power loss and stalls. Got codes but dunno what.
    ... As per a list of codes, they refer to AC and speed control, ... you'll find that "speed control" doesn't refer to cruise control, ...
    (rec.autos.makers.chrysler)
  • Code for Registering Add-in
    ... I have excel addin. ... some codes in first.xla refer to other procedure in second.xla ... How to register second.xla and make this file listed in "References ...
    (microsoft.public.excel.programming)
  • Re: Atheists
    ... > "codes" you refer to have changed over the years to suit society. ... Prev by Date: ...
    (rec.gambling.poker)
  • Re: What is ME
    ... I am a dummy for VBA programming. ... "ME" reference. ... What doe ME refer to? ...
    (microsoft.public.office.developer.vba)