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!

  • 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: tacexpo
  • Content: Threads
  • Order by date
  1. tacexpo

    listing only records where some fields are null

    i have a form which consists of few text boxes + combo boxes. form shows all the transactions that has been made. (all fields are bound). for ex. when user opens the form, they see 100 records they can scroll through. here's the tricky part. I only want to show records where cboOSID and...
  2. tacexpo

    update query help (2nd try)

    I have two queries that updates currency one to update the PRamt and other to update the VoucherAmt. User fills out a Purchase Requisition form and at first by defaut, check "chkEST" is selected. PRamount then would be updated /w Qry_PrAmt. when user updates this form and checks...
  3. tacexpo

    DSum Error

    I have an update Query based on two tables. I would like to update tbl_BudMaster.VoucherAmt where budgetkey is equal here's the sql code i currently have UPDATE tbl_BudMaster INNER JOIN tbl_Vregister ON tbl_BudMaster.BudgetKey = tbl_Vregister.BudgetKey SET tbl_BudMaster.VoucherAmt =...
  4. tacexpo

    access extremely slow when certain actions are done

    I've updated few things(new table, added some fields, new forms, etc) to this database and now it acts really slow on some parts. one example is when i click on the combo box. im not sure if it's because it's populating 3000 records.. can that be why?

Part and Inventory Search

Back
Top