I have an interesting question regarding my database (Form) on access 2007

johnherrerajuan

Registered User.
Local time
Today, 10:42
Joined
Feb 25, 2013
Messages
44
I created an estimate database, I have a form that is used for data entry purposes it was working fine until i crated a duplicate that is arranged diffidently for printing purposes. Before i would just enter the data and it will perform alot of calculations and shoot a grand total now all it does is execute the word #Name? until i enter design view and move one of the #Name? boxes around

*** The sevens are random numbers I have entered
 

Attachments

  • Picture1.jpg
    Picture1.jpg
    80.9 KB · Views: 89
Last edited:
You probably have an expression that is referring to a control that has the wrong name. How did you create the duplicate form? What do the expressions for those controls look like?
 
I just right clicked on the form on the navigation pane copied and past it then renamed it as Estimate(for reporting purpose) and another one for budgeting purposes the original form has the word #Name? the copies have the word error!
 
I just right clicked on the form on the navigation pane copied and past it then renamed it as Estimate(for reporting purpose) and another one for budgeting purposes the original form has the word #Name? the copies have the word error!

Okay, let's ask this question again - What do the expressions for those controls look like?

So, in other words, if you go to the control source for the controls and you see

=SomeExpressionIsSetHere

What is set there?

Is it an expression (if so post the exact expression) and if it is a field name, does the form have that field in its record source?
 
The boxes on the form are unbounded boxes with control =[box1]+ [box2]+......
or else it would be an if statement for overtime and markups. it all worked correctly before

=IIf([MarkUp]=100,+[Building Service Engineer]*1.15+[Building Service Engineer],IIf([MarkUp]=101,+[Building Service Engineer]*1.15+[Building Service Engineer],IIf([MarkUp]=200,+[Building Service Engineer]*1.5+[Building Service Engineer],IIf([MarkUp]=201,+[Building Service Engineer]*1.5+[Building Service

=([QTY1]*[UnitPrice1])*getResult([MarkUp],[Stock/NonStock1])+[QTY1]*[UnitPrice1]

=[Text787]+[Text788]+[Text789]+[Text790]+[Text791]+[Text792]+[Text793]+[Text794]+[Text795]+[Text796]+[Text797]+[Text798]+[Text799]+[Text800]+[Text801]+[Text802]+[Text803]+[Text804]+[Text805]+[Text806]+[Text807]+[Text808]+[Text809]+[Text810]


Those are some examples
 
I copied and paste the whole file then it worked fine i am not sure is this is a temporary solution but now it works fine... can anyone explain to me what went wrong
 

Users who are viewing this thread

Back
Top Bottom