Forms :: Multiple Selection For Pivot Table

May 2, 2013

I am working on a form (UI). Initially I have used a combo box, where you can pick an option and the rest of the form will display only data related to the option/record. My form contains different subform, and most of them are PivotChart form as subform, and also some table with the text box that will display the data according the selection from the combox box or form control.

I would like to know if there is any way beside the combox box, that will allow me to do multiple select. For example in excel, for pivot table, we can do multiple selection and automatically, the pivot table will show the total (let say sum) of the selected option.

Again, my form has pivot chart form as subform, and label with text.

Also, I have a form that is only have pivot chart as subforms.

View Replies


ADVERTISEMENT

Forms :: Multiple Selection Listbox To Table

Jul 24, 2013

I have a form called "Record Call" when a user can input the calls that they have made or are scheduled. This form is based on the table "Call Records". I have created a new table called "CallAttendees" and added a listbox to my form for users to select who attended/participated in the call.

My code loops through the selections and writes these selections to the "CallAttendees" table. In this table i have an auto #, CallRecord, and Attendee fields. My code is supposed to write the "ID" field from the "Call Record" table to the "CallAttendees" table so that i can create the relationship between the two tables. However, this field is coming up blank since my form isn't generating the auto # until the record is closed.The tables are stored in a SQL server. I also tried saving the record prior to running my code.

View 5 Replies View Related

Forms :: Total Multiple Pivot Tables?

Feb 4, 2015

I have a report that shows 3 pivot tables on the same page. What we would like to do is total (or perhaps subtotal) the three tables into a summary table.

each table has number code, name, data 1, data 2.

The three tables are identical with the exception of I filter on only specific number codes.

Currently I simply have a 4th pivot table with all the number codes and just hide all the rows except top and totals.

I would love to be able to use something like subtotal to simply display the totals (from my 3 tables)

View 3 Replies View Related

Forms :: Pivot Chart To Show Progress In Multiple Projects Over Time

Aug 30, 2013

I'm aiming to create a stacked area chart to display the progress of multiple projects over time, so we can review and forecast project load over time.

The data comes from this table:

tblProject
* ProjectID
* DateProspect
* DateConfirmed
* DateStarted
* DateComplete

A project passes through the statuses Prospect, Confirmed, Started, Complete. The current status of each is calculated in qryStatus from the dates in tblProject. The past and forecast statuses for each project will probably be calculated each time the chart is created (or maybe not necessarily so?)

To create the stacked area chart, the x-axis will be months (e.g. Sept 2013 - July 2015). On the y-axis will be the count of ProjectID, and the series will be the different project statuses.

The sticking point is getting from the Date* fields to the past and forecast statuses in each month. After that I imagine it'll be reasonably straightforward to put into a pivot/chart.

View 3 Replies View Related

Insert A Multiple Selection Into A Table

Mar 23, 2008

This is probably in the wrong forum, but I'm not sure what area the answer would cover, either queries, macros, VBA etc.

I have a form, on which is a listbox with multiple selection enabled getting it's data from a query. What I want to do is for the user to be able to select multiple products from the listbox and have some VBA code or query concatenate each id and insert them into a table, separated by commas so I can separate them again for reports etc.

Eg.

Listbox:
ID
1
2
3

User selects 1 and 2 and clicks submit. Selections are concatenated to 1,2 and inserted into the table.

Please bear in mind I'm not the best at this kind of advanced databasing, so a simple or at least easy to follow answer would be very appreciated.

Thank you all in advance.

Steve

View 8 Replies View Related

Forms :: Export PIVOT Table Filtered Data

May 13, 2014

I have a PIVOT table that is used to select courses. I have some vba code that exports this to pdf, but it exports the entire data not the filtered data. Is this possible just to export the filtered data?

View 8 Replies View Related

Forms :: Combo Box Selection With Multiple Query

Feb 18, 2015

I have created form with multiple tables field in some of these fields I have assigned the combo box selection the total combo boxes in form is four and all are unique numbers but this form is incomplete.

1.When I select or update any of four combo box then remaining combo boxes and fields on form should be updated automatically with related records.

