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...
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...
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 =...
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?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.