Search results for query: *

okay... it's printing out blank pages no matter what now... can anyone guess what's going on?

If i double click and open the form (from navigatio window; donno what else to call it), it seems like everything is working fine. Prints the current page after clicking the command button like it should. However, if I open the same form from another form (ex. Menu -> command button ->...

ignore this post. I unbounded the combo box and it's working fine now.

I have a form which consist of a combo box and text boxes. text boxes are automatically filled in after a selection from the combo box. My main goal was to let the user Print (using a command button) a current record. By current record i mean the data based on user's selection of the combo...

actually the "amount" and "PRamt"is currency, "contractID" is text in both table. I am still getting the type conversion error. is there anything more i can try? I've been recently getting lot of this error using vista. could that be why?

i get error ".. due to a type conversion failure" thx for the replay btw

I have an update query which updates a master table based on a sub table. here's the SQL of the update query: UPDATE tbl_ContractLedger AS C INNER JOIN tbl_CapitalPrs AS P ON C.ContractID = P.ContractID SET C.PRamt = NZ(DSum("Amount","tbl_CapitalPrs","ContractID='" & [C].[ContractID] & "'"),0)...

Well the total amount needs to be updated after each transactio so I wanted to run the query after each entry to keep it updated. is there another way to do this?

is there a difference between these two queries? UPDATE tbl_ContractLedger AS C INNER JOIN tbl_CapitalPrs AS P ON C.ContractID = P.ContractID SET C.PRamt = NZ(DSum("Amount","tbl_CapitalPrs","ContractID='" & [C].[ContractID] & "'"),0) WHERE (((P.[ApprovalCode])="n")); vs UPDATE...

LEFT JOIN did not work. Thank you for your input though. is there no way to make this work then?

I have an update query which updates a master table based on a sub table. here's the SQL of the update query: UPDATE tbl_ContractLedger AS C INNER JOIN tbl_CapitalPrs AS P ON C.ContractID = P.ContractID SET C.PRamt = NZ(DSum("Amount","tbl_CapitalPrs","ContractID='" & [C].[ContractID] & "'"),0)...

k i figured it out. it was because I accidentally bounded the combo box. unbound and it's working fine. thx anyway

i have already tried setting the default record lock settings to "NO LOCKS". any other reasons why this is happening?

I have a simple update query that I need to run in a form but Im having some trouble. at first, my update query wasn't working so I took off docmd.setwarnings = false to see what kind of error msg i get. I am currently getting a msg "Microsoft Office can't update all the records in the...