"Time and Billing" database question -- access

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/te...184611033.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

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?


"SBC_2005" wrote in message
...
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/te...184611033.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

#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

www.pcdatasheet.com


"SBC_2005" wrote in message
...
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/te...184611033.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

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]))






"PC Datasheet" wrote:

#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

www.pcdatasheet.com


"SBC_2005" wrote in message
...
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/te...184611033.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

Hi Tina,

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

"tina" wrote:

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?


"SBC_2005" wrote in message
...
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/te...184611033.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

Hi Tina,

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

"tina" wrote:

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?


"SBC_2005" wrote in message
...
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/te...184611033.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

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

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

www.pcdatasheet.com




"SBC_2005" wrote in message
...
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]))






"PC Datasheet" wrote:

#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

www.pcdatasheet.com


"SBC_2005" wrote in message
...
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/te...184611033.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

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?


"PC Datasheet" wrote:

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

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

www.pcdatasheet.com




"SBC_2005" wrote in message
...
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]))






"PC Datasheet" wrote:

#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

www.pcdatasheet.com


"SBC_2005" wrote in message
...
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/te...184611033.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

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?

"SBC_2005" wrote:

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?


"PC Datasheet" wrote:

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

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

www.pcdatasheet.com




"SBC_2005" wrote in message
...
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]))






"PC Datasheet" wrote:

#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

www.pcdatasheet.com


"SBC_2005" wrote in message
...
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/te...184611033.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

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


"SBC_2005" wrote in message
...
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?

"SBC_2005" wrote:

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?


"PC Datasheet" wrote:

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

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

www.pcdatasheet.com




"SBC_2005" wrote in message
...
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]))






"PC Datasheet" wrote:

#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

www.pcdatasheet.com


"SBC_2005" wrote in message
...
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/te...184611033.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