Question about Microsoft Office Standard for PC

1 Answer

Linking Calculated Totals from subforms to the main form.

I have a hard problem linking the above subject. The main forms as Customers with sub-forms of CustomersOrder & CustomersPayment. I have created 3 txt boxes to accomodated; TotalPayment, TotalOrders & Current Balance with the ff: property control source of the ff: TextBox Name: txtTotalPayments Control Source: =Nz([sbfPayments].[Form]![txtPayments]) Format: Currency TextBox Name: txtTotalOrders Control Source: =Nz([sbfCustOrders].[Form]![txtItemsTotal]) Format: Currency TextBox Name: txtCurrentBalance Control Source: =Nz([sbfCustOrders].[Form]![txtItemsTotal]) - Nz([sbfPayments].[Form]![txtPayments]) Format: Currency And the return value is "#Name?" Please help me figure it out? Thanks. Raul L. Cadosales [email protected]

Posted by on

Ad

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Guru:

    An expert who has written 7 tips or uploaded 3 video tips

    Mentor:

    An expert who has written 3 tips or uploaded 2 video tips.

  • Expert
  • 58 Answers

Hi Raul from your description it is very unclear what you are trying to do. First we need to know what information is on the first form, second unless you are trying to do a subtotal of all orders in the subform there is no real need for you to create a subform. Now if you are trying to create a subtotal form for all records, you will have to set it up in the record source of that subform with group by: 1. Right click on an empty space on the subform 2. Click on properties 3. Choose your table(or query) which is the record source of the main form. 4. Select Payment and items(or what ever you are trying to calculate). 5. Press the group by button 6. In totals instead of group by choose sum. 7. Exit and save 8. Now when you will select the control source you will see "sumofpayment" etc... just select them for each textbox. 9. To create the third text box you will have to use the Expression builder and just do [textbox1]-[textbox2] * for some reason the nz function does not work in this case. I hope that helped you I will be able to give you a better answer if you give me more details... Let me know what happend Good luck Daniel

Posted on Sep 06, 2007

Ad

1 Suggested Answer

Anonymous

SOURCE:

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Error code 8002314A


Ok, it sounds like you are trying to create a sub-account. You must first create a main account, and make sure the address and all fields are correct, before it will allow you to create and use the sub-accounts. Then log into PSN via computer to ensure that everything was entered correctly. Then just sign in normally on the Playstation.

Apr 05, 2013 | Sony Playstation 3 (PS3) Console

1 Answer

Sir I have 4200 series 26 ports Switch i want to Configure intra VLAN But I am Getting a problem to Configure that switch . After Cnfigure VLAN on Consol prompt. I am not accessing to my Server & WAN...


Hi,
If you are creating only Layer 2 VLANs on the switch , you wont be able to ping the servers and Routers as they are in default VLAN1.
you can do the below steps
1. Create sub interfaces on the router LAN interface
2. Provide a new ip range to the new sub interface
3. Make the switch port connecting router as trunk, so that it will carry both the VLAN info
4. on your Labtop/PC give the IP address in the newly defined range
5. Make your switch port to be in the new VLAN

This will work , if you wont be able to configure the above settings, let me know i will give you the detailed config

Nov 01, 2010 | 3Com 4500 24-Port Ethernet Switch

1 Answer

Want to populate a form with data from a table, the Id number is keyed into the form and once it's matches with the Id in the table I want the other fields on the form to be populated with the data from...


Create a Form from the main table with a subform based on the other data you will want populated. You put the fields in the subform that you want populated from the main form. Go to the properties for the subform and select the data tab, In the data tab, select the Link Master Fields and choose the field you want linked. When you type the ID number in the main form, the other firlds you have in hte subform should populate from the data inthe table.

May 14, 2009 | Microsoft Access 2003 for PC

4 Answers

Bottom 3/4 of photos are black


Check out this website http://www.lotek.nu/misc/EOS_300D_sub-mirror_repair/

I had the same problem. You can check to make for sure by removing your lens, and carefully lifting your mirror. Does the sub mirror underneath flatten against the other one when you lift it? That's probably what is in the way creating your 3/4 "black" picture. I just repaired mine as in this website, and the mirror moves great now! Of course, I'm used to taking apart laptops and such. If you have a warranty yet, contact Canon. It is a defective issue on there part.

Mar 12, 2009 | Canon Digital Rebel / EOS-300D Digital...

3 Answers

MagicSing EG-18000 TV picture


i believed the problem is the TV mode. (NTSC or PAL mode)

try this
turn mic OFF
press and hold 8 then press power buton (PAL to NTSC)
or
turn mic OFF
press ang hold 9 then press power button (PAL to NTSC)

