"Time and Billing" database question -- access

[SBC_2005]

Hi, I downloaded the “Time and Billing†database for access from the
“templates†section of your website yesterday. The link is:
http://office.microsoft.com/en-us/templates/TC010184611033.aspx.

I have office 2003 and Windows XP. Everything works fine until I click on
“Projects.†When I click on “Projects,†instead of seeing numbers in the
fields for “Total Hours,†“Hourly Billings†and “Total Expenses;†the word
“#Name?†appears in each field. Also, the word “#Error†appears in the
“Total Billing†and “Amount Due†fields.

I know the program is adding up all of my hours because the reports print
correctly. Any idea how I can fix the error messages?

Please, please, please help!

Best,
Susanna

 

[tina]

this is not Microsoft Support, or Microsoft Customer Service. all of the
microsoft.public.access... newsgroups are public user forums where anyone
can ask and/or answer a posted question.

i downloaded the Time and Billing template from the MS website just now to
take a look. from the Main Switchboard, i clicked on Enter/View Clients.
then i clicked on the Projects... command button in the form's header
section. on my pc, the Projects form is working normally, showing all totals
including in the controls you mentioned.

did you change *anything* in your copy of the database besides the actual
data? such as the name of a form, control, table, field - anything?

 

[PC Datasheet]

#Name appears because a reference to a field in the formulas is either
misspelled or does not exist. Look at the formulas. Did you change the name
of a field or delete the field? Since #Name appears three times, it would
seem that the problem in all three formulas is the same field. #Error is
occurring because of the first problem. Fix it and #Error will go away.

 

[SBC_2005]

Hi PC Datasheet,

I'm brand new to access, and I didn't touch anything. These are the
formulas -- can you tell what's wrong?

=IIf([Projects Subform].Form.RecordsetClone.RecordCount=0,0,[Projects
Subform].Form![TotalHoursWorked])

=IIf([Projects Subform].Form.RecordsetClone.RecordCount=0,0,[Projects
Subform].Form![Total Billed])

=IIf([Project Expenses Subform].Form.RecordsetClone.RecordCount=0,0,[Project
Expenses Subform].Form![Total Expenses])

=[Total Hourly Billings]+[Total Expenses]

=IIf(IsNull([ProjectID]),0,DSum("[PaymentAmount]","Payments","[ProjectID]="
& [ProjectID]))

 

[SBC_2005]

Hi Tina,

I didn't change anything, I swear! Any ideas?

 

[SBC_2005]

Hi Tina,

I didn't change anything, I swear! Any ideas?

 

[PC Datasheet]

Your reference to the subform's recordsetclone and field on the subform seem
to be wrong. The general syntax is:
Forms!NameOfMainForm!NameOfSubformControl.Form.RecordsetClone
Forms!NameOfMainForm!NameOfSubformControl.Form!NameOfFieldOnSubform

To emphasize, you use the name of the subform control and not the name of
the subform form!!!!

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

Hi PC Datasheet,

I'm brand new to access, and I didn't touch anything. These are the
formulas -- can you tell what's wrong?

=IIf([Projects Subform].Form.RecordsetClone.RecordCount=0,0,[Projects
Subform].Form![TotalHoursWorked])

=IIf([Projects Subform].Form.RecordsetClone.RecordCount=0,0,[Projects
Subform].Form![Total Billed])

=IIf([Project Expenses Subform].Form.RecordsetClone.RecordCount=0,0,[Project
Expenses Subform].Form![Total Expenses])

=[Total Hourly Billings]+[Total Expenses]

=IIf(IsNull([ProjectID]),0,DSum("[PaymentAmount]","Payments","[ProjectID]="
& [ProjectID]))

#Name appears because a reference to a field in the formulas is either
misspelled or does not exist. Look at the formulas. Did you change the name
of a field or delete the field? Since #Name appears three times, it would
seem that the problem in all three formulas is the same field. #Error is
occurring because of the first problem. Fix it and #Error will go away.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

 

[SBC_2005]

Ok, so at the risk of sounding like a moron, how should i change this:

=IIf([Projects Subform].[Form].[RecordsetClone].[RecordCount]=0,0,[Projects
Subform].[Form]![TotalHoursWorked])

to make it look like what you said needs to be done?

Your reference to the subform's recordsetclone and field on the subform seem
to be wrong. The general syntax is:
Forms!NameOfMainForm!NameOfSubformControl.Form.RecordsetClone
Forms!NameOfMainForm!NameOfSubformControl.Form!NameOfFieldOnSubform

To emphasize, you use the name of the subform control and not the name of
the subform form!!!!

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

Hi PC Datasheet,

I'm brand new to access, and I didn't touch anything. These are the
formulas -- can you tell what's wrong?

=IIf([Projects Subform].Form.RecordsetClone.RecordCount=0,0,[Projects
Subform].Form![TotalHoursWorked])

=IIf([Projects Subform].Form.RecordsetClone.RecordCount=0,0,[Projects
Subform].Form![Total Billed])

=IIf([Project Expenses Subform].Form.RecordsetClone.RecordCount=0,0,[Project
Expenses Subform].Form![Total Expenses])

=[Total Hourly Billings]+[Total Expenses]

=IIf(IsNull([ProjectID]),0,DSum("[PaymentAmount]","Payments","[ProjectID]="
& [ProjectID]))

#Name appears because a reference to a field in the formulas is either
misspelled or does not exist. Look at the formulas. Did you change the name
of a field or delete the field? Since #Name appears three times, it would
seem that the problem in all three formulas is the same field. #Error is
occurring because of the first problem. Fix it and #Error will go away.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


Hi, I downloaded the "Time and Billing" database for access from the
"templates" section of your website yesterday. The link is:
http://office.microsoft.com/en-us/templates/TC010184611033.aspx.

I have office 2003 and Windows XP. Everything works fine until I click on
"Projects." When I click on "Projects," instead of seeing numbers in the
fields for "Total Hours," "Hourly Billings" and "Total Expenses;" the word
"#Name?" appears in each field. Also, the word "#Error" appears in the
"Total Billing" and "Amount Due" fields.

I know the program is adding up all of my hours because the reports print
correctly. Any idea how I can fix the error messages?

Please, please, please help!

Best,
Susanna

 

[SBC_2005]

I tried this:
=IIf([Forms]![Projects
Subform]![TotalHoursWorked].[Form].[RecordsetClone]=0,0,[Forms]![Projects
Subform]![TotalHoursWorked].[Form]![TotalHoursWorked])

and got the same message. Any ideas?

Ok, so at the risk of sounding like a moron, how should i change this:

=IIf([Projects Subform].[Form].[RecordsetClone].[RecordCount]=0,0,[Projects
Subform].[Form]![TotalHoursWorked])

to make it look like what you said needs to be done?

Your reference to the subform's recordsetclone and field on the subform seem
to be wrong. The general syntax is:
Forms!NameOfMainForm!NameOfSubformControl.Form.RecordsetClone
Forms!NameOfMainForm!NameOfSubformControl.Form!NameOfFieldOnSubform

To emphasize, you use the name of the subform control and not the name of
the subform form!!!!

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

Hi PC Datasheet,

I'm brand new to access, and I didn't touch anything. These are the
formulas -- can you tell what's wrong?

=IIf([Projects Subform].Form.RecordsetClone.RecordCount=0,0,[Projects
Subform].Form![TotalHoursWorked])

=IIf([Projects Subform].Form.RecordsetClone.RecordCount=0,0,[Projects
Subform].Form![Total Billed])

=IIf([Project Expenses Subform].Form.RecordsetClone.RecordCount=0,0,[Project
Expenses Subform].Form![Total Expenses])

=[Total Hourly Billings]+[Total Expenses]

=IIf(IsNull([ProjectID]),0,DSum("[PaymentAmount]","Payments","[ProjectID]="
& [ProjectID]))






:

#Name appears because a reference to a field in the formulas is either
misspelled or does not exist. Look at the formulas. Did you change the name
of a field or delete the field? Since #Name appears three times, it would
seem that the problem in all three formulas is the same field. #Error is
occurring because of the first problem. Fix it and #Error will go away.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


Hi, I downloaded the "Time and Billing" database for access from the
"templates" section of your website yesterday. The link is:
http://office.microsoft.com/en-us/templates/TC010184611033.aspx.

I have office 2003 and Windows XP. Everything works fine until I click on
"Projects." When I click on "Projects," instead of seeing numbers in the
fields for "Total Hours," "Hourly Billings" and "Total Expenses;" the word
"#Name?" appears in each field. Also, the word "#Error" appears in the
"Total Billing" and "Amount Due" fields.

