simple form calculation won't calculate

I am using a simple addition calculation in Access 2007 and it will not show 
the result. Simple form based on a single table field 1 and field 2 with a 
following unbound field with the control =[filed 1] + [field 2] after 
tabbing through field 1 (all formatted as currency) then field 2 and tab 
into the following unbound field and no value shows until I press F5 and 
return to the record with the unbound field and then the tabulation 
calculation appears. I am clueless why this shouldn't calculate the result 
as I enter into the unbound field. Any ideas appreciated

-- 
***************************
Mark M Simonian, MD
681 Medical center Dr West #106
Clovis, CA 93611
(559) 325-6850
www.markmsimonian.medem.com
msimonian@aap.net 

0
Mark
8/15/2007 5:11:49 AM
access.forms 6864 articles. 2 followers. Follow

4 Replies
815 Views

Similar Articles

[PageSpeed] 0

Dear Klatuu, Thanks so much for the suggestion and apologize for not using 
the proper naming terminology. In order to see the total I still must press 
F5 to refresh and click into a combobox to reselect the appropriate record. 
Changing the formula did not help show the results immediately as I would 
hope. It is not a lot of trouble but thought it should show the value 
immediately upon entering the unbound control. Am I wrong? Mark Simonian


"Klatuu" <Klatuu@discussions.microsoft.com> wrote in message 
news:43114041-690D-410A-9487-D9210772039B@microsoft.com...
>A couple of minor points.  Regardless of Microsoft's misinformation, forms 
>do
> not have fields, they have controls.  Tables and Querys have fields. 
> Second,
> it is not a good idea to use spaces in names.
> Now, It is most likely the calculation is taking place and presenting the
> result, but the result is Null so therefore is not visible.  Null + 
> anything
> = Null.
> I would suggest you enclose each value in the Nz function.  The Nz 
> function
> will convert a Null to the specified return argument, but return non null
> values.
> Try:
> =Nz([filed 1],0) + Nz([field 2],0)
> -- 
> Dave Hargis, Microsoft Access MVP
>
>
> "Mark M Simonian" wrote:
>
>> I am using a simple addition calculation in Access 2007 and it will not 
>> show
>> the result. Simple form based on a single table field 1 and field 2 with 
>> a
>> following unbound field with the control =[filed 1] + [field 2] after
>> tabbing through field 1 (all formatted as currency) then field 2 and tab
>> into the following unbound field and no value shows until I press F5 and
>> return to the record with the unbound field and then the tabulation
>> calculation appears. I am clueless why this shouldn't calculate the 
>> result
>> as I enter into the unbound field. Any ideas appreciated
>>
>> -- 
>> ***************************
>> Mark M Simonian, MD
>> 681 Medical center Dr West #106
>> Clovis, CA 93611
>> (559) 325-6850
>> www.markmsimonian.medem.com
>> msimonian@aap.net
>>
>> 

0
Mark
8/15/2007 5:50:43 PM
Is the calculation in the unbound control's Control Source Property?
If not, that might account for your problem.
No apology necessary, only trying to help.  I guess I am terminologically 
obsessive.  As you know, in your profession incorrect terminology can have 
undesired consequences :)

BTW, I would not recommend posting that much personal information on this 
site.  It is trolled frequently and you may get spam from it.
-- 
Dave Hargis, Microsoft Access MVP


"Mark S" wrote:

