Search results

I have a query that returns records that occur during the current week. The criteria for this is: DatePart("ww", [ProductionDate]) = DatePart("ww", Date()) and Year( [ProductionDate]) = Year(Date()) In the query are several calculated fields: Waste: [LF Run]-[LF Produced] Waste%...

I've created a chart from a query and I'm wondering how to add a total in the chart of all the values represented? The chart is a bar chart, for example, and has 4 bars with the value of 25 each. I'd like to have a text box on the chart that shows the total of the bars added up is 100 in this...

Got it figured out.

Ok so now I'm really stumped. The error I keep getting is "Abacus can't find the object '1'." So I changed the last line of code to "DoCmd.OpenQuery "qryProductionNumbers", AcViewPivotTable so the specific form is named and it opens like I want it to. Why in this case do queries and reports...

I have created code to use the DoCmd to open reports nad queries in datasheet form. I have a query that opens in pivot table form. What DoCmd syntax would I use to open a query in PT form? Here is the code I've used with the DoCmd to open queries and reports. Cannot figure out how to get...

Here is something I'm still investigating. I have my reports and datasheet queries all setup to run from a combo box. Can pivot tables also be run? If so, is there something I have to do different from setting up reports and queries? The queries that were setup to run as pivot tables come out...

looks like I have it figured out. Found an example file. :p

Hello All; I have a form that has about 17 command buttons on it :eek: that run different macros. The macros run queries and or reports. The frontend has gotten somewhat cluttered with 17 command buttons on it. How can I put the command buttons/macros in a combo box list so I can save room...

ok thank you for looking at this.

I'm using a running total that sums if it is true that the account numbers equal the ones in my post. Problem now is that there are numerous repeats of the same data. Need a way for the formula to only calculate the first instance of the account number it comes across, not summing up every...

disregard this question. Another question has taken it's place. chris

I have a DB with the following tables/fields: Table=GLAccount Field=GLAccountNumber In the field value, there are 7 different account numbers that I want to sum up (there are many more, but only want to sum seven of them). The account numbers represent different product lines. They are...

I am trying to figure out the formula for summing some consolidation accounts from Businessworks Gold 2011 (BWG). I have the developers edition of CR for BWG so I can access the DB for BWG. The account numbers from BWG "Chart of Accounts" are: 400000.000 419999.000 430000.000 The Table for...

thank you Sir. All appears to be well. I'll be putting it through the paces. chris

you just joggled my memory. Don't I have to drop the control onto the tab for the page I want and not on the page itself? chris

you're a genius!! Can you remind me how to stop the control from showing through all the tabs? I only want it to show on the first tab, but it "bleeds through" onto the other tabs. chris

Here is my full project minus most records and stuff to trim down size. chris

I think I'll run into an issue with the DB size. Let me see if I can remove most of the records and ZIP if that helps. chris

Don't know if it helps or not but the control on the form is "expanded" to show both AM/PM times when this error happens upon opening the form/changing from design view to form view.

I'm not seeing a combo box in the control but I do see a command button that is named cmdShowLists in your solution and it did carry over the name to my controls command button.