I know the program is adding up all of my hours because the reports print
correctly. Any idea how I can fix the error messages?

Please, please, please help!

Best,
Susanna

 

[PC Datasheet]

It still doesn't appear you have it all!! Is Projects Subform the name of
the subform control on the main form? If so, that part is good. You now need
to add the name of the main form after "Forms". Look at the general syntax I
gave you in my previous response. The syntax is:
Forms!NameOfMainForm!...............

Steve
PC Datasheet

I tried this:
=IIf([Forms]![Projects
Subform]![TotalHoursWorked].[Form].[RecordsetClone]=0,0,[Forms]![Projects
Subform]![TotalHoursWorked].[Form]![TotalHoursWorked])

and got the same message. Any ideas?

Ok, so at the risk of sounding like a moron, how should i change this:

=IIf([Projects Subform].[Form].[RecordsetClone].[RecordCount]=0,0,[Projects
Subform].[Form]![TotalHoursWorked])

to make it look like what you said needs to be done?

Your reference to the subform's recordsetclone and field on the subform seem
to be wrong. The general syntax is:
Forms!NameOfMainForm!NameOfSubformControl.Form.RecordsetClone
Forms!NameOfMainForm!NameOfSubformControl.Form!NameOfFieldOnSubform

To emphasize, you use the name of the subform control and not the name of
the subform form!!!!

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com




Hi PC Datasheet,

I'm brand new to access, and I didn't touch anything. These are the
formulas -- can you tell what's wrong?

=IIf([Projects Subform].Form.RecordsetClone.RecordCount=0,0,[Projects
Subform].Form![TotalHoursWorked])

=IIf([Projects Subform].Form.RecordsetClone.RecordCount=0,0,[Projects
Subform].Form![Total Billed])

=IIf([Project Expenses
Subform].Form.RecordsetClone.RecordCount=0,0,[Project
Expenses Subform].Form![Total Expenses])

=[Total Hourly Billings]+[Total Expenses]


=IIf(IsNull([ProjectID]),0,DSum("[PaymentAmount]","Payments","[ProjectID]="
& [ProjectID]))






:

#Name appears because a reference to a field in the formulas is either
misspelled or does not exist. Look at the formulas. Did you change the
name
of a field or delete the field? Since #Name appears three times, it
would
seem that the problem in all three formulas is the same field. #Error is
occurring because of the first problem. Fix it and #Error will go away.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


Hi, I downloaded the "Time and Billing" database for access from the
"templates" section of your website yesterday. The link is:
http://office.microsoft.com/en-us/templates/TC010184611033.aspx.

I have office 2003 and Windows XP. Everything works fine until I
click on
"Projects." When I click on "Projects," instead of seeing numbers in
the
fields for "Total Hours," "Hourly Billings" and "Total Expenses;" the
word
"#Name?" appears in each field. Also, the word "#Error" appears in
the
"Total Billing" and "Amount Due" fields.

I know the program is adding up all of my hours because the reports
print
correctly. Any idea how I can fix the error messages?

Please, please, please help!

Best,
Susanna

 

[SBC_2005]

Hi Steve!

Ok, here's what I did, and I still can't get it to work:

=IIf([Forms]![Projects]![Projects
Subform].[Form].[RecordsetClone]=0,0,[Forms]![Projects]![Projects
Subform].[Form]![TotalHoursWorked])

I refuse to give up!!! What am I doing wrong?

It still doesn't appear you have it all!! Is Projects Subform the name of
the subform control on the main form? If so, that part is good. You now need
to add the name of the main form after "Forms". Look at the general syntax I
gave you in my previous response. The syntax is:
Forms!NameOfMainForm!...............

Steve
PC Datasheet

I tried this:
=IIf([Forms]![Projects
Subform]![TotalHoursWorked].[Form].[RecordsetClone]=0,0,[Forms]![Projects
Subform]![TotalHoursWorked].[Form]![TotalHoursWorked])

and got the same message. Any ideas?

Ok, so at the risk of sounding like a moron, how should i change this:

=IIf([Projects Subform].[Form].[RecordsetClone].[RecordCount]=0,0,[Projects
Subform].[Form]![TotalHoursWorked])

to make it look like what you said needs to be done?


:

