Forms :: Hide Check Box Options

May 30, 2014

I am trying to make a checkbox with different graphics since the checkbox can not be resized. I thought I could stack images on top of each other and toggle between showing and hiding based on if the checkbox was checked. This actually works, but I wanted to hide my checkbox, so I hid it behind my images. This didn't work. So I brought it to the front and made it invisible. This didn't work either. What can I do? The checkbox is linked to the table, but I want the graphics to show thumbs up or down and not see the checkbox.

View Replies


ADVERTISEMENT

Forms :: How To Hide Record If Check Box Ticked

May 17, 2014

I have a subform that populates from a query from a table. I also have a checkbox as part of the table. If the checkbox is ticked, I don't want that record to show in the subform

View 4 Replies View Related

Forms :: Way To Display / Hide Information On Subform Using Check Box?

Jul 11, 2013

Is there a way to display/hide the information on a subform using a checkbox?So, when the checkbox is checked, the fields are blank but when the checkbox is unchecked, the information displays?

View 5 Replies View Related

Forms :: Label Text Show / Hide Condition With Check Box Value

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

Forms :: Show / Hide Bound Check Box On Split Form

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

General :: Spell Check Options For Runtime

Apr 1, 2015

I have a Access 2010 database running in runtime. What options do I have for spell check? I can bind to a 2010 Word spell check (if it is installed), but could I do a late bind to utilise any other office spell check? Tried to use a .net spell checker dll and get access to call out the text and get returned the errors? Not sure what options I have really...

View 1 Replies View Related

Spell Check Provides A Gateway To Access Options Settings?

Apr 10, 2008

Hi everyone and many thanks in advance.

I have configured my Access 2007 DB/app to hide the default ribbons and Options settings so that end-users cannot change the config or perform tasks that would jeopardize the integrity of the data. One of the other requirements on this project is to allow the end-user to launch the Spell Check feature.

It was simple enough to launch Spell Check from a button on a form. The problem lies in that the Spell Check feature has an "Options" button that serves as a point of entry to the Access Options that I'm trying to prevent the user from seeing.

Can anyone tell me how to hide or disable the Options button in Spell Check? I fear that this is not possible and I will have to choose between Spell Check and ensuring data integrity.

Many thanks,

Dominick:confused:

View 1 Replies View Related

How To Hide Or Disable Print Or Quick Print Options

Dec 4, 2014

I have a form which my company wanted that each single record should be printed from form. I made a print record button and put code to print single page or record. However as a natural habit people go to file > print to print which leads printing all records so 1000's records start printing. Is there any way i can hide print button. File >Print button.

View 1 Replies View Related

Hide A Check Box In A Report

Jan 26, 2005

I have create a report which contains a check box. What I want to do is to hide the box if it null. I have attached an example database to show what I'm trying to do. I have tried using:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If IsNull(Me.[Written Work Seen1]) Then Me.[Written Work Seen1].Visible = False
If IsNull(Me.[Written Work Seen2]) Then Me.[Written Work Seen2].Visible = True
End Sub

in the OnFormat event of the Details section of the report.

View 3 Replies View Related

Forms :: Make Image Appear In Form When There Is Check In Check Box From Table?

Jun 26, 2014

how can i make a image appear in my form when there is a check in the check box from the table?

View 14 Replies View Related

Using Group Options On Forms

Feb 27, 2008

Hi all,

I need help on creating a form for users to enter data for their projects' progress about 10 projects totals.

Among other data, I have difficulty to have data enter on these 2:

**On budget: have 2 check boxes: either 1/Yes and 2/ No
**On Schedule: have 3 check boxes: either 1/Yes and 2/No and 3/N/A

If I use GROUP OPTION frame for each On budget and On Schedule, whatever value Yes or No (or N/A) they will be the same for all 10 projects!! :-(

Also, I would like to FORCE the users to enter the value for those On Budget and On Schedule for each project before they move on to the next project and so on...

Please kindly advise how to do this.

Thanks so much for all your help.

View 3 Replies View Related

Forms :: Sub Options In A Form

May 11, 2013

What I am trying to do is create a form with 2 drop down boxes (A,B,C,D) &1,2,3,4...) what I want to do is make it so if you select option A in the first box only 1,2&3 are available in the second box but if you select option B 3,4&5 will be the only options available.

