Search results

I have a form that does multi duty. When the user inputs to a combo box and the item is not in the list the NotInList fires and opens an entry form for the new item. While passing to the new item entry form I also reconfigure my current form with the anticipation of a successful new item entry...

Private Sub LockReagentPerCraft() Dim i As Integer 'loop counter For i = 1 To 8 LockControl (Me.Controls("cboReagent0" & CStr(i))) LockControl (Me.Controls("txtPerCraft0" & CStr(i))) Next i End Sub Public Sub LockControl(ByRef ctl As Control) With...

Private Sub cboItem_AfterUpdate() If Right(Me.Caption, 4) = "ITEM" Then: Exit Sub If conErrorTrappingOn = True Then On Error GoTo Err_cboItem_AfterUpdate Dim db As Database Dim rst As DAO.Recordset Dim SQL As String Dim i As...

I recently posted a question about control name referencing. The answer given was... me.controls("string" & textboxvalue)Now I'm wondering if I can't do the same referring to the variable itself... Sub Blahblah() Dim intDur48 as Integer Dim intDur24 as Integer Dim intDur12 as Integer ("intDur"...

I have 5 form controls named... Deposit Duration Dep48 Dep24 Dep12 Deposit is simply an entered value. Duration is combo box with the value list of 48, 24, 12. Based on the user choice in the Duration combo the appropriate DepX field is updated. How do I refer to the DepX...

Private Sub cboSearch_Change() On Error GoTo Err_cboSearch_Change Dim db As Database Dim rst As DAO.Recordset Dim SQL As String SQL = "SELECT tblAuctions.AucID, tblAuctions.DateListed, tblAuctions.DateClosed...

[RESOLVED] Bound/Unbound... Subform... Write Conflict... Conceptual Help I'm unsure whether this belongs in this Forms thread or in Theory & Practice. Based on the nature of the discussion I chose here. I write to start a discussion for conceptual help. After returning to Access after many...

Option Compare Database Option Explicit 'These are used as rollbacks 'Called by cmdCancel_click() 'Updated by Form_Current Static RBBidPrice As Single Static RBBuyoutPrice As Single Static RBDeposit As Single Static RBAHCut As SingleI am experiencing strange editor behavior with and without the...