Re: Time and Billing issue - print invoice only shows one invoice

[elbank]

richard wrote on 07/26/2009 23:36 ET :
> First off I want to thank you for posting your suggestions.
>
> I have created a new database from that template (Access 2007) but I have
> the same problem. I created five new records, basic stuff, new project names
> - when I click on 'print invoice', only the first record shows up. I see
> that 'toggle filter' is activated, so I 'untoggle' it or whatever and it
> takes me to the last (fifth) record. But that is all I'm able to do.
>
> So I close the project details form, start over, open it, go directly to,
> let's say record three, click print invoice and only record one shows up
> ready to print. Again, toggle filter is on.
>
> I created the same template on another computer with a different printer and
> I get the same thing.
>
> "Keven Denen" wrote:
>
>> On Jul 26, 3:49 pm, richard wrote:
>> > I've done that, unfortunately, the single invoice that appears is the
>> first
>> > record and no other record, even if I choose a different record or
>> project.
>> > Any other ideas plz?
>> >
>> > "Keven Denen" wrote:
>> > > On Jul 26, 8:04 am, richard
>> wrote:
>> > > > What am I doing wrong? In the time and billing template
>> (access 2007), when
>> > > > I click on print invoice in the project details window, only
>> one invoice
>> > > > appears. I can't toggle through any of my other invoices.
I'm
>> sure it's
>> > > > something easy to fix but I don't know how. Please help.
>> >
>> > > From what I can tell by looking at that template, this is the
>> designed
>> > > function of the template. It looks like there is one invoice per
>> > > project and the Print Invoice button is designed to only print the
>> > > invoice for whichever project you have open in the project details
>> > > form. If you want to print an invoice for a different project, you
>> > > need to open up that project in the details form.
>> >
>> > > Keven Denen
>>
>> Have you messed with the database structure? I just created a new
>> database from that template and it works just fine on my machine.
>>
>> Keven Denen
>>
>>
>>
>
I presume that after all this time you found your answer. However, I thought
it
useful to post my found solution to the same issue. After not using the Time
and
Billing setup for awhile, I had the same issue that you posted. It was like
the
twilight zone, as what was previously working did not now work. Here is what I
discovered, which you perhaps did as well:

You need to open the Project Details form by clicking on the hyperlink in the
form Project List (in ID Column). In this manner the correct project data is
collected for the invoice. By the way, if the Project Details is opened in
this
manner (instead of double clicking on the form in the Navigation Bar) you can
also go to other projects in the form, and the Invoice report will perform
correctly.

P.S. even if you found the answer, perhaps others who google for a solution
will
find this.