2.I need to bring calculated fields from multiple queries on to my current form .how I can insert query fields in to form...

View 1 Replies View Related

Forms :: Multiple Selection On Form (list Box)

Oct 8, 2014

I am trying to resolve a problem with selecting multiple records.

I have a table called T_user and bound form called F_user.

This form displays all 3 fields from that table.

When I want to add a new user, I enter a name and select a department.

Some of the users work for few departments, so here is the question:

How to select multiple departments for one user?

The department field in F_user is set to LISTBOX, and the multi select option in properties is set to SIMPLE.

I can select multiple departments, but as we know it won't save in the table, it will leave it as NULL value.

How can I save the record then? In another form I need to select users from specific department, so lets say A.Smith, need to be visible in those few selected ones.

I have seen this [URL] .....

form this post [URL] .......

but unsure how can I make it work on my form.

View 5 Replies View Related

Forms :: Populate Text Box After MULTIPLE Combobox Selection

Apr 1, 2013

I have a form based on a query.On the form I have 4 comboboxes.The combo boxes filter eachother without a problem (based on custom select query).Now I want after the fourth combobox value is selected, I want to populate a text field with a value from a different column from the master query (after the 4 selections only 1 value should be possible)I try to say this easy.Master query contains 5 columns:

- group
- type
- job
- insurance
- charge

combo1 selects group (and filters records)
combo2 selects type (from remaining records and filters again)
combo3 selects job (from remaining records and filters again)
combo4 selects insurance (from remaining records and filters again)

[code]....

This works great and the dropbox only shows 1 OF EACH DIFFERENT record...If I add a text box and want to see the "charge" value, that I thought I could use the ME.text-code. But in order to do this, I have to add the charge column into the query of Combo4.the dropbox for insurance gives me multiple values that are the same. Is there any way to make this work?

View 1 Replies View Related

Forms :: Multiple Field Population On Combo Box Selection

Nov 4, 2013

I'm building a test registration form, and I want to populate 2 additional fields based on the TestID ComboBox selection. This same TestID table has a Requirement and Expected result field, that I want to display for the end user, to make sense of the test in question. Multiple fields in the ComboBox does not work since you cannot select a single testID; you can click on the relevant testID, but the table remains in view, rather than displaying only the relevant testID.

View 7 Replies View Related

Forms :: Populate Textbox After MULTIPLE Combobox Selection

Apr 1, 2013

Got a bit stuck in a database. I have a form based on a query. On the form I have 4 comboboxes.

The combo boxes filter eachother without a problem (based on custom select query)

Now I want after the fourth combobox value is selected, I want to populate a text field with a value from a different column from the master query (after the 4 selections only 1 value should be possible)

Master query contains 5 columns:
- group
- type
- job
- insurance
- charge

combo1 selects group (and filters records)
combo2 selects type (from remaining records and filters again)
combo3 selects job (from remaining records and filters again)
combo4 selects insurance (from remaining records and filters again)

Combo4 is based on following query:
-column1
Insurance
Total=Group by
Show=yes
-column2
Job
Total=Where
show=no
Criteria [forms]![name].[combo]

This works great and the dropbox only shows 1 OF EACH DIFFERENT record

If I add a text box and want to see the "charge" value, that I thought I could use the ME.text-code. But in order to do this, I have to add the charge column into the query of Combo4.

If I do this, the dropbox for insurance gives me multiple values that are the same. Is there any way to make this work?

View 1 Replies View Related

Forms :: List - Values From A Table Depend On Selection From Different Table

Jul 23, 2015

Situation: 3 tables. Manufacturers, Countries & Provinces/States. 1 Form for data entry in Manufacturers.

Countries table contains ID, Country and CountryCode fields. i.e. 47, Great Britain & GB

Provinces/States table contains ID, Province/State and CountryCode. as in 1, Alaska and US.

In the form the country is easily selected from a list refering directly to the Countries table.

Problem: How to make a list in the form from which the user can simply select the province for the country that has previously been selected. And not a list with all teh provinces and states from every country in the world. (This would be a really really long list...)