Your reference to the subform's recordsetclone and field on the subform seem
to be wrong. The general syntax is:
Forms!NameOfMainForm!NameOfSubformControl.Form.RecordsetClone
Forms!NameOfMainForm!NameOfSubformControl.Form!NameOfFieldOnSubform

To emphasize, you use the name of the subform control and not the name of
the subform form!!!!

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com




Hi PC Datasheet,

I'm brand new to access, and I didn't touch anything. These are the
formulas -- can you tell what's wrong?

=IIf([Projects Subform].Form.RecordsetClone.RecordCount=0,0,[Projects
Subform].Form![TotalHoursWorked])

=IIf([Projects Subform].Form.RecordsetClone.RecordCount=0,0,[Projects
Subform].Form![Total Billed])

=IIf([Project Expenses
Subform].Form.RecordsetClone.RecordCount=0,0,[Project
Expenses Subform].Form![Total Expenses])

=[Total Hourly Billings]+[Total Expenses]


=IIf(IsNull([ProjectID]),0,DSum("[PaymentAmount]","Payments","[ProjectID]="
& [ProjectID]))






:

#Name appears because a reference to a field in the formulas is either
misspelled or does not exist. Look at the formulas. Did you change the
name
of a field or delete the field? Since #Name appears three times, it
would
seem that the problem in all three formulas is the same field. #Error is
occurring because of the first problem. Fix it and #Error will go away.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


Hi, I downloaded the "Time and Billing" database for access from the
"templates" section of your website yesterday. The link is:
http://office.microsoft.com/en-us/templates/TC010184611033.aspx.

I have office 2003 and Windows XP. Everything works fine until I
click on
"Projects." When I click on "Projects," instead of seeing numbers in
the
fields for "Total Hours," "Hourly Billings" and "Total Expenses;" the
word
"#Name?" appears in each field. Also, the word "#Error" appears in
the
"Total Billing" and "Amount Due" fields.

I know the program is adding up all of my hours because the reports
print
correctly. Any idea how I can fix the error messages?

Please, please, please help!

Best,
Susanna

 

[Albert D. Kallal]

A few things:

First, I downloaded the application, and with a2003, it runs just fine.

2nd:
The forms ref works fine also. You do not need to re-write, or change
the forms ref. While it is true that you normally need the full forms
reference, since the control is on the current form..then you can ELIMINATE
the main forms references (so, all those other posts about trying to fix the
forms ref is a wild goose chase...and....and the download as "is" should
work just fine on your computer). You do NOT need to qualify the full forms
ref as the posters have suggested.

So, what I would do is launch the application, but hold down the shift
key..and not have/allow the main menu form (often called a switch board)
run.

Now, while looking at the application, hit ctrl-g, and then go debug-Compile
"Time and Billing"

Do you get any errors?

It would not make sense for this application to be posted with errors...as
the amount of feedback would be so great as to have the application removed.
It is certainly only a "sample" application..but it does run just fine on my
computer..

What this means is some how you accident modified the application, (or
modified references). Or, there is perhaps something wrong with your install
of office.

So, try the above compile idea.....and make sure it compiles. As a further
thing to try, would be to convert the database to 2002-2003 format, and give
that a try...

Tools->database utilities->convert database.

 

[SBC_2005]

Hi Albert,

