Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Docshop

    Use form to set record source for report

    set the onload or current event for you second form to have the following event procedure. myform = the name of form being opened with the dynamic sql statement. Private Sub Form_Activate() 'if myRecordSource is a variant if not isnull(myRecordSource) then 'or if myRecordSource is string if...
  2. Docshop

    Can Form Field have default formula AND override?

    Event procedure for both the After Updates The CalcDateB is a subroutine called by the BlockA_AfterUpdate and the DateA_AfterUpdate
  3. Docshop

    Can Form Field have default formula AND override?

    try this setup you form for these event procedures. Private Sub BlockA_AfterUpdate() If Me.BlockA = True And Not IsNull(Me.DateA) Then CalcDateB End Sub Private Sub CalcDateB() If Me.BlockA = True And Not IsNull(Me.DateA) Then Me.DateB = Me.DateA - 7 End If End Sub Private Sub...
  4. Docshop

    Update table with Form and Subform

    Suggest Main form is unbound. (no record source) Create the combo box for Employee Id (SelectEmployee) Another combo box to list projects (SelectProject) on Subform properties Link Master fields to the two combo boxes (SelectEmployeel; SelectProject) Link child fields (EmployeeId, ProjectId)...
  5. Docshop

    SQL "Order By" in VBA error

    can you add a breakpoint and a watch on strWhere and show me the sql statement that strWhere has jus prior to opening the form?
  6. Docshop

    SQL "Order By" in VBA error

    Do you need the semicolon to complete the sql statement? "ORDER BY [RAdue];

Part and Inventory Search

Back
Top