Forms :: Totals Query That Shows Results In A Chart - No Parameter Selected

Dec 12, 2014

I have a totals query that shows results in a chart. It takes a parameter to limit results, by a combobox in a form.

Parameter in the query includes the OR "*" expression, in case someone wants to get the results unfiltered.

The Combobox in the form, has an AfteUpdate event that opens the chart (form) every time its value changes, by the [DoCmd.OpenForm "ChartForm" , acNormal] expression.

I don't know how to make it open the ChartForm when no parameter is selected in the combobox.

View Replies


ADVERTISEMENT

Forms :: Drop Down Shows Both Columns When Selected

Jun 29, 2015

I've got a form with a drop down combo box with two columns. When you hit the down arrow it shows both columns, but when you click a choice, it only shows the data in the first column. How do I make it show both columns after it has been chosen? First col is First Name, second col is Last Name.

View 3 Replies View Related

Forms :: Created A Form With Combo Box Which Shows Certain Fields Selected

Feb 18, 2014

I have created a form with combo box which shows certain fields I selected. By clicking that I want to open a NEW form which has all the fields so that I can edit the record.

View 6 Replies View Related

Forms :: Filtering Pivot Chart Subform By Parameter Without VBA

Jun 28, 2013

I have a pivotchart subform who's Filter Property I've set to:

Code:
[EEIC_ID] In ([Forms]![MainDataControl].[EEICBuffer],0) And
IIf([Forms]![MainDataControl].[TypeIDBuffer]="",[AG_TYPE_ID] Like "*",[AG_TYPE_ID] In ([Forms]![MainDataControl].[TypeIDBuffer],"")) And
IIf([Forms]![MainDataControl].[AgencyBuffer]="",[AGENCY_ID] Like "*",[AGENCY_ID] In ([Forms]![MainDataControl].[AgencyBuffer],"")) And
IIf([Forms]![MainDataControl].[FacilityBuffer]="",[FACILITY_ID] Like "*",[FACILITY_ID] In ([Forms]![MainDataControl].[FacilityBuffer],""))

The issue is that none of the parameters are recognizing the textbox controls even though the references appear to be correct. Per access.mvps.org/ access/forms/frm0031.htm, I've attempted several versions of the syntax.

I believe that I've done this successfully in several other forms, though none have been been via a pivotchart. What's more, this exact same filter string worked when the pivotchart was its own popup and the referenced form was a separate window. Once I embedded it (being the pivotchart) as a subform, however, I began to be presented with the "Enter Parameter Value" dialog, even though the control's address had not changed. Note: the form with the embedded pivotchart is separate from the control's parent form.

In essence: the filter property of a pivotchart subform has a parameter that references a control on a seperate popup form, and every one of the syntactual statements I've tried returns an "Enter Parameter Value" dialog (where they did not when the pivotchart was not a subform). I've also attempted to isolate this issue by putting the text box controls on the parent form (rather than the separate popup form) and referencing them via the pivotchart subform, but this provided no resolution (the same thing happened).

View 8 Replies View Related

Sum Totals Query Using A Date Parameter

Sep 13, 2005

Hi,

I hope someone can help this is infuriating me as I am by no means an Access expert , I'm just above beginner.

I am putting together a databse for our Credit Controllers to manage their arrangements to pay arrears.

The Main table consists of the fields.

CustNumber---Surname---Promise Amount---Actual Amount---Date

13456 Nakamura £25 £20 20/09/05

45323 Petrov £55 £55 13/09/05

21245 Hartson £23 £21 21/09/05

67543 Sutton £45 £26 25/09/05

23541 McGeady £50 £50 24/09/05

This table is input by a form.

What I want to do is to produce a Query which will total the Promise Amount column and The Actual Amount column using a Date Parameter.

For example I want to know how much has been brought in between 20/09/05 and 25/09/05 therefore producing the result that I'll get a total of £143 for the Promise Amount Column and £117 for the Actual Amount Column. I have tried using the "sum" in Totals, but I think the date parameter is affecting that, the date parameter query I'm using is :

