Recent content by andsweet

  1. A

    Help with code

    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...
  2. A

    Getting data from closed forms

    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...
  3. A

    Time & Billing

    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.
  4. A

    Time & Billing

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

    Time & Billing

    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...
  6. A

    Time & Billing Beta 1

    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
Back
Top Bottom