[email protected]

Sep 05, 2008 | Magic Sing Along Consumer Microphone

1 Answer

Macro


Hi alwinkumar

You can set a default value in most form items under the properties of that item. Look for "value". You can also do this in code, by setting up a sub routine to set/reset the values on your form. Then just run the sub routine before you open or enter the form.

Private Sub resetForm()

'formname.itemname = value
UserForm1.Label1 = "Hello World"

End Sub

For the second one you have a couple of options, you can find the bottom on the data and store the row index in a variable, use a loop to find the next empty cell in a row, and store the value or you can use the current region method to select all the cells with data continously touching the selected range. Example below

numberOfRows = Sheet1.Range("A1").CurrentRegion.Rows.Count

Jul 16, 2008 | Microsoft Office Professional 2007 Full...

1 Answer

Access 2003 HELP PLEASE!


Sharon King:

Did you get this problem solved? I realize it is quite old, but I am willing to help if it is not solved. If it is, I would be interested to know what happened...

smartsolve

Feb 18, 2008 | Microsoft Office Access 2003 (077-02871)...

1 Answer

View Reports


Hi, There a couple of different way you could do this and I have put two lots of VB code below that you can modify and use. Firstly you create the Combobox list by choosing the option that you will type the values yourself, you then type in all your report names on each line. After that you can then go to the VB code editor and paste my code in and modify it by changing my report names, (Customers) etc to your report names. Make sure you choose the Combobox and the On_Click option in the VB editor to paste the code into.  I like the first method better which checks the value of the Combobox and then opens the corrosponding report in the maximised form. The second method does the value check before running an assigned macro to open each report. With this you must first assign macros to each report in Access.  Remember each of these bits of code must be placed between the "Private Sub" heading and the "End Sub" ending, and change the "Combo23" name to reflect your combobox too. If you need a hand just email me.

First Method
 
If Combo23.Value = "Customers" Then
    DoCmd.OpenReport "Customers", acViewPreview, acWindowNormal
    DoCmd.Maximize
   
ElseIf Combo23.Value = "Customers 1" Then
    DoCmd.OpenReport "Customers1", acViewPreview, acWindowNormal
    DoCmd.Maximize
   
ElseIf Combo23.Value = "Customers 2" Then
    DoCmd.OpenReport "Customers2", acViewPreview, acWindowNormal
    DoCmd.Maximize
   
End If

Second Method
 
If Combo23.Value = "Customers" Then
   DoCmd.RunMacro "Macro1"
   DoCmd.Maximize
ElseIf Combo23.Value = "Customers 1" Then
    DoCmd.RunMacro "Macro2"
    DoCmd.Maximize
ElseIf Combo23.Value = "Customers 2" Then
    DoCmd.RunMacro "Macro3"
    DoCmd.Maximize
End If

Oct 28, 2007 | Computers & Internet

1 Answer

Restict closing the main form when some controls on the subform are empty


Hi there. I didn't notice this was so old until I had already worked on it for some time. Did you get this the way you want it? If not, I suggest either using a BeforeUpdate control to ensure the condition is met that the subform contain data, or validate the particular field(s) with isnull. Thanks for posting back if you still need help, or otherwise rating FixYa!

Oct 03, 2007 | Microsoft Office Standard for PC

1 Answer

How to activate command buttons II


Hi Lensa, The code is fine there should not be any problem with it. Do not change anything on it. In my opinion the buttons and code has nothing to do with it since they are done automatically and usually work fine. When you press the add new button you are not just creating a new record you are also updating the last record. This button just send you to a new empty record for you to fill. From my experience the error message is due to 3 major reasons: 1. Your record source for this form is a query that cannot be updated 2. You don't have writing permissions to the database. Check and see if the file is locked or its on read only, Check security options and see if the database is read only etc. 3. Your records are locked by the table setting for some reasons, primary key fields might create duplicates. If its just a table try updating the table without a form and see what happens. As I wrote above the problem is with the record source or the database and since I can't see what you have there I can't help you further. I would also suggest you should practice with a simple table first before going into advance queries. Create a table with some simple fields like: ID - Primary key - Auto Number First name - Text Last name - Text Then create a form of that table and start filling in the names and test all the buttons, that will give you an idea of each button and I am sure it will be easier. Good luck Daniel

Aug 16, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

105 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Ekse

Level 3 Expert

13434 Answers

ThaMp3Doctor
ThaMp3Doctor

Level 3 Expert

8597 Answers

Scoee Scoffer

Level 2 Expert

162 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...