Search results

It work great! Thank you!

Hi! I try to use Nz function in my report but when I quit and come back to my report, the Nz function has disappeared. I think it's because I don't use it correctly but I don't know how.... I want this calculated field (who is ok) =[item30]-[paiement30] return 0 if is null. I tried this...

The problem is that before I type a new payment, the value of the field is null and the sum is not done. So in the main form, the field will be empty until I type a payment. But this field is used to calculate an other field.

The One side (main form) is the number of a bill. In the main form I have too some calculated field like total of payment. In the subform, I have the payments linked to the bill. I want that if I create a new payment, the total in the mainform is updated.

How can I update a field in a form after an AfterUpdate event of a field in the subform. When I create a new record in the subform, I want that this new data update a field in the form. Thanks

It's ok, I found a solution. Thanks

Hi I have a report who print bill. In the detail section I have different number of item (maximum of 6), but I want that for any number of items, the height of the section is always the same (like when there is 6 items even if I have just one). Is there a way to set this? Thanks

I want to code a function that checks if the number of record in a table is > 0. If count(table.record=-1) > 0 DoCmd... DoCmd... DoCmd... Thanks

Hi! I would print a report (3 copy) from a form on close event. I can't use the PrintOut command (it print the current form/report and I'm in a form) and we can't choose the number of copy in the OpenReport command. Thanks