Problem with a template from the MS Office website

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi everyone

I downloaded the Time and Billing database from the MS Office site
(http://office.microsoft.com/en-us/templates/TC010184611033.aspx) and I've
had problems with the Preview Invoice function on the first page. When I use
it, opens the VBA interface and stops at <Me![Print Invoice Time
Subform].Requery>, indicating that this Subform isn't there - but it is in
the list of forms in the database!

I know it's a long shot, but has anyone else had experience of this and, if
so, how was it resolved? I don't know if it's relevant, but I'm using Access
2003 on a PC with XP Pro SP2.

Needless to say, I have *very* little experience of VBA and I think that the
problem lies in there somewhere. If necessary, I could post the code where
the error is generated (it's only 4 lines long!).

I've posted this question in this forum because the problem relates to a
report. I suppose I could try a VBA forum, but it's only my thought that the
VBA may be the site of the error. I know that cross-posting is discouraged
strongly.

Thanks for your time and patience.
 
Popeye:

Yes, that Print Invoice form from the current download is totally screwed
up. There are missing subforms, and controls so that the Invoice Report
itself won't work at all.

I've corrected the problems with that form and with the Invoice report that
it produces and the revised db can be found on our web in the free files
area under "Fixed MS Time and Expense database". We've sent it on to
Microsoft as well.
 
Thank you Steve for the prompt response!

It was a long shot when I posted as I thought it very unlikely that anyone
else would have downloaded the database and had the time and inclination to
get it working. I'm very surprised that MS posted something which didn't
work as expected so I just wondered if it was something to do with my PC and
settings.

I've seen something else which needs a tweak: in the summary area of the
"Project: ......" form, the Total Hours is given as a value with a leading
<$>. I realise that it's easy to edit the form design to get rid of this,
but you might just want to edit the database on your site.

I'll continue to "play" with this and see if it meets my requirements. If I
find any obvious flaws, I'll post again so you can either change the database
further or remove it from your site! If the tweaks are "cosmetic" (such as
removal of the dollar symbol), you may prefer to let users do that
themselves, so long as the relationships, code, forms, controls etc. function
as they should.

Once again, many thanks for the rapid response and direction to your
website. I'll be interested to see if MS put your modified version on their
site.
 
Steve - since I just responded, I've found a glich which is in your modified
version which wasn't in the original one. When I click the Projects Task, it
produces a series of InputBoxes which require a Parameter for the Begin Date,
the End Date the Project ID. When I enter these, it delivers the Projects
Form, but there is <#Error> in the Total Expenses, Total Billing and Amount
Due in the summary area at the bottom of the Projects Form.

When I clicked the same button in the original MS database, it went straight
to the Projects Form without the InputBoxes and the correct values were
displayed, rather than the <#Error> messages.

SA said:
Popeye:

Yes, that Print Invoice form from the current download is totally screwed
up. There are missing subforms, and controls so that the Invoice Report
itself won't work at all.

I've corrected the problems with that form and with the Invoice report that
it produces and the revised db can be found on our web in the free files
area under "Fixed MS Time and Expense database". We've sent it on to
Microsoft as well.

--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

Popeye said:
Hi everyone

I downloaded the Time and Billing database from the MS Office site
(http://office.microsoft.com/en-us/templates/TC010184611033.aspx) and I've
had problems with the Preview Invoice function on the first page. When I
use
it, opens the VBA interface and stops at <Me![Print Invoice Time
Subform].Requery>, indicating that this Subform isn't there - but it is in
the list of forms in the database!

I know it's a long shot, but has anyone else had experience of this and,
if
so, how was it resolved? I don't know if it's relevant, but I'm using
Access
2003 on a PC with XP Pro SP2.

Needless to say, I have *very* little experience of VBA and I think that
the
problem lies in there somewhere. If necessary, I could post the code
where
the error is generated (it's only 4 lines long!).

I've posted this question in this forum because the problem relates to a
report. I suppose I could try a VBA forum, but it's only my thought that
the
VBA may be the site of the error. I know that cross-posting is
discouraged
strongly.

Thanks for your time and patience.
Click to expand...
Click to expand...
 
Hi Steve

Having spent a couple of hours playing around with this, I haven't a clue
why it doesn't work! I've also found other areas where the original database
doesn't work either - i.e. when looking at the Timecards, the title doesn't
correlate with the Employee names in the drop down list. The title stays as
"Lene Aalling", even if the record number is incremented at the bottom of the
form.

It's a real pity that this doesn't work as it could be a really useful
database. I suppose I'll just have to continue playing around - almost by
trial and error. I suspect it will be ages before my Access and VBA skills
are sufficiently honed to be able to understand what's going on or, perhaps
more importantly, what's *not* happening to make it work correctly!

SA said:
Popeye:

Yes, that Print Invoice form from the current download is totally screwed
up. There are missing subforms, and controls so that the Invoice Report
itself won't work at all.

I've corrected the problems with that form and with the Invoice report that
it produces and the revised db can be found on our web in the free files
area under "Fixed MS Time and Expense database". We've sent it on to
Microsoft as well.

--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

Popeye said:
Hi everyone

I downloaded the Time and Billing database from the MS Office site
(http://office.microsoft.com/en-us/templates/TC010184611033.aspx) and I've
had problems with the Preview Invoice function on the first page. When I
use
it, opens the VBA interface and stops at <Me![Print Invoice Time
Subform].Requery>, indicating that this Subform isn't there - but it is in
the list of forms in the database!

I know it's a long shot, but has anyone else had experience of this and,
if
so, how was it resolved? I don't know if it's relevant, but I'm using
Access
2003 on a PC with XP Pro SP2.

Needless to say, I have *very* little experience of VBA and I think that
the
problem lies in there somewhere. If necessary, I could post the code
where
the error is generated (it's only 4 lines long!).

I've posted this question in this forum because the problem relates to a
report. I suppose I could try a VBA forum, but it's only my thought that
the
VBA may be the site of the error. I know that cross-posting is
discouraged
strongly.

Thanks for your time and patience.
Click to expand...
Click to expand...
 
Popeye:

Our apologies for posting it "before its time" we looked at the issues you
noted and have resolve them and reposted them the updated db to our web.
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

Popeye said:
Hi Steve

Having spent a couple of hours playing around with this, I haven't a clue
why it doesn't work! I've also found other areas where the original
database
doesn't work either - i.e. when looking at the Timecards, the title
doesn't
correlate with the Employee names in the drop down list. The title stays
as
"Lene Aalling", even if the record number is incremented at the bottom of
the
form.

It's a real pity that this doesn't work as it could be a really useful
database. I suppose I'll just have to continue playing around - almost by
trial and error. I suspect it will be ages before my Access and VBA
skills
are sufficiently honed to be able to understand what's going on or,
perhaps
more importantly, what's *not* happening to make it work correctly!

SA said:
Popeye:

Yes, that Print Invoice form from the current download is totally screwed
up. There are missing subforms, and controls so that the Invoice Report
itself won't work at all.

I've corrected the problems with that form and with the Invoice report
that
it produces and the revised db can be found on our web in the free files
area under "Fixed MS Time and Expense database". We've sent it on to
Microsoft as well.

--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

Popeye said:
Hi everyone

I downloaded the Time and Billing database from the MS Office site
(http://office.microsoft.com/en-us/templates/TC010184611033.aspx) and
I've
had problems with the Preview Invoice function on the first page. When
I
use
it, opens the VBA interface and stops at <Me![Print Invoice Time
Subform].Requery>, indicating that this Subform isn't there - but it is
in
the list of forms in the database!

I know it's a long shot, but has anyone else had experience of this
and,
if
so, how was it resolved? I don't know if it's relevant, but I'm using
Access
2003 on a PC with XP Pro SP2.

Needless to say, I have *very* little experience of VBA and I think
that
the
problem lies in there somewhere. If necessary, I could post the code
where
the error is generated (it's only 4 lines long!).

I've posted this question in this forum because the problem relates to
a
report. I suppose I could try a VBA forum, but it's only my thought
that
the
VBA may be the site of the error. I know that cross-posting is
discouraged
strongly.

Thanks for your time and patience.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top