Between [Enter the beginning date:] And [Enter the ending date:]

I'm using Access 2000. Can anyone help?

Thanks in advance

Steph

View 3 Replies View Related

Reports :: MS Access Chart Only Shows Sample Data

Jul 22, 2013

I have created a chart report, but for some reasons, it only shows Sample data (East, West, North, 1st Qtr, 2nd Qtr, 3th Qtr, 4th Qtr etc). It is in Design View. If I do Print Preview, it looks fine.

How to have the Chart properly displayed in Design View?

View 4 Replies View Related

Query Showing Different Results When Moved To Chart In Report

Dec 23, 2014

I am trying to use this query. It gives me correct results as query. However when I make chart with query on a report it doesn't show correct data and eventually stops making chart

SELECT qry.txtRC, Count(tbl.txtRC) AS CountOftxtRC
FROM tblMain AS tbl, qryRC AS qry
WHERE (((tbl.txtDepartment)=[Forms]![frmRC]![cboDepartment] Or [Forms]![frmRC]![cboDepartment] Is Null) AND ((tbl.txtZone)=[Forms]![frmRC]![cboZone] Or [Forms]![frmRC]![cboZone] Is Null) AND ((tbl.txtRC )=[qry].[atnRC ID]) AND ((tbl.date) Between [Forms]![frmRC]![startDate] And [Forms]![frmRC]![endDate]))
GROUP BY qry.txtRC , tbl.txtRC
HAVING (((Count(tbl.txtRC )) Is Not Null)) OR (((Count(tbl.txtRC )) Is Not Null))
ORDER BY Count(tbl.txtRC ) DESC;

View 1 Replies View Related

Reports :: Make A Report That Shows DONE And REMAIN In Each AREA With Pie Chart

Oct 10, 2013

I have a table that shows "DONE" and "REMAIN" for each "AREA" like below:

Code:

AREADONEREMAIN TOTAL
AREA1100200300
AREA2200300500
AREA3200700900

Now I like to make a report that shows "DONE" and "REMAIN" in each AREA with pie chart, now I have problem how I have to do this job for the graph, how should be "row source" of chart control. What query needs on this table?

View 1 Replies View Related

Reports :: Search Results Report Shows All Database Records / Not Just Search Results

Apr 29, 2014

I have built a custom search form in a MS Access 2010 database so that users can find specific records to edit. After entering the search criteria and hitting a Search button, another form opens up that shows the search results. This second form includes a command button for generating a report of the search results.

Right now, the custom search form and the search results form are both working properly, but the search results report is showing every record in the database instead of just the search results. This is true whether I access the report via the command button in the form or the navigation pane. I'm not sure if I need to correct my VBA code or the report's properties.

View 4 Replies View Related

Queries :: User Selected Fields Added To Query Through Parameter

Oct 8, 2014

Is it possible to have the user select which field is added to the query through a parameter? In my query I have a table where each record has a part number and has sales number for each month. When the user runs the query I want them to be able to select which month is returned.

My table basically looks like this:

PartNumber,Jan,Feb,Mar,Apr,May etc.
01PartNumber,15,20,30,25,28 etc.
02PartNumber,12,14,12,16,20 etc

I want the user to enter "Mar" when prompted and return the parts numbers with values from "Mar".

Access 2007

View 10 Replies View Related

Error Message For No Results In Parameter Query

Jul 25, 2005

This may be a really dumb question, but those are the easiest to answer right? ;)

Anyway, I have a parameter query where the user enters in certain criteria that it wants to look up. If there are no results that pertain to what a user enters in, is there a way that I can put in an error message that tells them that there are no results? Right now it just goes to a blank form/report/table (depending on what they are searching). I'd like something to pop up telling the user that there is no information cooresponding with what they've typed in.

Thanks.

View 2 Replies View Related

