Forms :: Checkbox To Hide / Show Series In Embedded Chart
Dec 13, 2013
I have chart (grpMaster) that is embedded in a form (frmMain), the chart is a line graph based on a query (qryDataFilter) with 4 data series.
What I want to do is have various checkboxes (chk1 to chk4) that if selected show the series and if no don't - It seems straight forward!
I've tried SeriesCollection() but this comes up with errors. (Object doesn't support this property or Method).
The easiest way i can think of is just to hide / show the series line on the chart, but can't figure this out?
View Replies
ADVERTISEMENT
Nov 10, 2014
I have a sub form with checkboxes. Each check box represents one of the columns/fields in my query. If one of the boxes is checked, I only want the column that matches with the check box to appear. I have done some research and have came upon the ColumnHidden property.How would one do this in a macro or VBA format.
View 1 Replies
View Related
Aug 8, 2013
I am using Access 2007 with Windows XP. I have a scatter chart embedded in a form that is plotting data from a subform with a trendline that is extracted and used on the form for calculations. After having the table set up correctly and running fine, I closed the database and then reopened it to have the table plotting the data in a made up 1 to 1 relationship rather than what is in the datasheet. The only way I have been able to fix this error is to change the chart type to something else then back to a scatter plot and remake the trendline. Why this is happening and how to prevent it?
View 1 Replies
View Related
Jul 16, 2015
Currently I have a query where the criteria is dependent on the combo boxes on my form. I would like to add checkboxes to my form which determines which fields are shown or hidden. For example if I had a checkbox for address, selecting it on my form will show the address column in my query results.
View 4 Replies
View Related
Jan 10, 2014
My tab name is SPA and it is the third tab in my form. I want to hide it if the AddToSPA checkbox is checked. This is what I have but I'm getting error 'Compile error: Method or data member not found"
Code:
Private Sub Form_Load()
If Me.AddToSPA = True Then
Me.SPA.Pages(2).Visible = True
Else
Me.SPA.Pages(2).Visible = False
End If
End Sub
View 6 Replies
View Related
May 21, 2014
I am having a terrible time getting this to work. I have a mainform that contains 11 multi-list boxes. That mainform when I select whatever I want in any of the 11, select all items in each of the 11, or select nothing and click my show results works great. In my detail section it displays the information it should. I need to now take that and put it in a report with a pivot graph. I created a subform that is my pivotgraph and the reason for a subform is the end-user still wants the ability to filter more should they choose.
In addition, the regular graph you can put in the report does not allow me to put in multiple items. For instance I need to have sumofmbrstargeted and sumofmbrsconverted in the values and it will say I can only choose 1 value and then it will say up to 6 items and I have a 8. So, I opted for a subformpivotchart. If I create the following code, the subform updates based on the filters on this mainform everytime. Works like a charm.
Code:
Private Sub cmdGetGraph_Click()
DoCmd.OpenForm "Graph", acFormPivotChart, , GetFilterFromListBoxes
End Sub
The problem is, I want the Graph in my Report. If I take the Report and do the same basic thing:
Code:
Private Sub cmdGetReport_Click()
DoCmd.OpenReport "Search", acViewPreview, , GetFilterFromListBoxes
End Sub
It asks for the parameters again. Example, LOB, Plan, Prod_NM. I tried just disregarding the report and created yet another subform for the reporting piece and embedded the graph and that still asked for the parameters. It works great for the subform as the graph and I want to have the ability to use the GetFilterFromListBoxes, apply it to the Search Report with the embedded Graph.
View 14 Replies
View Related
Aug 27, 2014
How do I change the legend labels of a pivot chart form so that it doesn't show the words "sum of" in front of my description. I am using access 2007.
View 2 Replies
View Related
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
Jan 5, 2014
I have a database with a main menu which opens up on start-up it works fine and all but I want to go the extra step, I wish to disable / hide the ribbons (Top and Bottom) - Or Hide the whole Microsoft Access Window and display my form with the desktop behind it.
The next thing is once I click the X or the button to close the form I want Microsoft Access to appear again as in everything to show itself again.
View 1 Replies
View Related
Apr 22, 2014
I am using Access 2010. I wish to show or hide controls based on the value in the combobox. The combobox is bound with the data type Yes/No. If Yes, controls should be visible and if no, they are to be invisible. The database is a linked one. This selection should update all the users' forms.
View 2 Replies
View Related
Nov 26, 2014
Is it possible to have a text box momentarily show the character that is input, and then hide it with a dot (or similar)?
This is for password input so that users can see momentarily, but others won't be able to.
View 4 Replies
View Related
Aug 2, 2014
I have a form (employee info) that requires the user to do a search to find the employee before then editing anything that needs to be edited.
I have a search box that will find the relevant record without any problem, however what I am looking to do is hide text boxes on the form and have them appear only once the search has found the matching record.
If no matching record is found, I would then like a message box that states 'No matching employee, would you like to add an employee' and when the user clicks OK, it then reveals the same hidden text boxes and sets focus to the first one of the bunch.
Now, I have used the 'me.textboxname.visible = True (or False) elsewhere, however, I am not sure how to trigger that after a search.
I assume I am looking at an If statement, but I am not sure how to construct it, hence turning to the experts.
Code:
Private Sub txtEmployeeSearch_AfterUpdate()
If txtEmployee = DLookup("EmployeeNumber", "tblEmployeeInfo") Then
Me.txtboxname.Visible = True
Me.txtboxname2.Visible = True
DoCmd.GoToControl "txtboxname"
Else
MsgBox "Employee Not Found", vbYesNo
<<<<<<<<<<<<<<<<<<<<<<
End If
End Sub
I know that there is a massive gap where I have put <<<<<<<<<<<<<<<< - but I am stumped as to what to put in there?
View 3 Replies
View Related
Jul 24, 2013
I have a report base on my table. Here a check box. I wanna show two label text hide/show base on when check is true or false. It will be when report will be open. I have try this but nothing is happened.
Code:
If AffecteAc= True Then
affected.Visible = True
general.Visible = False
End If
View 1 Replies
View Related
May 17, 2013
I have a Split form displaying parts information and have all data displayed from the table including an obsolete field which is a Yes/No checkbox.
I want to display ONLY unchecked fields on a button click. I have tried this code so far but it didn't seem to have any effect
Private Sub cmdCurrent_Click()
Me.chkObsolete.Visible = Nz(Me.chkObsolete.Value, True)
Me.Requery
End Sub
Commands:
- cmdCurrent = show all unchecked fields
- cmdShowAll = show all fields
- cmdSearch = filter based on textbox entry
Other: There is also a hyperlink in each field (on the form only) to open each individual record for editing.
Field in question is chkObsolete
Command in question cmdCurrent
View 6 Replies
View Related
Dec 11, 2013
I'm currently building a database in Access 2013. I've used Access many years ago, and not really in anger since maybe 2003, so I've been re-learning quite a lot. Here's an overview of my scenario, and issue:
The main purpose of my database is to allow engineers to log various bits of information when building, servicing and testing manufactured products for offshore exploration. Because some of the engineering team aren't so great with data entry etc, I've decided that, rather than deleting data, I'm going to use a 'deleted' flag: user clicks what he considers to be a delete button, but in reality an update query will simply update the flag and, because the form is built on a query which includes a 'where deleted = 0' filter, it'll no longer be shown. This will allow us more control over the data and will also allow me to check that everything is running okay.
My main forms include a number of subforms, including one which includes a second tier of nested form: Pin Maps for (electrical) Connectors.
What I need to achieve is fairly straightforward: as the user navigates around the form, I'd like a 'delete' button which is specific to that subform to become visible and for any other 'delete' buttons to become hidden. Once tested, the buttons would be 'stacked' in the same position at the top of the main form, so the user just thinks they're deleting the relevant record in the sub, or main, form.
View 7 Replies
View Related
Dec 20, 2005
Hi All.
What I would like to do, is have a form popup when the main form is opened in my db, which will detail all the changes I have made to it since the last version (this bit is OK) and also, I would like a checkbox on the popup form, that the user can tick once they have read the details so it will not show up everytime they open the main form. (Just like the "hidestartupform" property within the Northwind Database)
I create the form and all that, but do not know how to do the checkbox so once it is checked, the form will not appear.
Hope this makes sense and someone can enlighten me and point me in the right direction?
Many Thanks.
Frank.
View 4 Replies
View Related
Aug 12, 2015
I want to hide on my report unchecked checkbox ?
How can i do that ? If i shall write a code, in which event ?? Or can i use in Query Build option ?
I searched on internet and found some answers but they are not useful
(i found this code and updated for my report but still did not work)
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) (<- what is that ??)
If Me.Skyliner = 0 Then
Me.SkylinerCover.Visible = True
Else
Me.SkylinerCover.Visible = False
End If
quote : [URL]....
View 5 Replies
View Related
Aug 13, 2013
I'm trying to create a report where I can use a section header as a hyperlink to show/hide detail, but only for that section. For example, my customer names are:
Code:
ABC Co.
ZYX Co.
123 Co.
If I click on ZYX Co., I want it to show the contracts for ONLY that customer:
Code:
ABC Co.
ZYX Co.
Contract 1
Contract 2
123 Co.
Right now, my code looks like this for On_Click:
Code:
If Me.Detail.Visible = False Then
Me.Detail.Visible = True
Else
Me.Detail.Visible = False
End If
But it shows and hides detail for ALL customers when I do this. Is there a way to only show/hide for the customer on which I click?
View 1 Replies
View Related
Jan 18, 2006
Hi!
I use MS Graph and need show 2 data types:
1. Invoice Value, EUR
2. Date
Date axis group records by month, for Example Period from 2005.01.01 And 2006.01.01 has 12 positions in Date Axis.
Her I have problem: I need show sum of Values for every month.
For example in Period from 2005.01.01 till 2005.02.01 I have 3 Values: 200, 500, 600EUR. Her I need to show 1300EUR, and so every month. Her is my strandart code:
Dim strSQL1 As String
strSQL1 = "SELECT Date As Date, Value FROM Table WHERE (Date BETWEEN 2005.01.01 And 2006.01.01)"
Me!chrStatistik.RowSource = strSQL1
Thank You in advace for help.
View 5 Replies
View Related
Jun 17, 2013
I am trying to develop a form in the light of budgeting, therefore, I am designing a form with all possible options being an accountant I can think (it just a try nothing else)
Now here's the scenario
Fiscal Year
Period
Month
Working days
Period - Month - working (are my heading)
1 - Jan - 22
2 - Feb - 18 and so on
This is what I am trying to learn, if I select period 1 "Jan", application/code fill -out remaining months automatically, e.g. Period 2 "Feb"; Period 3 "Mar" .....
and if I select Period 1 "Mar", then period 2 "Apr", Period 3 "May" ......
Currently, I am using combobox, but problem is, if I selection period 1 = "Jan", then I am unable to restrict period 2 using "JAN" as both combobox are separate.
View 1 Replies
View Related
Jul 10, 2014
I have about 12 tables in a 2010 database and I want to create a single summary form showing key details of the database. Most of these will be count fields using various subset of the tables e,g. total members, count of new members this year, count of those not attending a meeting etc. More than one table will be represented on the form.How would I set up a series of controls that I then bind to SQL queries? Or is this not the way to do it?
View 8 Replies
View Related
Jul 26, 2007
Hey AP.uk
I've got Form with some drawings on it and I'd like it change depending on what the user has entered in certain fields on the same form.
For Example: when the user selects a certain type of item in the "Item1" field, I'd like the graphic to change (or another one appear) in the form. Basically an "If this is true, show this picture" type thing.
I've been trying a few things to make this happen, but to no avail... :(
Any incite anyone could give would be most appreciated.
Truly,
Dragonchaser
View 10 Replies
View Related
Feb 6, 2006
Hi
How do I easy create a checkbox that displayes a field when I check it.
For example, if I check a box named I agree, it shows a field with a phonenumber to call
Mike
View 12 Replies
View Related
Nov 7, 2013
I would like to hide/show button depend on is there anything in a field. My current code is not working at the moment:
Private Sub Form_Load()
If Form![fourniturenErrorsub]![Code Field] <> Null Then
errorbtn.Visible = True
Else
errorbtn.Visible = False
End If
View 13 Replies
View Related
Jul 7, 2011
I'm using access 2007. I'm trying to get a combo box on a form to show or hide an image on a report based on the combo box's value. It seemed simple, but I've tried lots of codes.
View 7 Replies
View Related
Aug 18, 2015
I am using Ms Access 2007 and I am new to it..I have table of following fileds
ID (as a primary key)
AccountingYear (Filed for current accounting Year e.g., 14-15; 15-16)
Series (text- as R, Y, B etc to denote series code)
OrderNo (field to store custom autonumber Order No e.g., for Series R-1, R-2, for series Y Y-1, Y-2, etc)
I have created a form using all these fields..Now what i want to do is I want to create custom order no as first 2 digit of accounting year+Series+Autonumber of respective series as
14R-1
14R-2
14Y-1
14Y-2
14Y-3
14B-1
15R-1
15R-2
15Y-1
15Y-2
Means autonumber starts with 1 for every accounting year of respective Series..how to do this and what code or formula should be applied and where the code should be inserted as I am new to Ms access
View 1 Replies
View Related