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

    Query that will sum 2values from 2 different crosstab 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 =...
  2. wshm

    setting default value as "previous input"

    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()??
  3. wshm

    update query not updating current record

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

    query delaying updates

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

    automatically find the next available number?

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

    duplicate data record = ?

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

    update if "data" exists in table else then (repost)

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

    form record bound to 2 tables?

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

    opening excel file under if statement

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

    DlookUp function in Continous form

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

    sum of column 1 / sum of colum 2 (repost)

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

    open excel spreadsheet from form

    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?
  13. wshm

    sum of distint field 1 / sum of distinct field 2

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

    bound = calculated

    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?
  15. wshm

    Dsum and Dlookup at same time?

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

    can you get rid of pop up msg "you are about to run an update query.."

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

    running multiple queries

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

    distinct total?

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

    filtering /w query

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

    ms access ole server/ active x ERROR

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

Part and Inventory Search

Back
Top