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!

Recent content by tacexpo

  1. tacexpo

    listing only records where some fields are null

    i changed it using dLookup but it's taking to long... i guess my final question is.. is there a way to jump to a certain record? like if 100 records show up but i wanna jump to 54? since record selector is filtering out some records the record number doesnt match the number on the form
  2. tacexpo

    listing only records where some fields are null

    so instead of showing all 100 records, open in a addMode where user can type in a number to find a specific record. i can't do that with the way things are set up now huh?
  3. tacexpo

    listing only records where some fields are null

    another question. If i want the form to update after user types in txtPRnum, how would i do that?
  4. tacexpo

    listing only records where some fields are null

    exactly what i needed. thank you.
  5. 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...
  6. tacexpo

    update query help (2nd try)

    another quick question. seems like this query is running fine but i dont have much data in yet. is this one ok? UPDATE (tbl_BudMaster AS B INNER JOIN tbl_Vregister AS V ON B.BudgetKey = V.BudgetKey) INNER JOIN tbl_purchaseRequisition ON (B.BudgetKey = tbl_purchaseRequisition.BudgetKey) AND...
  7. tacexpo

    update query help (2nd try)

    that works perfectly. thank you guys for your help
  8. tacexpo

    update query help (2nd try)

    actual is a Yes/No field. am i misunderstanding? or does 0 actually equal yes or no?
  9. tacexpo

    update query help (2nd try)

    this is what i have now.. UPDATE tbl_BudMaster AS B INNER JOIN tbl_PurchaseRequisition AS V ON B.BudgetKey = V.BudgetKey SET B.PrAmt = NZ(DSum("Amount","tbl_PurchaseRequisition","BudgetKey='" & B.BudgetKey & "'"),0) WHERE (((V.Actual)=No) AND ((V.Estimate)=Yes)) and b.budgetkey = v.budgetkey...
  10. tacexpo

    update query help (2nd try)

    what im trying to say is... shouldn't my update query return 0 if both records are true on WHERE (((V.Actual)=No)); ? even after records are updated, pramt is still at 100 instead of 0
  11. tacexpo

    update query help (2nd try)

    like this query for example.. UPDATE tbl_BudMaster AS B INNER JOIN tbl_PurchaseRequisition AS V ON B.BudgetKey = V.BudgetKey SET B.PrAmt = nz(DSum("Amount","tbl_PurchaseRequisition","BudgetKey='" & B.BudgetKey & "'"),0) WHERE (((V.Actual)=No)); lets say user creates 2 records. (rs=tbl_pr)...
  12. 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...
  13. tacexpo

    DSum Error

    thank you!!!
  14. 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 =...
  15. tacexpo

    access extremely slow when certain actions are done

    thank you
See more

Part and Inventory Search

Back
Top