To Display Parameter Query Criteria On Report Even For Nil Results?

Nov 10, 2005

Hi,

Need advise on how to display on my report the criteria that i had specified in the parameter query even if the result is nil.

How can this be done??

Thanks!

View 5 Replies View Related

Toggling Linked Subform Shows Parameter Entry Window Twice?

Mar 9, 2014

I have two subforms in a main form. book_sub and book order subform. there are various subforms which i toggle in book order subform window by changing their properties with command button on main form. here is the code -

Code:
private sub billq_click()
Me.BOOK_SUB.SourceObject = "BILLQ"
Me.BOOK_SUB.LinkMasterFields = "[BOOK ORDER SUBFORM].FORM![ORDER ID]"
Me.BOOK_SUB.LinkChildFields = "[order ID]"
private sub stock_click()
Me.BOOK_SUB.SourceObject = "stock"
Me.BOOK_SUB.LinkMasterFields = "[BOOK ORDER SUBFORM].FORM![BOOKCD]"
Me.BOOK_SUB.LinkChildFields = "[BOOKCODE]"

Now the problem is when i change billq to stock it shows parameter entry window with caption [order id] twice. after clicking ok it does toggle the form to stock. then when i click button for billq again it shows the same thing.

the code works fine except showing parameter entry window twice with every toggle.

View 2 Replies View Related

Chart Based On Form Based Parameter Query

Mar 22, 2006

Hi all,

stuck on this, not sure if it can be resolved....

I have a parameter query for which the parameter is based on a form field entry (i wanted to avoid the dialog box popping up).

No problems with this....however, I want to create a chart based on the same query however, i get the following error message because it does not recognise the query parameter.

Error Message: The Microsoft Jet database engine does not recognise '[Forms]![frmChooseDTDate]!DateOccured' as a valid field name or expression.

Can this be resolved?

Help most appreciated!

regards to all

K

View 2 Replies View Related

Queries :: Parameter Query Returning Incorrect Results Based On Checkbox

Jul 31, 2013

I have a parameter query that contains information on a list of people and contains 3 checkboxes: alumni, parent, business

In this query, I am trying to use parameters to filter the results based on these three fields i.e.

true, false, true would return all records where either alumni, business or both are true, and parent can be either true or false.

false, true, false would return all records where only parent is true, and the other fields do not matter.

View 2 Replies View Related

Variable Results Using Totals

Feb 8, 2008

OK, this is a stumper.

I'm trying to determine if an employee changed departments in 2007.

We maintain a table that records every time an employee transfers, giving an effective date of the change. But, this table also records transferring to a different shift without a department change.

So, my logic was to look at what an employee's most recent assignment was as of 12/31/06 - this way, even if the employee's last transfer was June 3, 1827, it would still be picked up.

Then, I would see if there was any department change in 2007 by comparing any records recorded in this table in 2007 with the list from 2006 and pulling out those records that had different departments.

My first attempt was to use a query for 2006 and earlier with totals, grouping on the employee ID and grabbing the Max Effective date along with the department ID (org). Like so;

