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!

  • Congratulations strongm 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 wshm

  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"

    is there any simpler way? there must be easier way to carry over the data..
  3. 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()??
  4. wshm

    update query not updating current record

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

    update query not updating current record

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

    update query not updating current record

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

    Displaying information in a textbox using dlookup

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

    Displaying information in a textbox using dlookup

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

    query delaying updates

    requery? tables? and yes it's a bound form.
  11. 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...
  12. 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...
  13. wshm

    duplicate data record = ?

    DSum surely worked =)
  14. 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 =...

Part and Inventory Search

Back
Top