View 3 Replies View Related

Forms :: Listbox Selection Based On A Table

Jul 18, 2014

I have a form with a listbox that allowed multiselection.

The listbox depends on the field "name"

And I have a table "names_should_be_selected" (fields: name, date ...)

It would be great if alle names in the listbox are selected when the name is in the table "names_should_be_selected".

View 3 Replies View Related

Forms :: Nomination Form - Combobox Selection List Not Updating After Each Selection

Oct 27, 2014

I am designing a nomination form (web database so no vba macros can be used).

The form has 3 combo boxes: cboStaffName, cboLevel, cboNominee.

The form is bound to the tblSubmit table where the submissions are populated.

I used a select statement:SELECT Staff_List.Staff_Name FROM Staff_List; to populate the combo box for the Staff Name selection.

This is the select statement to populate the job level combobox:

SELECT Staff_List.Level, Staff_List.Staff_Name FROM Staff_List WHERE (((Staff_List.Staff_Name)=[forms]![frmtest]![cboStaffName]));

The select statement to populate the combobox for the nominee combobox:

SELECT Staff_List.Staff_Name FROM Staff_List WHERE (((Staff_List.Level)=[forms]![frmtest]![cboLevel]));

The problem is that the staff_name in the first combobox is still found in the nominee combobox which should not be because a staff cannot nominate self. There is a field in the Staff_List called YesNo that should be activated for each staff that is selected so that the select statement on the nominee combobox can be updated accordingly to remove items with the field "Active"

How to get the checkbox selected for each corresponding staff.

Sample of the database has been attached.

View 4 Replies View Related

Forms :: Showing Image From Table Using Combo Box Selection

Apr 9, 2014

I am a novice to Access and in order to get some training in my workplace I need to show how access can be applied to my role.

I have a table of information consisting of 3 fields:

Motor manufacturer
Model
Attachment (picture of particular car)

I want to have someone able to select the manufacturer and Model from Combo boxes and this will pull up the image associated with this model.

There are more than 1 model for each Motor manufacturer so you may have:

manufacturer Model
Ford Fiesta
Ford Mondeo
VW Beetle
VW Golf
Fiat 500

You must not be able to select the wrong model for manufacturer, i.e.
Ford 500

The images are currently saved onto the table as an attachment,
This may be wrong as well,
This may be a simple task to do, but hopefully I can get it running smoothly and show this is the right tool for the job.

View 3 Replies View Related

Forms :: Value To Put In Textbox For Field In Same Table As Combo Box Selection

Jul 8, 2014

I have a form frmCrisisSupportWorkers with a tab control on the form. On the first tab, Personal Info there is a combo box called cboLocation. It is next to the Town/City.

I have a text box that updates the postcode after the selection is made below it but that is as the post codes are stored in the combo box and I just put the column for the postcode in the control source of the text box.

I can't do that for state as I have it stored in another table and use a numeric identifier to show which state is selected.

I want to have a text box below that auto updates the state once a town is selected but I can't seem to get it working.

View 14 Replies View Related

Queries :: Append Data In Access Pivot Table To A Table (or Requery On It)

Jan 22, 2015

Is there a way to append a pivot table to a table or possibly make a query based on a pivot table? I need to get a count of Part Numbers and I need the average price for all these parts. Additionally I want to ignore a count of less than 3.

Also I am having trouble filtering on the count in the pivot table... haha, so I was gonna Query on it later on.

View 2 Replies View Related

Pivot Table

Oct 13, 2005

Hi,

Have Access XP on Desk top and lap top. Have about 10 various databases for different projects.

On the desk top, I cannot get a Pivot Table to open in any of the databases, but on the lap top, the same databases all have Pivot tables.

Is it possible that I have turned it off on the desk top?

Thanks.


Mike

View 3 Replies View Related

Pivot Table

Jan 6, 2006

Hi everybody.

I have a pivottable query.
This works great.

I have a column with averages.
This works great to.

Now here is my problem:
At the bottom of my Averages column there is a total (sum)

I want an average in stead of a sum.

Please help me guys....

Thank you very very much in advance...