SELECT dbo_assignment_log.ppms_ID, Max(dbo_assignment_log.effectivedate) AS MaxOfeffectivedate, dbo_assignment_log.workingorg
FROM dbo_assignment_log
GROUP BY dbo_assignment_log.ppms_ID, dbo_assignment_log.workingorg
HAVING (((Max(dbo_assignment_log.effectivedate))<=#12/31/2006#))
ORDER BY dbo_assignment_log.ppms_ID, Max(dbo_assignment_log.effectivedate);

The result looked like this;

ppms_IDMaxOfeffectivedateworkingorg
289874/12/20022116
2898711/29/20062121
289885/31/19952116
289888/7/19962124
289896/1/20042114
2898911/22/20052176
289901/25/20022116
2899012/18/20022122
2899112/4/19922124
2899111/26/19972122
289919/27/20002155
289929/23/19932128
289937/27/20052134

All well and good. But, then I decided that I didn't want the org in the list since it was giving me extra records (because it was on Group By), so I took it out and ran the query again like this;

SELECT dbo_assignment_log.ppms_ID, Max(dbo_assignment_log.effectivedate) AS MaxOfeffectivedate
FROM dbo_assignment_log
GROUP BY dbo_assignment_log.ppms_ID
HAVING (((Max(dbo_assignment_log.effectivedate))<=#12/31/2006#))
ORDER BY dbo_assignment_log.ppms_ID, Max(dbo_assignment_log.effectivedate);


Much to my surprise, some records were lost.

ppms_IDMaxOfeffectivedate
2898911/22/2005
2899012/18/2002
289919/27/2000
289929/23/1993
289937/27/2005
289948/4/2004
289985/18/2005
289999/29/1999
290006/7/2000
290022/4/2005
290038/24/2005
290045/8/2002
290096/29/2005

What might cause it to drop, for example, the entries for IDs 28987 and 28988?

There are a lot of other fields in the table, but, as far as I know, they shouldn't matter.

Any ideas?

View 2 Replies View Related

Queries :: Store Results Of Counts And Create A Graph / Chart

Feb 9, 2014

I have a a table 'Orders' with fields (Order Number, Order Date, CD Number, Card Number).

I would like to produce a query in access 2010 that would allow me to count how many times the CD Number 'Diab190617' has been purchased.

I would like to store the results of this count and counts on other cds numbers somewhere so that I can produce a graph/chart of these counts. How can I do this?

View 4 Replies View Related

Totals Query/sums/grand Totals

Sep 4, 2007

Hey all! This is my first post. Been searching through the net all day trying to find a solution to this problem. Basically i have a table that looks like this (regular text is what i have and bolded text is what I need:Name Date Qty MOBrad 12/12/2007 23323 4423John 12/11/2007 3445 4432 John 12/11/2007 344 4432 John 12/11/2007 45 4432 John 12/11/2007 44 4432 John 12/11/2007 3445 4432 Grand Total: (Qty)And then I'd like to be able to carry this over and display a grand total at the bottom of every page of a report that I would need to generate. Our company produces forms and we sometimes have 60 - 70 people working on a single job. We want to see their hours individually but we would also like to see a grand sum of all their hours. If someone could help with this or needs more info let me know. Thanks for all your help!

View 14 Replies View Related

Forms :: Display Pie Chart Which Is Not Linked To Table / Query?

Mar 27, 2014

I have a status form which I use to show users the progress of various routines as they are performed. It's pretty basic; just a textbox and a couple of coloured labels; one for the outline ('things to be done') and one for the progress so far ('things done').

I have a function which I call periodically during the runtime of the routine which passes as arguments the text to display in the textbox (i.e. a description of which 'thing' is being worked on at that time) and two long integers representing what is 'done' and what is 'to be done' (i.e. 3 'things' done out of a total of 7)

So if I can divide a function into 7 distinguishable 'parts', I would call that function 7 times during the life of the overall process to show the updated status each time.

The function redraws the labels (i.e. sets the width of the 'done' label as a proportion of the width of the 'to be done' label, based on the ratio of the two arguments) and repaints the form. So you get a nice animated progress bar which can be easily controlled by calling the same function and just incrementing the 'done' argument each time.

Now - and admittedly this is purely aesthetic and for my own curiosity rather than anything fundamental - I was wondering if it were possible to represent this progress as a 3D pie chart rather than a horizontal bar (label)?

For no other reason than I think it would look really tidy.

I know it's possible to add a chart object to a form but the chart wizard insists I link the chart to a table or query. In this instance, I don't want to do that; I merely want to draw a very basic pie chart based on the two values passed as arguments to the status function.

View 3 Replies View Related

General :: Results Table - Possible To Display Only Selected Row In New Form?

Sep 24, 2013

I have created a from which consists of search boxes in the above and the table in the below.

If we search for any in those search boxes then the results will be displayed at the bottom (The results will be displayed in the table which is located at the bottom of the page)

I had done with the above part.

My Requirement :

If I click on any of the row in the results table then is it possible to display only the selected row in a new form????

If I search for a keyword MS in a search box and if it returns 40 results and if I click on any one of the result then the selected result should be opened in a new form.

Attached is my file...

View 5 Replies View Related

Query In Forms Question (printing A Single Selected Query Record From A Form?)

Oct 19, 2004

What is the best way to impliment a query in a form so that the user can view the query records, and have the option to print or save the selected record using command buttons?

I tried subforms but I could not get the command buttons to work in the subform after it went into the form, it wanted to print the entire form instead of the selected record from the subform.

So in a nutshell I have 3-4 queries that are built, and I want to have them show up on my form in a format that the user can scroll through the results and select a single record of the results and then print or save that individual record from the form, if such a thing is possible.

Thanks in advance

Todd

View 1 Replies View Related

Forms :: Produce Data From A Selected File/ Query

Feb 16, 2015

I have over 100 queries of weather data, for each month, and would like to display certain or filtered information for a selected month.

I have been playing around with a combo box to select a month from a given year, and was hoping that maybe an 'After Update' would do what I want. The problem I have is that I don't know how to do this, as the month picked and displayed in the combo box is variable , and so a sort of wildcard might do the job, if I knew how.

View 14 Replies View Related

Forms :: Query Def Always Asking For Parameter

Apr 17, 2013

I have a form called "frmManageACF", query called "qryACFFill".

On frmManageACF I have a combo box (name cmbACFFill) which has three cols. col1 = SiteID, col2 = Site code, and col 3 = SiteName. The combo box Bound column is set to 1.

In qryACFFill, results are selected where SiteID=[Forms]![frmManageACF]!cmbACFFill

The query when I hit refresh always gives me the 'Enter Parameter Value' dialogue box. I have used this method of dynamically updating a query def before so not sure why it isn't working now.

Why the Parameter dialogue box is always coming up??

View 12 Replies View Related

Forms :: Subform Only Shows First Match

Nov 30, 2013

It's been a while since I last used Access but now I need to be reminded how to populate a sub-form with all rows for a query (Access 2013).

- Do I need to establish a relationship between Table A (main form) and Table B (sub-form)?
- What sub-form properties need to be set to display all retrieived rows from the main form query (select where Table A PK = Table B PK)?

View 1 Replies View Related

Forms :: Using Combo Box Parameter Query

Apr 17, 2013

I encountered an error with my form when I used a combo box to get the set of data that I need. the combo box is from the look up value from a table, then I made a main form and attached a subform which is made from a query, after I put them together the form looks great not until I switch to another supplier or click refresh to get the new data.

One of my record is mixing to another supplier and when I checked the table where the data is recorded it was also change, so if I use this form and clicked on supplier1 the data is good, then switch to supplier2 and then click refresh or if I alt tabbed the data is there and its supplier is also changed.

I tried to delete it and retyped it but still the error sticks, also I tried to delete it permanently but still one of the data is mixing on a different supplier and its supplier in the main table is also changed. I'm using access 2007 and also a friend of mine tested it in access 2010 but the output is different it reflects the correct data.

View 2 Replies View Related

Forms :: Disable Ribbon Randomly Shows Up

Jun 25, 2013

I have disabled the Ribbon using XML code in the USysRibbon table. Everything has worked fine, except that now when I click on two different tabs that exist on my form, the Form Tools Ribbon pops up with options to go to Layout, Design View, etc., and other options, too.

I have two subforms on this tab, but neither one has a Ribbon Name set (I didn't even know how to do that when I made them) where to look to see why this is happening. The Ribbon does not show at all on the other tabs like it is supposed to. It only shows when I click on my 3rd and 4th tabs, and then it disappears again when I click on other tabs.

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved