Hiding Or Showing Input Fields And Formatting.

Apr 30, 2008

Firstly, thanks to everyone for help so far. My first access project in a proffessional environment has been successful and mostly down to the people who have helped me here. I know i didnt really do it all myself but i have learned things that will hopefully serve me well going forward!

Secondly, i apologise for the ambiguously titled thread, i'll explain what i mean.

Basically i have my form that looks like the below


What i'm trying to do, is make the questions below ("Risk in Authority" and "If Not, Risk Referred?") hidden, unless the answer to "Are All Policies Acceptable?" is No.

I have managed to make it happen, but it's far from perfect. As below:

I'd set the value for Visible to No in the properties for every object in the Questions (the pretty boxes are all named things like Box123 and Label 53, all set to hidden). Then i set the "On Click" event of the No in "Are All Policies Acceptable" (called Option168) to

Me.Box60.Visible = True
Me.Box121.Visible = True
Me.Box122.Visible = True

and so on.

This works ok, but if you click on the same option twice it reverses the action.

Is there a more effective way of doing this? maybe through Validation?

Thanks for any help once again. (I've also recommended this board to a couple of guys in the office who are already proficient with Access and SQL who can hopefully contribute to the community )


Edit: As an Addendum - this formattign should only apply to one record at a time. So if the question are visible on record 1, they could still be hidden on record 2. If that's even possible.

View Replies


ADVERTISEMENT

Forms :: Access 2010 / Showing / Hiding Fields Based On Previous Entry?

Mar 26, 2014

I am using Microsoft Access 2010.

I have a form, having following fields

Nationality, Combo box, Options are Indian/foreign State: With list of States in India.

What I want is, when data entry operator , select, Foreign, State field automatically hides.

And when data entry operator , select Indian, State field shows in the form.

How this can be done in Access 2010

View 5 Replies View Related

Access 2013 - Hiding And Showing Access Window

Apr 6, 2015

I am trying to Hide or Show the Access Window by using two buttons on a Form. Running Access 2013 in Windows 7 64bit.

I have used code from the Internet as below but added the PtrSafe item to the Function Declaration as below:-

Option Compare Database
'Hide Access desktop screen and float Forms on pc desktop
Private Declare PtrSafe Function IsWindowVisible Lib "user32" (ByVal hwnd As Long) As Long

Dim dwReturn As Long
Const SW_HIDE = 0

[Code] ....

I then have two buttons on a form coded as below:-

Option Compare Database
Private Sub cmd_Hide_dbw_Click()
Call fSetAccessWindow("Minimize", False, False)
DoCmd.OpenForm "frm_Test", acNormal
End Sub

[Code] .....

I have attached a Test Database which demonstrates the problem I am experiencing.

Do the following sequence...............

Open the Test Database. DO NOT ENABLE CONTENT
The Access 'Ribbon'Test_Database.accdb is active and usable
Open frm_Test in Design View in order to inspect, all should be as shown above.
Now click the Enable Content warning
Switch frm_Test to Form View

Click button Hide dbw. Closes the Access Window
Click button Show dbw. Opens the Access Window...HOWEVER....

Attachment 20252The Access Ribbon is locked and usable !!!

I cannot find a way to re-activate the Ribbon

View 2 Replies View Related

General :: Conditional Formatting - Print View Not Showing Highlights

Jul 2, 2012

I applied conditional formatting to a subform in a form and it works fine. The screen dispaly is showing the highlights but the print privew does not. It does not matter which printer I select.

View 2 Replies View Related

Hiding Fields

Aug 12, 2005

On a form, what is the best way to hide a label or text box? I'm guessing that I can do a checkbox which would work for me and just write a macro to hide on a false value?

View 1 Replies View Related

Hiding Fields

Apr 15, 2005

Hi can you help. I am developing an access database for an alarm installation company. The database will consist of five tables (stock, supplier, customer, stocksupplier) all with forms.

The customer table holds data for three customer types business, private, caravan. Each customer type has different data stored for it for example the business customer has more than one contact address whereas the private has one.

The problems is on the form I do not want all the fields present as this would look a mess. Is there a way of clicking a radio button or choosing from a drop down list that would make the fields relevant to that customer type appear or grey out the fields that are not needed.

I would appreciate any help as the only alternative I can come up with is have them all on one form. I do not want separate tables as this would complicate the design. I hope this makes sense and thank you in anticipation
Kind Regards :) :)
Peter

View 3 Replies View Related

Reports :: Sorting And Formatting A Report Based Off Of Values And User Input?

Jul 1, 2013

I'm trying to make a report that a untrained user can use to review the relevant data from the database I'm creating. All of the work I've done so far has been directly in the tables . Here's a quick outline of my general data organization:

Department:
DepartmentID(PK)
DepartmentName

Employee:
EmployeeID(PK)
EmployeeName
DepartmentID(FK)
Needs_Work (check box)

[code]....

