I'm trying to create a database to keep track of donations. I have 2 tables. One that has all the person information plus the Amt. pledge, Amt. Paid, and Amt. Remaining. The other table had Date and Pledge Amt. Paid.
What I'm trying to do is get the sum from Pledge Amt. Paid in table 2, to populate the Amt. Paid field in table 1.
I've tried using the expresson builder under the Amt. Paid field, I've done =Sum(Table2
gedwards
Last Activity: Mar 20 '08, 06:09 PM
Joined: Nov 27 '06
Location:
-
Getting the Sum of a field to populate another field
-
If its not to much trouble maybe you could take a look at my database? I would rather you not make any changes, as I would rather do it myself but maybe you could see if i have everything where it should be.
HERE -
Tried them both and nothing, just more errors when i try to run it. And yes the Subform name is PTO.
This just seems to have me stumped. Just a few more things I want to be sure of:
If I have the command button with the on-click event, I do not need anything for code on the combo boxes right? And nothing other then the query for the sql code for the subform correct?
Also not sure if this would maybe make...Leave a comment:
-
I knew there was something I wasn't doing correctly. Its not giving an error, whoever, when I select fromt the 2 combo boxes, and hit the command button, nothing populates.Leave a comment:
-
I don't get any drop down list. The (Me.PTO.Requery ) is a macro right? I don't have any macro's, should they be built into access?Leave a comment:
-
The command button is added to the main form correct? If so thats what I did.
Then after adding the button, and putting in Me.PTO.Requery in the On-Click field. But when i go to view the form, I get the error.Leave a comment:
-
I get an invalid syntax error when I try to go to view mode, instead of design mode.
BTW just in case I haven't said it before, I really want to thank you all for this help, I appreciate it soooo much.Leave a comment:
-
I'm still getting an error.
Heres a little update on everything.
I have three tables (tbLocation, tbDate, tbTime-Off), I have 1 form (frmLocation), 1 Subform (PTO),
2 Combo boxes, (Combo1, Combo2)
I changed some names etc. just so I dont get confused and put the wrong thing in the wrong place....Leave a comment:
-
Here is a screenshot of my form.
If I try to open the Sub-form on its own this is what pops up, for basically asking for values for each combo box. I think it has something to do with the sub-form sql not being right, but not sure
This is a screenshot of my sql code for the subform to populate based on the selections of the combo boxes.
...Leave a comment:
-
The record source is on the subform. I opened the subform on its own, and went to the properties for the form-->Record Souce-->SQL View
I think thats what your asking right?Leave a comment:
-
*Edit*
A little bit more information as well, my form is named Location, the subform is Time-Off.
That is what my SQL looks like on the subform Record Source....Leave a comment:
-
I have just 2 more final questions.
First one is on,
[Forms]![FormName]![Combobox]
What does the [Forms] part of the line represent? I know FormName would be the name of the form the combo box is located on, but not sure what that would be or if its changed?
I tried adding a command button with an On-Click of:
Me.SubformName. Requery but that just give me a Access error....Leave a comment:
-
Excellent that is kinda what I thought I should do. One more question however, where may I find the record source for the subform. I know where to find the Row source for the combo box, but the record source is not there for the Sub-form.
Thank-you again, you have been a great help. I really wish now I would have learned some Access instead of just Oracle.Leave a comment:
-
I think I may have over explained myself, or maybe I'm just not quite understanding you right.
My form looks something like this
XXxxXX <-- Combo Box (Location)
XXxxXX <--- Combo Box (Date)
XXxxxXX <---- Subform/Subreport ( Time-off) (Should show the employee name etc. from this table)
Each Combo Box is populated from a table. And the subform...Leave a comment:
-
Also
I have 3 tables Date(has each date for the week), Time-Off(date/employee name/general/location for time off), Location(site location). Date, and location are combo boxes as well.Leave a comment:
-
Using 2 Combo boxes to populate a Subform
First off, I am a complete newbie to Access. I've used it maybe a half dozen times, all my database knowledge is with Oracle.
I'm building a database/form in Access 2003. I'm trying to get it so that I can select a Location from one combo box, and a date from another combo box, and have a Subform populate with the correct data for each date/location selected. I'm not really sure how to go about this, but I've been reading maybe using...
No activity results to display
Leave a comment: