Trouble with "Time and Billing Database" template

[jdj912]

Hello, I'm new to using online templates but need a new database that this
template is set up well to use, but I'm not a expert in Access, I understand
the basics, but not the more complicated code. As I said, I like the general
setup of this template but have noticed a couple of bugs that I'm not sure
how to fix. (There's a Dlookup on the timecard report that isn't functioning
correctly and the timecard report doesn't print correctly). I just started
getting into this (to set it up for my business) and noticed these bugs.
Does anyone have any advice? Should I scrap this and find a different
template? Has anyone used this template and aware of easy fixes?
Thank you, any help would be appreciated.

 

[Arvin Meyer [MVP]]

Supply a link to the template and I'll have a look.

 

[Rob Parker]

Hi,

About 6 months ago, there was another question regarding this particular
database, and I looked at the report printing problem. Here's what I posted
back then (and the original problem - it's likely, but not necessarily the
same as yours):

<begin quote>

Seemed like an intriguing problem, so I downloaded the A2007 version of the
Time and Billing template (I usually use A2003) and gave it a try. And
found the same problem.

The underlying cause is in the macro code (I normally use VBA code, rather
than macros), which is closing the Project Details form before opening the
report; the report therefore opens with the ProjectID set in its design
parameter (1), and not with the ProjectID for the project showing on the
form. If you move the Close statement to below the OpenReport line (and
below the RunCommand line also, if you wish) then it will work. You'll also
need to give the arguments to close the form, rather than leave them blank,
otherwise they will default to the object with focus (the report). The
arguments you need are:
Object Type: Form
Object Name: Project Details
The form needs to be closed because it's open in dialog mode, so you can't
get to see the report behind it unless you drag it around the screen - it
will always be present as the top object.

Note also that if you open the Invoice report from the Navigation panel, you
may find that it displays details for the project invoice most recently
opened in its subreports (for Employee Billables, Expenses and Payments),
but the totals aggregated at the foot of the report are those for ProjectID
= 1.

Installed Time and Billing (2007) template. I've created a few records.
When I go to print invoice from the project details screen, only the first
record appears. I can't toggle, or even print any other records. I've
looked at all the filters, event procedures, etc., but I can't figure this
out.

<end quote>

I've not noticed a problem with the DLookup, but I'll have a look and post
again if I find something.

HTH in the meantime,

Rob

 

[Rob Parker]

I've had a look in the A2007 version of this template, and can't see any
DLookups in the timecard report (assuming that you mean the report named
"Employee Time", which is the one I would consider to be the timecard).
I've also looked at the A2003 version of this template, and in that database
the only report which has any DLookups is the Invoice report - and the
DLookups seem to work correctly. Could you tell me exactly which template
you are using, and exactly which report/controls you are having problems
with.

Rob

I've not noticed a problem with the DLookup, but I'll have a look and post
again if I find something.

<snip>

 

[Rob Parker]

I've had a look in the A2007 version of this template, and can't see any
DLookups in the timecard report (assuming that you mean the report named
"Employee Time", which is the one I would consider to be the timecard).
I've also looked at the A2003 version of this template, and in that database
the only report which has any DLookups is the Invoice report - and the
DLookups seem to work correctly. Could you tell me exactly which template
you are using, and exactly which report/controls you are having problems
with.

Rob

I've not noticed a problem with the DLookup, but I'll have a look and post
again if I find something.

<snip>

 

[jdj912]

Rob (and Arvin) thanks for taking a look at this for me. I skimmed through
your posts, but unfortunately don't have the time at the moment to work on
it. I will look through the info and my DB later today and will post back by
tomorrow morning w/ what I've resovled and what I still need help with.

Thank you so much for the help

 

[jdj912]

Rob, the thread that you quoted does sound like the issue I'm having. I'll
go through that thread and see if I can fix and figure out how to better
specify the problem I'm having w/ the DLOOKUP. Thanks again.

 

[Susan Guggenheim]

I am trying to fix the Invoice report of the Time and Billing Access 2007 template database. I do see the problem, it's as you described -
"Note also that if you open the Invoice report from the Navigation panel, you may find that it displays details for the project invoice most recently opened in its subreports (for Employee Billables, Expenses and Payments),
but the totals aggregated at the foot of the report are those for ProjectID = 1."

But the only Macro I see is one called Filters and I'm not seeing the statements you referenced: "If you move the Close statement to below the OpenReport line (and below the RunCommand line also, if you wish) then it will work."

When I open the Macro Editor, there is one macro, about Filters, containing 8 macros, none of which contain an OpenReport line.

Admittedly, I'm not an expert, but where could this Report macro live? THANK YOU!
Susan



Rob Parker wrote:

Hi,About 6 months ago, there was another question regarding this
01-Feb-10

Hi

About 6 months ago, there was another question regarding this particula
database, and I looked at the report printing problem. Here is what I poste
back then (and the original problem - it is likely, but not necessarily th
same as yours)

<begin quote

Seemed like an intriguing problem, so I downloaded the A2007 version of th
Time and Billing template (I usually use A2003) and gave it a try. An
found the same problem

The underlying cause is in the macro code (I normally use VBA code, rathe
than macros), which is closing the Project Details form before opening th
report; the report therefore opens with the ProjectID set in its desig
parameter (1), and not with the ProjectID for the project showing on th
form. If you move the Close statement to below the OpenReport line (an
below the RunCommand line also, if you wish) then it will work. You'll als
need to give the arguments to close the form, rather than leave them blank
otherwise they will default to the object with focus (the report). Th
arguments you need are
Object Type: For
Object Name: Project Detail
The form needs to be closed because it is open in dialog mode, so you canno
get to see the report behind it unless you drag it around the screen - i
will always be present as the top object

Note also that if you open the Invoice report from the Navigation panel, yo
may find that it displays details for the project invoice most recentl
opened in its subreports (for Employee Billables, Expenses and Payments)
but the totals aggregated at the foot of the report are those for ProjectI
= 1

<end quote

I have not noticed a problem with the DLookup, but I will have a look and pos
again if I find something

HTH in the meantime

Rob

Previous Posts In This Thread:

Trouble with "Time and Billing Database" template
Hello, I am new to using online templates but need a new database that thi
template is set up well to use, but I am not a expert in Access, I understan
the basics, but not the more complicated code. As I said, I like the genera
setup of this template but have noticed a couple of bugs that I am not sur
how to fix. (There is a Dlookup on the timecard report that is not functionin
correctly and the timecard report does not print correctly). I just starte
getting into this (to set it up for my business) and noticed these bugs
Does anyone have any advice? Should I scrap this and find a differen
template? Has anyone used this template and aware of easy fixes
Thank you, any help would be appreciated.

Supply a link to the template and I will have a look.
Supply a link to the template and I will have a look
-
Arvin Meyer, MCP, MV
http://www.datastrat.co
http://www.mvps.org/acces
http://www.accessmvp.com

Hi,About 6 months ago, there was another question regarding this
Hi

About 6 months ago, there was another question regarding this particula
database, and I looked at the report printing problem. Here is what I posted
back then (and the original problem - it is likely, but not necessarily the
same as yours):

<begin quote>

Seemed like an intriguing problem, so I downloaded the A2007 version of the
Time and Billing template (I usually use A2003) and gave it a try. And
found the same problem.

The underlying cause is in the macro code (I normally use VBA code, rather
than macros), which is closing the Project Details form before opening the
report; the report therefore opens with the ProjectID set in its design
parameter (1), and not with the ProjectID for the project showing on the
form. If you move the Close statement to below the OpenReport line (and
below the RunCommand line also, if you wish) then it will work. You'll also
need to give the arguments to close the form, rather than leave them blank,
otherwise they will default to the object with focus (the report). The
arguments you need are:
Object Type: Form
Object Name: Project Details
The form needs to be closed because it is open in dialog mode, so you cannot
get to see the report behind it unless you drag it around the screen - it
will always be present as the top object.

Note also that if you open the Invoice report from the Navigation panel, you
may find that it displays details for the project invoice most recently
opened in its subreports (for Employee Billables, Expenses and Payments),
but the totals aggregated at the foot of the report are those for ProjectID
= 1.


<end quote>

I have not noticed a problem with the DLookup, but I will have a look and post
again if I find something.

HTH in the meantime,

Rob

I have had a look in the A2007 version of this template, and cannot see
I have had a look in the A2007 version of this template, and cannot see any
DLookups in the timecard report (assuming that you mean the report named
"Employee Time", which is the one I would consider to be the timecard).
I have also looked at the A2003 version of this template, and in that database
the only report which has any DLookups is the Invoice report - and the
DLookups seem to work correctly. Could you tell me exactly which template
you are using, and exactly which report/controls you are having problems
with.

Rob


<snip>
<snip>

I have had a look in the A2007 version of this template, and cannot see
I have had a look in the A2007 version of this template, and cannot see any
DLookups in the timecard report (assuming that you mean the report named
"Employee Time", which is the one I would consider to be the timecard).
I have also looked at the A2003 version of this template, and in that database
the only report which has any DLookups is the Invoice report - and the
DLookups seem to work correctly. Could you tell me exactly which template
you are using, and exactly which report/controls you are having problems
with.

Rob


<snip>
<snip>

Rob (and Arvin) thanks for taking a look at this for me.
Rob (and Arvin) thanks for taking a look at this for me. I skimmed through
your posts, but unfortunately do not have the time at the moment to work on
it. I will look through the info and my DB later today and will post back by
tomorrow morning w/ what I have resovled and what I still need help with.

Thank you so much for the help

Rob, the thread that you quoted does sound like the issue I am having.
Rob, the thread that you quoted does sound like the issue I am having. I will
go through that thread and see if I can fix and figure out how to better
specify the problem I am having w/ the DLOOKUP. Thanks again.


Submitted via EggHeadCafe - Software Developer Portal of Choice
WPF Report Engine, Part 1
http://www.eggheadcafe.com/tutorial...74-4eba5c821311/wpf-report-engine-part-1.aspx

 

[Rob Parker]

Hi Susan,

I'm not exactly sure whether you've got the same problem as I answered
previously. The original question I answered was:

When I go to print invoice from the project details screen, only the first
record appears. I can't toggle, or even print any other records. ...

The macro I was referring to is the embedded macro for the Print Invoice
button on the Projects Details screen. To get to it, open the Project
Details form in design mode (you'll need to do that from the navigation
panel, rather than changing the view when you open it from the Project List
form, since it's opened in dialog mode), select the button (it's named
cmdPrintInvoice) and then open the embedded macro for the On Click event
(via the Events tab of the property sheet). Then make the changes I
suggested.

The other problem I referred briefly to, and which you quote in you post, is
that if you open the Invoice report from the Navigation Panel, it displays
inconsistent data. This should not normally be a problem - open/print the
Invoice report from a form and all should be OK. However,I've just played
with the database some more, and find that this same issue arises if you
print the Invoice from the Project List form, by selecting it from the
Reports drop-down in the form header. To get the Invoice for the selected
record in the Project List form to print correctly, you will need to modify
the embedded macro for the After Update event of the Reports combo-box,
cboReports (procedure as described above for cmdPrintInvoice). Select the
Action in the macro which reads "OpenReport"; then, in the Action Arguments
section at the bottom of the macro editscreen, enter the following in the
Where Condition line:
[ProjectID]=[Forms]![Project List]![ID]

And that should fix things - at least as far as Invoice printing goes ;-)