> Dear Klatuu, Thanks so much for the suggestion and apologize for not using 
> the proper naming terminology. In order to see the total I still must press 
> F5 to refresh and click into a combobox to reselect the appropriate record. 
> Changing the formula did not help show the results immediately as I would 
> hope. It is not a lot of trouble but thought it should show the value 
> immediately upon entering the unbound control. Am I wrong? Mark Simonian
> 
> 
> "Klatuu" <Klatuu@discussions.microsoft.com> wrote in message 
> news:43114041-690D-410A-9487-D9210772039B@microsoft.com...
> >A couple of minor points.  Regardless of Microsoft's misinformation, forms 
> >do
> > not have fields, they have controls.  Tables and Querys have fields. 
> > Second,
> > it is not a good idea to use spaces in names.
> > Now, It is most likely the calculation is taking place and presenting the
> > result, but the result is Null so therefore is not visible.  Null + 
> > anything
> > = Null.
> > I would suggest you enclose each value in the Nz function.  The Nz 
> > function
> > will convert a Null to the specified return argument, but return non null
> > values.
> > Try:
> > =Nz([filed 1],0) + Nz([field 2],0)
> > -- 
> > Dave Hargis, Microsoft Access MVP
> >
> >
> > "Mark M Simonian" wrote:
> >
> >> I am using a simple addition calculation in Access 2007 and it will not 
> >> show
> >> the result. Simple form based on a single table field 1 and field 2 with 
> >> a
> >> following unbound field with the control =[filed 1] + [field 2] after
> >> tabbing through field 1 (all formatted as currency) then field 2 and tab
> >> into the following unbound field and no value shows until I press F5 and
> >> return to the record with the unbound field and then the tabulation
> >> calculation appears. I am clueless why this shouldn't calculate the 
> >> result
> >> as I enter into the unbound field. Any ideas appreciated
> >>
> >> -- 
> >> ***************************
> >> Mark M Simonian, MD
> >> 681 Medical center Dr West #106
> >> Clovis, CA 93611
> >> (559) 325-6850
> >> www.markmsimonian.medem.com
> >> msimonian@aap.net
> >>
> >> 
> 
> 
0
Utf
8/15/2007 6:00:01 PM
He might get "PC Datasheeted" to death!

-- 
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via http://www.accessmonster.com

0
missinglinq
8/15/2007 6:13:00 PM
Yes, this was an unbound control. It makes no sense why this doesn't refresh 
and calculate but I solved it because I also have a subform on the same tab 
and decided to add a column in the datasheet on that subform that does the 
same calculation and it works fine. I am just very curious why it won't 
autocalculate and requre a forced refresh and return. The results count and 
I fixed it. I appreciate the advice.

I appreciate the advice on keeping my information more secure too and the 
Norton screening is working somewhat.

Mark Simonian


"Klatuu" <Klatuu@discussions.microsoft.com> wrote in message 
news:AEEC0E13-89E3-4185-9AC2-7F57544072C5@microsoft.com...
> Is the calculation in the unbound control's Control Source Property?
> If not, that might account for your problem.
> No apology necessary, only trying to help.  I guess I am terminologically
> obsessive.  As you know, in your profession incorrect terminology can have
> undesired consequences :)
>
> BTW, I would not recommend posting that much personal information on this
> site.  It is trolled frequently and you may get spam from it.
> -- 
> Dave Hargis, Microsoft Access MVP
>
>
> "Mark S" wrote:
>
>> Dear Klatuu, Thanks so much for the suggestion and apologize for not 
>> using
>> the proper naming terminology. In order to see the total I still must 
>> press
>> F5 to refresh and click into a combobox to reselect the appropriate 
>> record.
>> Changing the formula did not help show the results immediately as I would
>> hope. It is not a lot of trouble but thought it should show the value
>> immediately upon entering the unbound control. Am I wrong? Mark Simonian
>>
>>
>> "Klatuu" <Klatuu@discussions.microsoft.com> wrote in message
>> news:43114041-690D-410A-9487-D9210772039B@microsoft.com...
>> >A couple of minor points.  Regardless of Microsoft's misinformation, 
>> >forms
>> >do
>> > not have fields, they have controls.  Tables and Querys have fields.
>> > Second,
>> > it is not a good idea to use spaces in names.
>> > Now, It is most likely the calculation is taking place and presenting 
>> > the
>> > result, but the result is Null so therefore is not visible.  Null +
>> > anything
>> > = Null.
>> > I would suggest you enclose each value in the Nz function.  The Nz
>> > function
>> > will convert a Null to the specified return argument, but return non 
>> > null
>> > values.
>> > Try:
>> > =Nz([filed 1],0) + Nz([field 2],0)
>> > -- 
>> > Dave Hargis, Microsoft Access MVP
>> >
>> >
>> > "Mark M Simonian" wrote:
>> >
>> >> I am using a simple addition calculation in Access 2007 and it will 
>> >> not
>> >> show
>> >> the result. Simple form based on a single table field 1 and field 2 
>> >> with
>> >> a
>> >> following unbound field with the control =[filed 1] + [field 2] after
>> >> tabbing through field 1 (all formatted as currency) then field 2 and 
>> >> tab
>> >> into the following unbound field and no value shows until I press F5 
>> >> and
>> >> return to the record with the unbound field and then the tabulation
>> >> calculation appears. I am clueless why this shouldn't calculate the
>> >> result
>> >> as I enter into the unbound field. Any ideas appreciated
>> >>
>> >> -- 
>> >> ***************************
>> >> Mark M Simonian, MD
>> >> 681 Medical center Dr West #106
>> >> Clovis, CA 93611
>> >> (559) 325-6850
>> >> www.markmsimonian.medem.com
>> >> msimonian@aap.net
>> >>
>> >>
>>
>> 

