I'm new o VBA, I used to program with coldfusion, I need someone nice to help me out with syntax so I can continue make sense of the codes in front of me, thanks!
1. If
IsNull(Me!txtBudgetID)
Then
MsgBox "You must enter a BudgetID!",
vbExclamation, "Missing BudgetID"
Exit Sub
Else
Set Mydb = CurrentDb
Me!OTYPE = "2" <--- WHAT DOES THIS MEAN? and
WHAT DOES IT DO?
I can see OTYPE in the drop down Object box, if I choose this object from object box, than my insertion point will be in:
Private Sub OTYPE_BeforeUpdate(Cancel As Integer)
End Sub
----> Is this a procedure? if yes what does it do? why there is no code between Private Sub and End Sub???
2. In option explicit section I have:
Dim LinkCriteria As String
then in few section below I have:
LinkCriteria = "[BudgetID] = " & Me![txtBudgetID]
My question is:
"[BudgetID] = " ---> WHAT DOES THIS SYNTAX MEAN?
Does it mean: assign to the
variable name LinkCriteria the
value of Column called:BudgetID?
3. Forms!frmDevelop514Calc!
fsubDevelop514Calc.Form!
lblAmt2.Caption = Trim(Str$(Forms!frmFY!txtFY - 2))
WHAT DOES fsub mean? does it mean a sub form just
like frmsomething?
Thank you so much for your input! Alec
1. If
IsNull(Me!txtBudgetID)
Then
MsgBox "You must enter a BudgetID!",
vbExclamation, "Missing BudgetID"
Exit Sub
Else
Set Mydb = CurrentDb
Me!OTYPE = "2" <--- WHAT DOES THIS MEAN? and
WHAT DOES IT DO?
I can see OTYPE in the drop down Object box, if I choose this object from object box, than my insertion point will be in:
Private Sub OTYPE_BeforeUpdate(Cancel As Integer)
End Sub
----> Is this a procedure? if yes what does it do? why there is no code between Private Sub and End Sub???
2. In option explicit section I have:
Dim LinkCriteria As String
then in few section below I have:
LinkCriteria = "[BudgetID] = " & Me![txtBudgetID]
My question is:
"[BudgetID] = " ---> WHAT DOES THIS SYNTAX MEAN?
Does it mean: assign to the
variable name LinkCriteria the
value of Column called:BudgetID?
3. Forms!frmDevelop514Calc!
fsubDevelop514Calc.Form!
lblAmt2.Caption = Trim(Str$(Forms!frmFY!txtFY - 2))
WHAT DOES fsub mean? does it mean a sub form just
like frmsomething?
Thank you so much for your input! Alec