View 1 Replies View Related

Forms :: Field Options Not Alphabetizing?

Mar 28, 2013

I have been using Access for many years, but have come against a problem which I can't fathom.

I have a database with a field for "Organisation Type" which contains all the various options which can be chosen by the user.

However, when I'm in a field, it refuses to show that list in alphabetical order, defaulting to an order I don't recognise which is most unuseful as it makes it almost impossible to find the right item, especially for a novice user.

I thought this was perhaps because the form was based on the database table, and this didn't allow sorting.

So, to test my theory, I created a query based on the table and added alphabetical sorting to that field. As soon as I use the query as a basis for the field, I find the problem remains.

View 4 Replies View Related

Background Colours On Forms Other Than Normal Options

Aug 1, 2005

I'm wanting to get a very, very pale shade of gray as the background colour for an Access form, as well as for several text boxes on it. This is so that users can distinguish editable regions (white bgs) from uneditable ones (light gray bgs).

The default colours that pop up in the menu choices are too dark for this. I've tried using a tiled image for the background of the form, which works fine. But I'd like my uneditable textboxes to be selectable (so users can copy data) whilst being that colour too, which can't be done.

Therefore I'm looking for either the number code for a very very light gray colour (Access' default lightest is "12632256") or some sort of translator tool to let me know how on earth these numbers relate to anything in computing -- I mean, what do those numbers represent? Are they html=no, hex codes=no, rgb values, no... I mean, how is Access coming up with those numbers? I've tried just getting a light gray using trial and error and can't figure it out (even ended up with lime green at one point - very nice on the eyes lol).

Anyone shed some light on this? :rolleyes: :D

View 3 Replies View Related

Forms :: Handling Abbreviation - Autocorrect Options?

May 20, 2014

I have a form that has a field called Project Name where a user types the project name. We have certain abbreviations we use for a building making it hard to search in the future.

I know we can set the autocorrect option on Access Program but that will effect all MS applications.

Is there a way to have a certain field or for have these autocorrect options?

View 1 Replies View Related

Forms :: How To Create Custom Menu Options In 2010

Sep 15, 2014

How to create custom menus in Forms in MS ACcess 2010. For example, I have a form fmrMainMenu. At the top of the form I want to create a menu labelled "Reports" that when clicked or hovered it displays a list of sub-menu options of all the Reports available in the database. Once the user makes a selection the report is generated. The functionality that I am looking for is similar to the old menu options like File, Edit, etc., in MS Office.

View 3 Replies View Related

Forms :: Display Only Selected Options In Multi-value Control

Mar 2, 2015

I have a form with about 30 controls. I organized it carefully so that all the controls show on a single page. It actually looks really good. However, several of the controls allow multiple values. These appear as a check box showing up beside each item in the list from which these controls take their information. When I run a Filter by Form process, the form flawlessly pulls the data from the table that I'm seeking, and the check boxes are visible, both the ones with checks and without. In a few cases, in order to fit everything onto one page, I have most of the related list hidden, and use scroll bars. This works really well for data entry and for editing individual records.

Where it DOESN'T work like I want it to is in situations where the checked item(s) in the multi-value control don't show up in the box on the form without scrolling. In the table where these multi-value fields actually live, what shows up is just the code for each option, a simple numeral, with commas separating any multiple values. Is there a way to make my form show only the selected codes like in the table? My suspicion is that I'm going to be told no, that the best way to do this is to use a report and query.

View 4 Replies View Related

Forms :: Deleting ComboBox Lookup Options But Keep Old Records

May 14, 2014

