Ask a new question

Access Template Time and Billing

I am new to Access and not to experienced with macro's etc.

I am using Access in Office 365 and the downloaded the template from Microsoft

When I use the "Print Invoice" from the Project Detail form, the incorrect project information and values are displayed, it shows the information for another project (seems to show the first one in the Project list table list) regardless with project I have in the Project details form.

It does not appear to be updating the project ID from the record on display when creating the Invoice.

I believe this is a known issue but I cannot find the answer to sorting it, both on the internet or in within Microsoft I would appreciate your help as the rest of the template works very well.

Answer
Answer
PS:  You might also want to put the following in the Close event procedure of the Project Details form, to automatically close the report when the form is closed:

    On Error Resume Next
    DoCmd.Close acReport, "Invoice"
_____________________
Ken Sheridan,
Newport, Shropshire, England

"Don't write it down until you understand it!" - Richard Feynman

1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated December 30, 2022 Views 164 Applies to: