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 Chriss Miller 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: *

  • Users: cys813
  • Content: Threads
  • Order by date
  1. cys813

    prints out a blank page (form) with a header title when printing a for

    If i double click and open the form (from navigatio window; donno what else to call it), it seems like everything is working fine. Prints the current page after clicking the command button like it should. However, if I open the same form from another form (ex. Menu -> command button ->...
  2. cys813

    Print current record on a form

    I have a form which consist of a combo box and text boxes. text boxes are automatically filled in after a selection from the combo box. My main goal was to let the user Print (using a command button) a current record. By current record i mean the data based on user's selection of the combo...
  3. cys813

    update query not updating correctly (2nd try)

    I have an update query which updates a master table based on a sub table. here's the SQL of the update query: UPDATE tbl_ContractLedger AS C INNER JOIN tbl_CapitalPrs AS P ON C.ContractID = P.ContractID SET C.PRamt = NZ(DSum("Amount","tbl_CapitalPrs","ContractID='" & [C].[ContractID] & "'"),0)...
  4. cys813

    update query not updating correctly

    I have an update query which updates a master table based on a sub table. here's the SQL of the update query: UPDATE tbl_ContractLedger AS C INNER JOIN tbl_CapitalPrs AS P ON C.ContractID = P.ContractID SET C.PRamt = NZ(DSum("Amount","tbl_CapitalPrs","ContractID='" & [C].[ContractID] & "'"),0)...
  5. cys813

    Record lock violation cancelling an update query

    I have a simple update query that I need to run in a form but Im having some trouble. at first, my update query wasn't working so I took off docmd.setwarnings = false to see what kind of error msg i get. I am currently getting a msg "Microsoft Office can't update all the records in the...

Part and Inventory Search

Back
Top