View 3 Replies View Related

Manipulate A Pivot Table

Apr 4, 2007

Is there a way that you can manipulate a pivot table, (example adding more item in a list) after the pivot table is created.

View 5 Replies View Related

Pivot Table Question

Mar 16, 2007

Is there a way to get certain parts of the pivot table to not allow the drop down selections?

View 1 Replies View Related

Query To Act Like A Pivot Table???

Sep 2, 2005

Ive got a query (SearchCriteria) whose data looks like this:

Call ID....Problem Source............Problem Source2
15366....Complaint....................
15224....Collateral Order............Complaint
15734....Delivery.......................
15733....Delivery......................Order Taken
15738....Delivery.......................
15137....Complaint.....................
14238....Other.........................Delivery
15072....Complaint....................Delivery



What Im trying to do is create a query on the back of the one above which will have Problem Source in column 1 and then 2 more columns with their counts in them. So:

Problem Source......CountOfProblem Source...........CountOfProblem Source2
Collateral Order................1............................ ..................1
Complaint.......................3................. ..............................1
Delivery..........................3............... ...............................2
Other.............................1............... ...............................0


Ive created a Query with this SQL:

SELECT SearchCriteria.[Problem Source], Count(SearchCriteria.[Problem Source]) AS [CountOfProblem Source], Count(SearchCriteria.[Problem Source2]) AS [CountOfProblem Source2]
FROM SearchCriteria
GROUP BY SearchCriteria.[Problem Source];

but this gives me:

Problem Source......CountOfProblem Source..........CountOfProblem Source2
Collateral Order.................1........................... ..............1
Complaint.........................3............... ..........................1
Delivery...........................3.............. ...........................1
Other..............................1.............. ...........................1


I guess this is because it's filtering on the first Problem Source and then looking for non-blanks in the second Problem Source which isnt what Im trying to do!

Any inspiration greatly appreciated as always...

View 2 Replies View Related

Pivot Table Query

Jul 7, 2006

I have a query I saved which pulls data and a form that creates a pivot table based upon the query.

Is there a way to create a query based upon criteria such as dates to limit my recordset? I'm trying to set date values in a form and update my saved query but I cannot figure it out. Any help would be appreciated.

Here is the SQL I use to create the standard query. What I plan on including through vb is a "Revenue_Date" variable "FROM" and "TO" date in the code to limit the output based upone the dates entered.


