Recent content by andsweet

I have adapted the Service Management DB that comes with Access. I would like to perform the following: I have form A. This contains details of customers. Inside from A is a subform A1. This contains details of all jobs for the customer that is being viewed. On form A there is a command button...

I have a form which I am trying to get information displayed from another form which is not opened. The unopened form contains text. I need to display this text on the main form which contains a subform. I have tried to enter the path which I think is correct however I still get #NAME or #Error...

Thanks but that did not work either. It appears that if I use the =nz expression it works but I only get the total for the one entry. If I use the =Sum expression then I get #Error and #Name. Hope this helps.

Unfortunately I cannot attach the DB as the compressed file exceeds the permitted value.

I am trying to adapt the Time & Billing sample DB that ships with Access 2000. There is a Workorders Parts subform inside the Workorders Form. I have tried adding an extra 2 columns in the subform ie. markup percent and total cost of parts (includes unit price, VAT and markup) This all works...

Access 2000 Do you perhaps have this programme in Access 2000 format? If so, can you please email it to me or provide a link for me to download it from. Thanks