Basically, I want the user to select a department to view using a combo box or option group (which I'm not sure of how to do in a report). Then, I want to view the employees within that department sorted first by whether or not the Needs_Work check box is selected, and then by how many of their competencies are unchecked.

View 2 Replies View Related

Forms :: Hiding Certain Fields Based On Number Amount

Jun 13, 2013

I search around online and did come across much info on code to how to hide fields. But, the problem is I cant seem to find a way to hide a certain amount of fields based on a number amount.

example: Lets say I have a 12 text fields to show 12 months of monthly payments, and lets say a client only has a 3 payment term. How can I list 3 under installment field and have remaining 9 fields auto hide since they wont be necessary? this way I only see what applies and not additional text fields.

View 1 Replies View Related

Do Not Report If All Fields Showing An N

Jul 28, 2005

:p Hello,

I am wondering if anyone can help me create a query (which is used as a basis for a report) using a criteria which is clever enough to know that if all fields are have an N (no) that a report should not be generated - but with anything else e.g. all Y's or a mixture of Y's and N's that a report will be printed. There are 6 columns where there could be a Y (yes) or an N (no) and I would really like to know if this is possible in access??

Thanks.

View 1 Replies View Related

Fields Not Showing On Form

Aug 15, 2006

I have created a form off a query. I made the form for adding new records only. When i bring up the form it is blank, the labels and fields don't even show. Anyone know why this is?

Thanks in advance for your help.

View 2 Replies View Related

Formatting Fields Question

Jul 2, 2005

I am attempting to improve the visual appearance of my forms and make them easier for the user. When a new record opens all the fields have the same default background color. As each field gets the focus I used conditional formating to change that color to color2 to make it easy to know which field has focus. After the field loses focus code in the lost focus event changes the color to color to color 3. ( I got this idea from a post by GHudson.) I have 3 questions:
First, An I better off using code in got focus eventas well for the second step instead of conditional fornatting?
Second, I not sure which is the best event to put the code to return the colors to the default color for a new record. I think the AfterUpdate on the form but Im wondering if there is a better one. Should it be on a property on the new record?
Third, is there a routine I can write to go through all my forms and do this code? I'm not looking forward to writing it in a couple of hundred forms.

View 6 Replies View Related

Form Fields Formatting?

Sep 26, 2005

Please bear with me, I use Access 2003 from Sweden.

Have Microsoft done something to the fields and labels in the forms in Access 2003? The depressed/inset/valley look on lables can't be seen. I've tested with transparent line and fill, as well as with colours to see what happens. No result! I can make a rectangle with depressed look, but not a text label. Also the 1 and 2 px line looks odd when using the top-left colour (looks like black). I get a thin gray line, and at 2 px the line is a bit away from the label.

I'm not using a template for the form, just the standard settings from Access.

Anything I should look for? Is it a feature that's been changed? Is it a bug I need to update Office 2003 to fix?

View 1 Replies View Related

Only Showing The Avg Result For Fields-report

Jun 12, 2006

Please help

I have created a database to track student grades. I have made a report that shows the different grades for each criteria of each unit but, because the students get to do the unit many times it shows the same criteria many times on the report. What I want to do is have the report show only the best grade for each criteria.

i also want to be able to work out the average grade for each unit from the best grade for each criteria and store this for use in another table.

If you require more info i would be happy to supply this. Thanks

View 4 Replies View Related

Reports :: Conditional Formatting On Row Of Fields

Apr 29, 2014

I have a field on a report that I was able to make bold using conditional formatting. I want to make the other fields in the row bold as well if the value of the 1st field equals a set value.

EX: Contractor Bid Amount Sq Footage =[bid amount]/[sq footage] =[bid amount]/[estimate]

I put conditional formatting on the Contractor field

EX: Field Value Is equal to "Estimations"

I was Bid Amount, Sq Footage, =[bid amount]/[sq footage] and =[bid amount]/[estimate] fields to also be bold if the Contractor field is equal to Estimations.

View 11 Replies View Related

Queries :: Hiding Date Picker From Date Fields

Nov 5, 2013

The query is there to query data, not to edit data or manipulate data in anyway. However, I am disgusted by the appearance of the date picker when I pick a field that is a date field.

Is there a way to hide/remove these date pickers from the query sheet?

Within the table itself I turned the "Show date picker" property to "Never" but that didn't make a difference.

View 2 Replies View Related

Query Fields Not Showing In Expression Builder Or Elsewhere

Mar 14, 2008

In Expression Builder and other areas of Access where the fields of a query show, my fields are not showing anymore for any of my queries. Does anyone have a solution for this?

Thanks.

View 3 Replies View Related

Forms :: Fields Not Showing With ODBC Tables

Aug 8, 2013

I Created a form and linked it to a ODBC table with no data. Set the Allow Additions property to Yes. It shows fine if there is data in the table but not when there is no data.

View 1 Replies View Related

General :: Conditional Formatting Of Report Fields

Dec 11, 2012

I am struggling to format a field on a report.

I believe it is because special charachters are in the text string

I want to highlight the field if it contains the following text

Stage 6: Won and Deploy (shipping)

Regretably, I believe Access see this as code.

I suspect I need to encapsulate it some way, but nothing seems to be working

What am I missing?? How can I force Access to see it as a text string??

View 1 Replies View Related

General :: Time Fields And Conditional Formatting

Feb 6, 2013

I have tried to change the colour of the text in time fields with no a value of 0:00 by using conditional formatting - to no avail.

View 4 Replies View Related

Reports :: Conditional Formatting Two Fields In Report

Mar 26, 2015

In my Access 2010 report, I am attempting to perform conditional formatting of one field based on the difference between two fields. In particular, one field is "Time Scheduled" and the other field is "Time In". If the "Time In" is equal to or greater than 60 minutes of "Time Scheduled", I would like to format it to be red font. If it is less, I would like to format it to be green font.how I can conditionally format to do this?

View 12 Replies View Related

Reports :: Add Conditional Formatting To Several Fields In A Report?

Mar 20, 2014

I am trying to add conditional formatting to a several fields in a report. So far i can use the contional formatting to set a field called [colour] to set that field to red and bold. But i believe I need to use an Expression for all fields, so I can make all fields that = red go red. I have used the the expression:

[colour] = "red"

but nothing happens.

Expression Is [Subtotal]+[Freight] > 50

View 4 Replies View Related

Queries :: Select Distinct Field And Showing Other Fields?

Jun 4, 2013

How to query Select Distinct field + showing other fields? E.g.:

Code:
SELECT DISTINCTROW assetMovementTable.assetNo, assetMovementTable.moveCode, assetMovementTable.compCode, assetMovementTable.compCodeDesc, assetMovementTable.assetDesc, assetMovementTable.equipType, assetMovementTable.equipManufacturer, assetMovementTable.equipModel, assetMovementTable.constYear, assetMovementTable.plateNo
FROM assetMovementTable

[Code] ......

View 7 Replies View Related

Reports :: Fields Not Showing All Data (Displaying Around 250 Characters)

Jan 21, 2015

I have a report that runs from a query with fields but for some reason its not showing all the text in the field it only shows around 250 characters, I have the field to auto grow in size but still not working?

View 1 Replies View Related

Queries :: Records Not Showing With Blank Numeric Fields

Jan 27, 2014

I have a query which selects a material ID and material name from one table and the associated manufacturer, supplier, and packaging type from three other tables. Some of the manufacturer, supplier, and packaging data were imported from an Excel spreadsheet and did not have data for those fields, so those fields are blank. When I run the query, I only get the records which have all fields filled out. How can I get the records where the material ID and material name are filled in, but the manufacturer, supplier, or packaging type are blank? Here is the query I'm using currently:

Code:
SELECT tblMaterialSpecifications.ID, tblMaterialSpecifications.Critical, tblMaterialSpecifications.MaterialSupply, tblManufacturer.Manufacturer, tblSupplier.Supplier, tblPackaging.PackageType
FROM tblPackaging INNER JOIN (tblSupplier INNER JOIN (tblManufacturer INNER JOIN tblMaterialSpecifications ON tblManufacturer.ID = tblMaterialSpecifications.ManufacturerID) ON tblSupplier.ID = tblMaterialSpecifications.SupplierID) ON tblPackaging.ID = tblMaterialSpecifications.PackagingID
WHERE (((tblMaterialSpecifications.ActiveInactive)=-1))
ORDER BY tblMaterialSpecifications.Critical, tblMaterialSpecifications.MaterialSupply;

View 1 Replies View Related

Some Fields Intermittently Not Showing Data In Access 2013

Feb 12, 2014

I've recently moved up to Access 2013 (from Access 2010) and everything went well, until one day my splash screen was blank and the program had empty fields...after seeing that all the links to the BE were OK, I re-booted and everything worked fine....until the next day the same thing happened...... The program randomly falls over about once or twice a week and I have to re-boot to cure it.....

My splash screen has a standard dlookup ( [=DLookUp("Banner","tblCompanyInfo")] ) to display the active company name...and sometimes its populated and other times its not..... if its not populated then loads of other fields on the forms are also blank - even if they point to valid data in the database!!!!!!

Win7 (both 32 and 64bit) with Access 2013 32bit on three PC's - same problem on all!!!!

View 14 Replies View Related

Modules & VBA :: Conditional Formatting With Like - Colouring Fields Within A Form

Jul 5, 2014

What I am trying to do is create conditional formatting to colour fields within a form.

The conditional formatting option built in allows me to colour based on set values i.e. Value=Design turns green. I need to somehow say if Value contains the word Design turn green. This is because in addition to the word Design there will be a variable description. I tried editing the conditional format created by the wizard to Value="*Design*" but that didn't work.

Now I'm trying to write it in VBA code but am still struggling. Here's what I tried but it doesn't like it:

If InStr([Forms]![Query2]![Activity] Like "*Design")>0 Then
[Forms]![Query2]![Activity].BackColor = vbGreen
End If

View 14 Replies View Related







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