SELECT PARENT, TYPE, SUM(TOTAL) AS COMBINED
FROM [

SELECT
tblStmt_Tracking.Parent_Carrier_Name AS PARENT,
'1. IND_Amount' as TYPE,
IND_Amount AS TOTAL
FROM
tblStmt_Tracking INNER JOIN tblCheck_Log ON tblStmt_Tracking.Check_Assignment_ID = tblCheck_Log.Check_Assignment_ID

UNION

SELECT
tblStmt_Tracking.Parent_Carrier_Name AS PARENT,
'2. SBG_Amount' as TYPE,
SBG_Amount AS TOTAL
FROM
tblStmt_Tracking INNER JOIN tblCheck_Log ON tblStmt_Tracking.Check_Assignment_ID = tblCheck_Log.Check_Assignment_ID

UNION

SELECT
tblStmt_Tracking.Parent_Carrier_Name AS PARENT,
'3. IND_Bonus_Amount' as TYPE,
IND_Bonus_Amount AS TOTAL
FROM
tblStmt_Tracking INNER JOIN tblCheck_Log ON tblStmt_Tracking.Check_Assignment_ID = tblCheck_Log.Check_Assignment_ID

UNION

SELECT
tblStmt_Tracking.Parent_Carrier_Name AS PARENT,
'4. SBG_Bonus_Amount' as TYPE,
SBG_Bonus_Amount AS TOTAL
FROM
tblStmt_Tracking INNER JOIN tblCheck_Log ON tblStmt_Tracking.Check_Assignment_ID = tblCheck_Log.Check_Assignment_ID

UNION

SELECT
tblStmt_Tracking.Parent_Carrier_Name AS PARENT,
'5. Licensing Fees' as TYPE,
Licensing_Fees AS TOTAL
FROM
tblStmt_Tracking INNER JOIN tblCheck_Log ON tblStmt_Tracking.Check_Assignment_ID = tblCheck_Log.Check_Assignment_ID

UNION

SELECT
tblStmt_Tracking.Parent_Carrier_Name AS PARENT,
'6. IND Misc Expenses' as TYPE,
IND_Misc_Expenses AS TOTAL
FROM
tblStmt_Tracking INNER JOIN tblCheck_Log ON tblStmt_Tracking.Check_Assignment_ID = tblCheck_Log.Check_Assignment_ID

UNION

SELECT
tblStmt_Tracking.Parent_Carrier_Name AS PARENT,
'7. SBG Misc Expenses' as TYPE,
SBG_Misc_Expenses AS TOTAL
FROM
tblStmt_Tracking INNER JOIN tblCheck_Log ON tblStmt_Tracking.Check_Assignment_ID = tblCheck_Log.Check_Assignment_ID

UNION

SELECT
tblStmt_Tracking.Parent_Carrier_Name AS PARENT,
'8. Other Receivables' as TYPE,
Other_Receivables AS TOTAL
FROM
tblStmt_Tracking INNER JOIN tblCheck_Log ON tblStmt_Tracking.Check_Assignment_ID = tblCheck_Log.Check_Assignment_ID

UNION

SELECT
tblStmt_Tracking.Parent_Carrier_Name AS PARENT,
'9. Unknown_Amount' as TYPE,
Unknown_Amount AS TOTAL
FROM
tblStmt_Tracking INNER JOIN tblCheck_Log ON tblStmt_Tracking.Check_Assignment_ID = tblCheck_Log.Check_Assignment_ID
]. AS BREAKOUT
GROUP BY PARENT, TYPE
ORDER BY PARENT, TYPE;

View 3 Replies View Related

Pivot Table + Query

Oct 16, 2007

I have set up a query to filter information between 2 dates using

Between [Start date] And [Finish Date] to filter the info. I'm using office 2003 which allows me to set various pivot charts based on this info with no problems at all. unfortunatly for me several other people are using office 2000 which doesnt have the same chart functionality. so i'm setting up another switch board with 2000 type charts. Right my problem as long as I dont have the Between [Start date] And [Finish Date] codes in my query I've produced the charts I require with no problems. As soon as I add the filter into the query when i go to edit the chart it comes back saying problems updating data. This I presume is because the query wants an input. Is there a way around this?????

I've spent hours searching for this, hopefully one of you can brighten my day!!!!:D

many thanks

EQ

View 2 Replies View Related

Pivot Table - Where To Begin

Aug 2, 2006

So I have a layout formulated in my head on how I want this to look but I'm really unsure of what all I need to setup to make this happen. I've never been fond of pivot tables and due to this don't utilize them much to know how to appropriately use it in this instance.

The attached pic file shows how I'd like the form to be setup. There will be fluff at the top that basically signifies what the record is (i.e. name of the jobsite). (A) is a drop down that will list a bunch of categories (bathroom, kitchen, laundry, etc.) Upon selecting that it will populate (C) for the subcategories relative to the main category (A). (C) is a list of part names that are associated with (A). The Column heading (B) is the Plan number which there can be 3 different plans or 5 different plans. The inside data (D) is the count of each part (C) used in each Plan (B) (i.e. 2 sinks in Plan 1, 3 sinks in plan 2, etc). Listed right below that number I want to link a picture (E) showing what that, for example, sink looks like.

So I'm not sure which tables need to be created to make this Pivot Table work. I know it's not an easy solution but if someone could take a little time to help me figure it out I'd appreciate it.

View 3 Replies View Related

Pivot Table Problem!

Nov 17, 2006

I have a pivot table which I want to associate with a table in my access database. The problem is that when I try to associate it at design time, it gives me an error saying that the database is locked and I cannot access it.

I am using access 2003. Is there any solution to this problem....like making the database unlocked. If not, I wil have to create another database with the same table which seems crazy to me.

View 1 Replies View Related







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