0
Mark
8/17/2007 9:06:47 PM
Reply:

Similar Artilces:

Custom Forms - Outlook 2003
Hi, Some time ago I upgrade to Office 2003 Pro. All was working fine up until a few days ago. I don't remeber installing anything recently. Now when I try and create a new task based on a custom form it says the following "The messaging interface returned an unknown error. If the problem persists restart Outlook". Needless to say I have restarted many times. Upon further investigation it would appear that all of my custom forms are not working. I read about the Cache problem in KB article http://support.microsoft.com/default.aspx?scid=kb;EN-US;195754 but that did not wo...

Vendor Email to POP Other Form
Can anyone give me directions on how to add the vendor's email address (from the vendor internet information window) to the Purchase Order Other Form? Thanks, Jocelyn Jocelyn, The vendor e-mail address is stored in SY01200 (Internet addresses). In that case, it might not be possible to bring that on to the PO form. Try adding the e-mail address in vendor maintenance Options window, user defined field so that you can place the same in the PO modified report. -- Thanks Janakiram M.P. MCP-GP Note: If you are a Microsoft Partner, You can also Login to Dynamics GP partner forums at ...

Using like and Or in VB form.filter statement.
This works: Forms![Master Search].Form.Filter = "[GTPO] = Forms![Master Search]! Text63" FilterOn = True This doesn't work: (data type mismatch ERROR) Forms![Master Search].Form.Filter = "[GTPO] = Forms![Master Search]! Text63" Or "[Project Name] Like '*" & Forms![Master Search]!Text64 & "*'" FilterOn = True The Or needs to be inside the quotes: Forms![Master Search].Form.Filter = _ "[GTPO] = Forms![Master Search]!Text63 Or " & _ "[Project Name] Like '*" & Forms![Master Search]!Text64 &"...

Defining formats (i.e. bold, underline) for fields in forms/report
I need to define formats (i.e. bold, underline) for reference table fields. For example, let’s say reference table A contains three fields: Field1, Field2, Field3 and two rows. Reference Table A ID _Num Field1 Field2 Field3 1 Single Double Triple 2 Single Double Quadruple Forms need to know that for row 1 Double will be in bold and Triple will be underlined. However, for row 2, only Quadruple need to display in bold on forms, reports, etc. On Fri, 23 Apr 2010 06:33:02 -0700, NewToAccess <NewToAccess@discussions.microsoft.com> wrote: >I need to define formats...

Queries and Forms
Hello I have a RiskDB with 1 form. I have 4 differnt people who have access to this form and enter relevant data. I have used enable to allow them access to the fields they can enter data into. The author creates a new Risk on the Form. I then want the action owner to access that Risk and enter his data. I am trying to use 1 form only when the action owner clicks there button i would like the form to open and ask the question which ID number would they like to view. I have a query that asks the question and provides the answer just not in form layout. My aim is to have no more then the o...

Record-specific calculated text box
I have a text box in the detail section of a form, whose control source is a hidden combo-box that queries a table not included in the form's record source. It queries that table using the primary key from the form's record set which is linked to that table. Requerying cboHidden requeries ALL instances of cboHidden, and then the text box for ALL records updates to an identical value, I assume because cboHidden refers to every instance of it on the form, not just the one specific to that record. How do I change the behavior such that these behave locally to that record? Thanks,...

Create a button in a form to email a report
I have a form set up in my DB that we fill out. I do have a button that will print the report for this form set up, but now we would also like to have the option to press a button and the report attaches itself to an email and we can send it. I could set it up to just go to print preview and then we have to go to the Acrobat tab, and select the "create and attach to email" but I was hoping I could by-pass this step through code somehow. If anyone has any ideas let me know! As a guess (pass in reportname and whereclause), or perhaps you need to save the pdf to disk a...

How to run proceedure when clicking Cmd Btn on form ??
I just added a Command Button to a Form. I wanted the user to be able to click the button to run a proceedure. The proceedure will... - copy text from one field_x on the form - add it to the text in field_y on the form (concatenate) - clear field_x We call the button "Update" We can do this by creating an "event proceedure" for the form... like run the proceedure when they go to the next form or whatever... but wanted an actual button they would click. I can't see anything in the Command Button options that says "run proceedure" or whatever... There is ...

video object on form autoplaying on form load
I want to have an easter egg on my system, where a form loads that has a video embedded to it on a autorepeat loop, that auto plays on the form load. I don't want the video to open in an external program, but on the form itself (like you can embed a html document). I have searched on this forum, and tried many suggestions, but to no luck. nb: the file is a .mpg -- Message posted via http://www.accessmonster.com ...

Form disappeared from forms list in Access 2002
Hi all! I have some weird problem. I have some form that appears as a login screen from function by using autoexec macro. The problem is that this form does not appear in the list of all forms in the Access itself. When I open the application the form appears and I can use it but there is no way to find it in the list of all forms to enter the design. The only way to enter the design is run the app and than right click the header of the form and choose design view. The problem is that now I want to import this form to another file. When I choose the Forms tab from the "Import objects&quo...

Form Layout
Hi there. My name is Joe and I'm starting to used Access. I have currently got a form that displays 55 records. I need to fit all these on a singe page for printing. currently the data only takes up half the page horizontally so i was wondering if it is possible to have them list down one side of the page and then continue down the other side. eg. aaa bbb ccc ddd | aaa bbb ccc ddd At the moment i can only get it to list the same thing twice. any ideas. thank you Joe Joe Access forms are intended for screen display. If you want to print data from an Access database, take a look a...

form creation
Hi I have a 10 column database, I want to create a data entry form (via macro command button if possible) but do not want to select every column. cna specific columns be selected for the form and if so how ? -- thanks Roy Hi, check Debra web have an excellent explanation and example http://contextures.com/xlUserForm01.html if this helps please click yes thanks "Roy Gudgeon" wrote: > Hi > > I have a 10 column database, I want to create a data entry form (via macro > command button if possible) but do not want to select every column. cna &g...

Saving a Customized Form Times Out
When we try to customize a form and save it, it hangs for awhile, then we get a "this page can not be displayed" error. However, it appears that the customizations made to the form still get saved. It only happens when we try to save changes to a form. Has anyone had this problem before? Any information will be extremely appreciated! Thanks, Dusty ...

Loan Calculator A Must Look!!!
Excellent resource on Loan calculation: http://cash-experts.com/LC.asp ...

Dialog Form Question
Hi I want to automatically create a member in the linked class for each control that I put on the Dialog Resource Is that possible and how? Thank you No way to do this automatically, but you can do it control by control by right clicking and selecting Add Variable or Add Event Handler. I mostly use cut and paste these days and just add them manually. It doesn't take much time if you use one for a template then just copy it. Tom "S Shulman" <smshulman@hotmail.com> wrote in message news:OSFxkPv2FHA.636@TK2MSFTNGP10.phx.gbl... > Hi > > I want to automa...

creation of a form
How do you... create a form in which the formatting of text remains when completing the form? -- Debra Woolley Gifted Education Specialist See if this article applies: Incorrect font is applied after a style is applied to a form field in Word 2007 or in Word 2003 http://support.microsoft.com/kb/828501/en-us -- Stefan Blom Microsoft Word MVP "Debra" <Debra@discussions.microsoft.com> wrote in message news:E2BD1251-F3A1-4B41-9C99-3719A5A239DC@microsoft.com... > How do you... create a form in which the formatting of text remains when > completing ...

Need help writing a workable formula in form design......
Im running vista, microsoft office pro 2007 I'm trying to write a workable formula in an unbound text in form design. It's a monster formula. Their are 4 components: comp/att*100-30/20 yds/att-3*.25 td/att*20 2.375-int/att*25 Each one of the answers for these 4 components must be checked , if greater than 2.375 then set to 2.375 and if less than 0 then set to 0 and finally, all added together, multiplied by 100 and divided by 6 This is what I have but I get Syntax Error. I'm very new to access, so please keep this in mind, thank you. =PasserRating:([comp]/[Att]*100-30/20+...

