Search results

Thnx jdraw but i m not getting required result with this :-(

I have a table order n a table payment. I need to go to the last record in payment table n perform a check on datepaid. I achieved this by using query with last(paymentid). I want to know tht if datepaid of last paymentid is null. Query should fetch the data of previous paymentid for a specific...

Thnx a lot bob....problem solved.

Thnx i tried me.refresh, but its not working:( after updating field "sold price" field on subform1, sumprice field with control source =Nz(sum([Sold price]),0) becomes blank and same happening on the other subform where updating amountpaid field causing sumamount field blank. Both subforms are...

On main form i m using two subforms. On both subforms i m using fields to get sum of amount using sum function n then using these sum amounts on main form for few more calculations. As i update amount fields on subforms, the fields that show the sum of amount goes blank n bcoz of this other...

Thnx....this works fine in VBA but i need this to work with switchboard. Is there anyway to avoid asking input parameter again when switching between different report views?

I have a report tht accepts date as input parameter. Default view of report is set to print view. I m using a switchboard to open the report but it always opens the report in report view and when i change report to print view at runtime, it asks for the input parameter again. I change the switch...

I want to creat a report of lease contract. In which some of the information is static that will remain same in all conract reports but there is some information that changes depending on tenant or you need to remove some clauses of contract in some special cases. Is there anyway that user can...

Thnx a lot khalid.....now it works fine:) an extra"(" without closing ")" was problem.

I m using access 2007. I want to use following update query in access vba but its giving error. Query is: Docmd.RunSQL ("UPDATE property set property.status="& "'empty'" & " Where property.propertyid="& me.cmbpropertyid.value &"") It gives the following error: Missing ),], or item in query...

Thnx Trevor. I created a query based on both tables but i m not sure what criteria to use to get the number of months in a specific year with property status 'empty'.

Access version is 2007.

I have a table name property with fields propertyid, houseno, address, housestatus(empty or rent) and another table lease with fields leaseid, propertyid, startdate, enddate, monthlyrent. I need a yearly report showing the number of months in which house remained empty. Is it possible to...