Search results for query: *

I have two cross tab queries. qry_PayCrostab which sums the wages TRANSFORM Sum(Tbl_FTEallocation.Wages) AS SumOfWages SELECT tbl_Dept.DpName FROM tbl_Revenue INNER JOIN (tbl_Dept INNER JOIN Tbl_FTEallocation ON tbl_Dept.DPID = Tbl_FTEallocation.Dpid) ON tbl_Revenue.revnum =...

got it. thank you

is there any simpler way? there must be easier way to carry over the data..

i have this form where i can input data. tabbing and auto fill option from combo box is making the process pretty easy. one question though, when im entering data, certain fields are same as the previous input. is it possible to set the Default value as something like Previous Data()??

i've tested it through many times and it's working. thank you for your replies

i have to run more tests but i think it's working!!! i'll get back to you.

is there such way to post before running updates? I assumed data entered by user on the form is saved to the table as soon as it loses focus...

'after event of cmdDone from "frm_contractLiq" DoCmd.OpenQuery "qry_PSCLiqAmt" DoCmd.OpenQuery "qry_PSCBalanceUpdate" DoCmd.OpenQuery "qry_BudMasterCashd" DoCmd.OpenQuery "qry_BudMastercontp" DoCmd.OpenQuery "qry_BudMasterTotex" DoCmd.OpenQuery...

it also helps if you check which data it's capturing..

try this. txtemployee = DLookUp ("Field2","Emp", "Field5='"&_ txtempid & "'")

requery? tables? and yes it's a bound form.

i have just few update queries that runs afterevent of a command buttong. ie. docmd.OpenQuery "qry_Total" docmd.OpenQuery "qry_Expenditures" docmd.OpenQuery "qry_Balance" for some reason, queries are not updating the current values on the form. At first, I thought the queries are...

How do I use DLookUp to find the next number? ie. tbl_PSC contractno | addendumno test00 | 00 test00 | 01 I have a form "frm_PSCupdate" I have a combobox where user can select the contract they want to update. if they choose "test00" from cboContNo i want...

DSum surely worked =)

I've previously posted a coding that i thought it'll work. I've just thought of one problem Dim DB As DAO.Database Dim RS As DAO.Recordset Set DB = CurrentDb() Set RS = DB.OpenRecordset("tbl_PSC", dbOpenDynaset) Set bs = DB.OpenRecordset("tbl_PSCtx", dbOpenDynaset) If Me.txtContractNo =...

i played around with it and i think this might work.. Dim DB As DAO.Database Dim RS As DAO.Recordset Set DB = CurrentDb() Set RS = DB.OpenRecordset("tbl_PSC", dbOpenDynaset) Set bs = DB.OpenRecordset("tbl_PSCtx", dbOpenDynaset) If Me.txtContractNo = DLookup("ContractNo", "tbl_PSC"...

this continous from thread181-1344029 tbl_PSCtx can have duplicate contract numbers but tbl_PSC should only have one contract number. its like total and i forgot to think that before update, If 'contractNumber' already exists in tbl_PSC, only one field needs to be updated. so im thinking...

thank you. that was a good approach for me; however, I have one problem. tbl_PSCtx can have duplicate contract numbers but tbl_PSC should only have one contract number. its like total and i forgot to think that before update, If 'contractNumber' already exists in tbl_PSC, only one field...

is it possible to capture values from a form and send to 2 different table? what i mean is... I have a table PSCtx. it's a transaction table where people can enter contract amount and such. I have a table PSC which has almost exact same fields as PSCtx but has balances and etc. (hard to explain...

ty aceman and phv. that coding did it phv. =)