Search results
-
N
Continuous Form Summing to text box from query results.
I'm going to have to go back and retype my initial post. Dsum isn't giving me Aggregate COGS at all. Dsum is only calculating the COGS per line displayed by the query. I have a textbox in the header of this form and I want to display an aggregate/sum of all cogs for that product manager... -
N
Continuous Form Summing to text box from query results.
I have a textbox in the header, I'm unable to make it display the SUM of COGS in the continuous form below. -
N
Continuous Form Summing to text box from query results.
I believe with Dsum originally I was getting ?Name# But when Summing I got it to display the sum of whatever value I clicked on, I guess that's progress, but not enough. -
N
Continuous Form Summing to text box from query results.
My mistake, that was the forumula I was originally using. I really don't know how to get it to sum to all fields showing from the query. -
N
Continuous Form Summing to text box from query results.
My db tracks supplier cost changes for our annual deadline. I use Dsum in text boxes to calculate the COGS * the % in/decrease. I have a textbox in the header that will give Total COGS. dsum doesn't work, I found that out and I don't know how to get sum to work. Current controlsource for... -
N
Use query to Filter Results from another query.
What about using a make-table query to compile the data that each PM should represent, then updating that information in the continuous form and later updating the preceding information accordingly. Does this sound like something that can be done? -
N
Use query to Filter Results from another query.
Elaborate on said linking please. -
N
Use query to Filter Results from another query.
Hrmm, lets see if I can explain this. I have a query that outputs to a continuous form. Because of how this query is made I'm unable to edit the data on the continuous form. I will have to make an "update form" and wanted to know if there was a way to view the table that needs to be updated... -
N
Combobox value transfer to another frm text box.
I can but for one display I want to view a the people that fall under the director. -
N
Combobox value transfer to another frm text box.
To test it out and go to it quickly. but once the form is visible with the data I have buttons that I want to switch between the "items" and their "parts". So I'll need to use a var to populate criteria for the division(items or parts) and then requery to show the values. Make sense? -
N
Combobox value transfer to another frm text box.
I figured out how to not have to use multiple queries by just changing the variables via buttons. I have an issue with that though. If I run the query without the form loading the value I get prompted and I cannot leave it blank or use * as a wildcard because it returns no results. Is there... -
N
Switch Control Sources via a button?
Well I may be using the same query and just change criteria in it via variables. I tried using * as a wildcard but it doesn't work. Currently in my query I have it referencing a combo box value. So if I open the form manually I have to type in the data. How can I use a wild card like this... -
N
Switch Control Sources via a button?
I have a form displaying cost increase data by supplier for our PM's. We send out templates to be filled out. I want to have 4 buttons total, maybe 5. Merchandise where templates have been sent Merchandise including suppliers where no template was sent Parts where templates have been sent... -
N
Combobox value transfer to another frm text box.
So I got all that figured out. I wanted to know, also. If I have multiple queries that will produce outputs to the same field names, can I use VBA to change the control source of the items? IE, I want to use the same form the display different query information when a button is clicked. I... -
N
Multiple Comboboxes with Query/ies
Right, but that's not a route. Should I have a bunch of separate queries, or is there a way for me to utilize one? Would it be smart to use 1 main query or multiple? -
N
Multiple Comboboxes with Query/ies
I have a main form with 3 Combo Boxes and Submit Button. Combos are: Team Product Manager Supplier Current setup: User chooses Team Requery done to qryPM User chooses PM requery done to qrySupp User clicks submit All information under chosen PM is displayed. The value of the cboPM is used... -
N
Combobox value transfer to another frm text box.
Wow, that makes me feel really stupid. I really don't remember much from Programming a couple years back. But also, I'm not thinking of solutions as being so simple. -
N
Combobox value transfer to another frm text box.
I figured out the reason for the error. I was trying to sum directly from the qry instead of using an item on the field list in expression builder. I noticed something that bothers me. When you have a cell and it's formatted. When click it shows it's actual value (ie $1,004 can have an... -
N
Combobox value transfer to another frm text box.
When I get to work I'll post the formula that I have. I think I know what to try when I get there tomorrow. -
N
Combobox value transfer to another frm text box.
When doing so it spits out "#error". Also, I want to edit data that's showing up in the continuous form. Will I need to make a subform and view as data sheet to enable this? Please let me know if I need to clarify. -Nic