Search results for query: *

nevermind.. found an easier way

i guess it's mostly my syntax. not familiar with vb and recordset etc. i've tried doing Emails = rs.getrows() where rs is the databse

i've tried getting rows from recordset but it's not working... Can you possibly elaboratE?

I'd like to set up an afterevent property of a commandbox to email everyone that's in the table "tbl_Staff" how can this be done? I've tried doing Dlookup and creating other strings but I can only add one email address and one cc. how can i add multiple email address?

perfect. thank you phv

i have a field named 'Payer' in a form called LogTx. When user clicks Open, I'd like to check and see if there's another data with the same payer name. I have no problem doing this using DLookUp or query but I was wondering if you can call records that contains first 3 letters from the 'payer'...

any idea?

try this. Create a form and add a textbox (txtWorkID) and a list box (lstCsID). Double click the list box to open up it's property. on row Source:, type in SELECT tbl.worker_id, tbl.cs_id FROM tbl WHERE((TBL.worker_id)=forms!formname!txtworkid)); 'tbl should be change to name of your table...

well dLookUp will look something like me.txtcsid = DLookUp("cs_id","table","worker_id='" & me.[txtWorkerID] & "'") this will not be able to populate all records on one form. I'd recommend using a text box and a list box that populates after event of the text box.

maybe i understood wrong. So you need to see all 5 record on one page? perhaps what you are looking for is continuous form

Query1. UPDATE tbl_BudMaster SET tbl_BudMaster.ActAmt = DSum("budgetamt","tbl_Vregister","budgetkey = '" & budgetkey & "'")+DSum("BalanceAmt","tbl_PSC","budgetkey='" & budgetkey & "'")+DSum("tranxAmt","tbl_DeptActTxDetail","budgetkey = '" & budgetkey & "'"); Query2. UPDATE tbl_BudMaster SET...

hi, how are ya. I think the easiest way to do it is to use a query. or you can also use the DLookUp function. it'd make more sense if you list your fields..

i have two update query that runs dynamically. Query1 -> Query2. Query1 gathers sum amounts from other tables. tbl_master.CashedAmt = Dsum(value1) + Dsum(value2) etc. where both values are from different table. tbl_master.Original amount is recorded by user. Query2, is a simple update query...