I have a ComboBox which looks up the records in a query. The query contains the names of current employees. The table upon which the query is based lists Employees and their start date and finish date. The Query is based on finish date being Null (ie they're still working here).

In the main form which details tasks, I would like the ComboBox to just list current employees (which it does as it's based on the query) but when an employee leaves, their name is deleted from all previous records.

Is there a way to keep the ComboBox options limited to current staff, while also keeping the names of previous employees in the form?

I checked the table which the form is based on and it still has the values, so I'd like to show in the form too as that's what people will be working on.

View 1 Replies View Related

Forms :: Full Info For All Property Options Of Any Form Control

Jun 26, 2015

How to set all controls in the form I would like to get complete information about all property options.

View 6 Replies View Related

Forms :: Cascading Combobox To Filter Options That Can Be Entered Into Second Combo Box

Jul 31, 2014

I'm trying to use a cascading combo box to filter the options that can be entered into a second combo box.

In frmBabies, a Mode of Delivery is selected from 8 options. 4 of these are "normal" deliveries and 4 are caesarean sections.

A second combo box selects the Indication for Operative Delivery. The table tblIndOpDel contains options for normal as well as caesareans. I would like to filter the indications so that the user cannot enter an indication for normal delivery for a caesarean section.

Both tblIndOpDel and tblDelMode have a foreign key to tblDelModeCat, which categories deliveries as normal or caesarean.

I'm stuck on how to proceed from here. Sample database attached.

View 2 Replies View Related

Forms :: How To Change Drop Down Box Options In Form Without Affecting Table

Jun 20, 2014

I'm a new user of Access and I'm required to input a survey into access. The data collected is being analyzed afterwards and therefore there cannot be any alpha content in the original table so I assigned multiple choice options numbers to correspond to the answers. In form view however I need the drop down boxes to spell out the answers, not just the numbers so the interviewer can read them out, I've seen this done on other similar surveys..I also tried going into form view and editing the drop down choices but that changes the table values.

View 1 Replies View Related

Forms :: User View - Reduce Amount Of Options On Menu Bars

Aug 15, 2013

I have created a front end and put into production for my users but I want to reduce the amount of menu bar options they see so someone cant click on a button wondering what it does and mess something up. What is the best way to reduce the amount of options a user sees on the menu bars when they open the front end of the db?

View 1 Replies View Related

Forms :: Changing Text Box To Allow Fixed Data Input Options - Access 2010

Jun 17, 2014

I have created a member data base form in Access2010.

That has been populated with 366 member records

I have two text box fields that are currently free type fields, Member Type & Member Status.

What is the best way I can change these to show only the relevant options:

i.e. Member Type ( Full, Family, Pensioner, Life. )
Member status ( Current, Lapsed, Deceased)

I have tried to right click the field but the "change to" option is greyed out & not available.

I have also tried to insert a combo box or list box to show these options. The "use control wizard" option has been highlighted but when I drag either a combo box or list box into the form. the wizard does not activate.

View 14 Replies View Related

Hide Forms

Nov 14, 2005

hello,
i have a form that shows up when I start my database. It has a combo that users use to select their initials.

This form is run by the autoexec macro.

The forms stores users names that then are propagates to other forms without having users each time selecting their initials.

Is there a way I can hide the first form behind others so that it keeps the data active? I have tried to minimixe it but still can see in the gray toolbar.
Thanks.

View 2 Replies View Related

Hide Forms / Reports

Jul 24, 2007

Hi all,

I was wondering if there was a way to hide certain forms or reports from the view when you open an mdb? I would still like them to view it if the form thats not hidden opens the hidden report or form as well.

How would i go about doing this?

Thanks alot

View 2 Replies View Related

Forms :: Using ComboBoxes To Hide IDs

Jul 20, 2014

I usually use ComboBoxes to show a user-friendly name instead of an ID. For example, I would use a ComboBox of EmployeePK, FirstName + " " + LastName and set the first column as the control source but with 0" width.The issue is these are supposed to be read only. I can prevent the user from changing the field but I don't have a good solution for hiding the ability to select the drop down.

My current method is to create a transparent box over the combobox (so it can't be selected) then hide the dropdown arrow with a background colored rectangle.

View 1 Replies View Related







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