Outlook 2002 simple backup question
I am a single (home office) Outlook 2002 user on Windows XP Home Edition. I want to be sure I'm backing up EVERYTHING I should be and have followed the procedure outlined in the Microsoft document for backing up pst files. It also says a Personal Address Book is stored on the hard drive and you "may" have to backup that as well. Searching my hard drive for anythting with a pab extension yeilds only a gif and a shortcut/pointer. Question: am I saving everything I need (all contacts, including all email addresses, inbox, sent, drafts, calander, tasks, etc. folders) by simply backi...

Can't Send Yahoo Email Form Outlook 2002
I am using Outlook 2002 and Windows XP Pro and can't get the account setup properly to allow sending from Outlook. Receiving works fine but no matter how I set things up, sending will not work. I have tried a few of the KB articles but none seem to get me up and going. Thanks -res- http://search2.cc.scd.yahoo.com/cct_search.php?brand=yahoo&ui_mode=answer&prior_transaction_id=1061256804&action_code=5&answer_id=156988#__highlight The above is the help from Yahoo! Cut and paste the entire URL into the browser window. --� Milly Staples [MVP - Outlook] Post all re...

Calculations slowing forms down
Good morning! We have recently switched our back end to SQL server and since then any of our search forms with calculations have slowed right down. I would like to remove any calcuations when the form opens and add a command button that does the calculations once the user has selected all of his criteria. Following is the function used for the search forms. Start of code: ************************************************************ Function FormFilterForm(strForm As String, strSubForm As String, strTag As String, strTbl As String, strSortOrder As String, tfClear As Boolea...

Date form field in Word
I've created a form using the drop-down date field. However, after saving and restricting editing on the document, the form works when tabbing TO the date field but after selecting a date, the "form" will not tab to the next field, which happens to be a fill-in field: it will only tab to the next date field. HELP! If the date fields are Date Picker content controls, what you are seeing is to be expected. You cannot Tab from a content control to a field in Word. -- Stefan Blom Microsoft Word MVP "April" <April@discussions.microsoft.com> wrote...

Copy 2 fields from subform into new form
Hi, Really do not understand VBA. I want to copy the ID fields in a subform and paste them into a new form via a command button. Many thanks in advance Charlotte On Sat, 27 Feb 2010 16:22:01 -0800, Charlie <Charlie@discussions.microsoft.com> wrote: >Hi, > >Really do not understand VBA. I want to copy the ID fields in a subform and >paste them into a new form via a command button. > >Many thanks in advance > >Charlotte You'll have to give us a bit more context, I'm afraid! Are you working on the *design* of a form? or copyin...

Transfer Lists to Forms
Good afternoon all, I'm currently working on transcribing a list of files we have archive into an Excel spreadsheet. Before anybody asks I'm not using Acces (which would be my first choice) because I'm the only one with i installed in our group. What I have is this. A large list of file archived which contains (Column) A: Box / Barcode ID B: Name On File C: Destruction Date (Reference Only) D: Date Of Loss (Reference Only). This is the first sheet. On a second sheet, I have made an exact duplicate of the faxes I woul send off to the storage company if I need a file retrieved....

Resizing of form view
Hi, I have a form view with many controls. When i resize my form view i.e change the size by moving it, my controls on form view also should get adjusted in size accordingly. Can anyone please help me to achive this? Thanks Madhavi "madhavi" <jmadhavi@yahoo.com> wrote in message news:d24fff25.0409302242.39ffab72@posting.google.com... > Hi, > > I have a form view with many controls. When i resize my form view i.e > change the size by moving it, my controls on form view also should get > adjusted in size accordingly. Can anyone please help me to achive > this...

Data Entry Form questions
I have a database with several sheets divided up based on the customers Id#, all the Id# shhets are laid out the same way. The Excel Data Form displays all the columns headings like it should. What I am trying to do is create a data entry form that will place the information on a particular sheet depending on the customer Id# (example: customer Id# is 143 the information would go to sheet1, customer Id# 281 go to sheet2, customer Id# 313 go to sheet3, and so on). Also in some of the columns I have a vlookup formula that looks up the customer Id# on the appointment sheet an...