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 =...

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()??

'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...

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...

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 =...

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...

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...

so I have this continous form... and field txtUnit. I would like to create a command button which will open an Excel files only if txtunit = "condition1" eventually i would like to create about 3 command boxes, which will open different excel file depending on the value of the txtUnit. ie...

I have this coding for txtUnit. Me.txtUnit = DLookup("produnitname", "tbl_DeptProGoalUpdate", "deptbudno = '" & Me![txtDeptBudNo] & "'") because the field is not bound, every record is showing as a same value. a problem... if I create a field in another table(forms rec source) and bound this...

i am trying to fund a sum of c1 and divide by sum of c2 to find 'estUnitCost' maybe something like.. UPDATE tbl_EstUnitcost SET EstUnitcost ,sum(estcost)/sum(estprodunit) as estunitcost FROM tbl_EstUnitCost Group By tbl_EstUnitCost.DeptBudNo; EstUnitCost should be sum of 'estcost divide by...

is it possible to open a specific excel file from access form? maybe like a commandbutton which will open an excel file. if so, is it possible to open a file that's located in shared network folder?

I have a field 'actUnitCost' in form "frm_DeptBudget"(from tbl_DeptBudget). This field needs to return sum of 'tranXamt' from tbl_DeptActTxDetail / sum of 'actProd' from tbl_DeptProGoalUpdate I've learned today how to do group by and sum in query today, thx to remou and phv, but I have no...

Me.txtTranxAmt = Me.txtActualAmt / Me.txtActProd Me.txtTranxAmt.Requery Me!txtGhost = Me!txtTranxAmt txtGhost is bound and txtTranxAmt is calculated how come it says you can't assign that value to this object?

I have one problem with this coding. This form is a continuous form and same Sum are being returned with this coding. I need to sum all 'actprod' that have same 'deptbudno' or return 0 if null. right now, every record is returning same "169" where its only true for a1(deptbudno). ie. a1 |...

is it possible to get rid of msg "You are about to run an update query that will modify data in your table"? My users are complaining to receive that msg and another post message "You are about to update ?? row(s). It pops up 3 times because I have 3 update queries. I tried to combine them but...

is it possible to run multiple queries at once? ie. DoCmd.OpenForm "frm_frmDeptBudget", , "qry_DeptactTxDetail_sum" And "qry_DeptBudTxDetail" And "qtest

I have 2 tables. tbl_DeptBudget which contains .DeptbudNo, .DeptbudAmt,etc and tbl_BudgetDetail which contains .DeptbudNo, .BudTxAmt,etc DeptBudget is the main table and DeptbudNo is unique. however, BudgetDetail can contain same DeptbudNo. The sum of tbl_BudgetDetail.BudTxAmt is equal...

I have a continuous form "frm_DeptBudget" (tbl_DeptBudget) when user clicks a textbox, i want another continuous form to open. That new form "frm_BudDetail" should only show the record which consist of same 'txtDeptBudNo'. (tbl_deptBudget and tbl_budDetail share that key) I figured the easiest...

I am currently running on microsoft vista and Im having a problem with ms access 2003. I was able to open and use access forms but for some reason, when i transferred the database to another system /w vista, im getting an error msg "the expression on On Click Event produced a following error...