Rob


in message

I am trying to fix the Invoice report of the Time and Billing Access 2007
template database. I do see the problem, it's as you described -
"Note also that if you open the Invoice report from the Navigation panel,
you may find that it displays details for the project invoice most
recently opened in its subreports (for Employee Billables, Expenses and
Payments),
but the totals aggregated at the foot of the report are those for
ProjectID = 1."

But the only Macro I see is one called Filters and I'm not seeing the
statements you referenced: "If you move the Close statement to below the
OpenReport line (and below the RunCommand line also, if you wish) then it
will work."

When I open the Macro Editor, there is one macro, about Filters,
containing 8 macros, none of which contain an OpenReport line.

Admittedly, I'm not an expert, but where could this Report macro live?
THANK YOU!
Susan



Rob Parker wrote:

Hi,About 6 months ago, there was another question regarding this
01-Feb-10

Hi,

About 6 months ago, there was another question regarding this particular
database, and I looked at the report printing problem. Here is what I
posted
back then (and the original problem - it is likely, but not necessarily
the
same as yours):

<begin quote>

Seemed like an intriguing problem, so I downloaded the A2007 version of
the
Time and Billing template (I usually use A2003) and gave it a try. And
found the same problem.

The underlying cause is in the macro code (I normally use VBA code, rather
than macros), which is closing the Project Details form before opening the
report; the report therefore opens with the ProjectID set in its design
parameter (1), and not with the ProjectID for the project showing on the
form. If you move the Close statement to below the OpenReport line (and
below the RunCommand line also, if you wish) then it will work. You'll
also
need to give the arguments to close the form, rather than leave them
blank,
otherwise they will default to the object with focus (the report). The
arguments you need are:
Object Type: Form
Object Name: Project Details
The form needs to be closed because it is open in dialog mode, so you
cannot
get to see the report behind it unless you drag it around the screen - it
will always be present as the top object.