Thanks so much for your suggestions -- unfortunately, neither of them worked
:-( Maybe it's something with my computer? Do you have any other ideas?

 

[tina]

hi Susanna. there's nothing more frustrating than an application that works
for other people, but not for you, i know. i see that Albert has entered the
thread; his comments are correct, and as an MVP he's better equipped to help
you solve this problem than i am, so i'll just watch the thread from now
on - and you and i will both learn something!

 

[PC Datasheet]

Ah - Hah!!!

RecordsetClone is not a field and therefore can not be set to 0.
RecordsetClone is the group of records in your subform. In an earlier post
you had:
=IIf([Projects Subform].Form.RecordsetClone.RecordCount=0,0,[Projects
Subform].Form![TotalHoursWorked])
Did you delete or leave out RecordCount when you made the changes?

Steve
PC Datasheet

Hi Steve!

Ok, here's what I did, and I still can't get it to work:

=IIf([Forms]![Projects]![Projects
Subform].[Form].[RecordsetClone]=0,0,[Forms]![Projects]![Projects
Subform].[Form]![TotalHoursWorked])

I refuse to give up!!! What am I doing wrong?

It still doesn't appear you have it all!! Is Projects Subform the name of
the subform control on the main form? If so, that part is good. You now need
to add the name of the main form after "Forms". Look at the general syntax I
gave you in my previous response. The syntax is:
Forms!NameOfMainForm!...............

Steve
PC Datasheet

I tried this:
=IIf([Forms]![Projects
Subform]![TotalHoursWorked].[Form].[RecordsetClone]=0,0,[Forms]![Projects
Subform]![TotalHoursWorked].[Form]![TotalHoursWorked])

and got the same message. Any ideas?

:

Ok, so at the risk of sounding like a moron, how should i change this:

=IIf([Projects Subform].[Form].[RecordsetClone].[RecordCount]=0,0,[Projects
Subform].[Form]![TotalHoursWorked])

to make it look like what you said needs to be done?


:

Your reference to the subform's recordsetclone and field on the subform seem
to be wrong. The general syntax is:
Forms!NameOfMainForm!NameOfSubformControl.Form.RecordsetClone
Forms!NameOfMainForm!NameOfSubformControl.Form!NameOfFieldOnSubform

To emphasize, you use the name of the subform control and not the

name
of

the subform form!!!!

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com




Hi PC Datasheet,

I'm brand new to access, and I didn't touch anything. These are the
formulas -- can you tell what's wrong?

=IIf([Projects Subform].Form.RecordsetClone.RecordCount=0,0,[Projects

Subform].Form![TotalHoursWorked])

=IIf([Projects

Subform].Form.RecordsetClone.RecordCount=0,0,[Projects
Subform].Form![Total Billed])

=IIf([Project Expenses
Subform].Form.RecordsetClone.RecordCount=0,0,[Project
Expenses Subform].Form![Total Expenses])

=[Total Hourly Billings]+[Total Expenses]

=IIf(IsNull([ProjectID]),0,DSum("[PaymentAmount]","Payments","[ProjectID]="

& [ProjectID]))






:

#Name appears because a reference to a field in the formulas

is
either

misspelled or does not exist. Look at the formulas. Did you

change
the

name
of a field or delete the field? Since #Name appears three

times,
it

would
seem that the problem in all three formulas is the same field. #Error is
occurring because of the first problem. Fix it and #Error will

go
away.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


Hi, I downloaded the "Time and Billing" database for access

from
the

"templates" section of your website yesterday. The link is:
http://office.microsoft.com/en-us/templates/TC010184611033.aspx.

I have office 2003 and Windows XP. Everything works fine

until
I

click on
"Projects." When I click on "Projects," instead of seeing numbers in
the
fields for "Total Hours," "Hourly Billings" and "Total Expenses;" the
word
"#Name?" appears in each field. Also, the word "#Error"

appears
in

the
"Total Billing" and "Amount Due" fields.

I know the program is adding up all of my hours because the reports
print
correctly. Any idea how I can fix the error messages?

Please, please, please help!

Best,
Susanna

 

[Joan Wild]

Hi Albert,

Thanks so much for your suggestions -- unfortunately, neither of them
worked :-( Maybe it's something with my computer? Do you have any
other ideas?

It's an issue with macro security. RecordsetClone is a blocked expression.
For more information and the workaround, see

http://groups-beta.google.com/group/microsoft.public.access/msg/9c97a482f446a678

 

[Albert D. Kallal]

Now, while looking at the application, hit ctrl-g, and then go

debug-Compile
"Time and Billing"

Do you get any errors?

did you try the above?

 

[MS Shane]

I too am trying to find a solution for this exact scenario. I have already
tried the macros on low security and have gotten the same results: 0's and no
projects associated with the invoice. This is better than the #erro messages
in the fields, but not right.

I still haven't tried the solution mentioned by Russell (while looking at
the application, hit ctrl-g, and then go debug-Compile "Time and Billing")
and will try that next, but just wanted to let you all know that I am also
running Access2003 and make no changes to the db as downloaded from MS, I
have all latest security patches running and no other complaints about my
machines config. In fact, I have tried this on several machines and it is
the same results.

So I will try a few more things and hope that it works, but if anyone has
any more suggestions, please feel free to bring them to our attention.

thanks

 

[Joan Wild]

See

http://groups-beta.google.com/group/microsoft.public.access/msg/9c97a482f446a678

 

[KHAN SUL-O]

It looks like the discussion ended without a solution. Did anyone ever figure
it out, or is it just a crappy template?