Note also that if you open the Invoice report from the Navigation panel,
you
may find that it displays details for the project invoice most recently
opened in its subreports (for Employee Billables, Expenses and Payments),
but the totals aggregated at the foot of the report are those for
ProjectID
= 1.


<end quote>

<snip>

 

[Susan Guggenheim]

I figured it out - this is what I did:

Open Invoice Report in Design Mode.
Scroll down to Group|Sort|Total section, below the report.
At the top level of grouping, change what is there (probably "expression") to ProjectID.
View as a Report, then Save.

That's it, I think.
Susan



Susan Guggenheim wrote:

Rob, could you give me a little more direction
08-Apr-10

I am trying to fix the Invoice report of the Time and Billing Access 2007 template database. I do see the problem, it's as you described -
"Note also that if you open the Invoice report from the Navigation panel, you may find that it displays details for the project invoice most recently opened in its subreports (for Employee Billables, Expenses and Payments),
but the totals aggregated at the foot of the report are those for ProjectID = 1."

But the only Macro I see is one called Filters and I'm not seeing the statements you referenced: "If you move the Close statement to below the OpenReport line (and below the RunCommand line also, if you wish) then it will work."

When I open the Macro Editor, there is one macro, about Filters, containing 8 macros, none of which contain an OpenReport line.

Admittedly, I'm not an expert, but where could this Report macro live? THANK YOU!
Susan

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Break the Roles in SharePoint Lists
http://www.eggheadcafe.com/tutorial...7-42f2d9110d79/break-the-roles-in-sharep.aspx