Forms :: Option Button Traffic Light System

Modules & VBA :: Changes Color Of Button From Light Blue To A Darker Blue

Nov 30, 2013

Private Sub TestButton_Click()
Dim bc As Long
bc = TestButton.BackColor
TestButton.BackColor = bc
End Sub

Somehow this changes the color of the button from light blue to a darker blue. Yes, this has no real purpose, but it is a test to see why be app. isn't working. I store the color, but it back and it's not the same color.

View 6 Replies View Related

Forms :: Option Button To Allow Yes / On But Disallow No / Off

May 7, 2015

I have a form that is linked to a table. The form show an option box that is by default set to off. This option button links to a yes/no field in the table.

I want to allow a user to change the state of the option box from off (no/false) to on (yes/true), but once it is on, it should not allow the user to switch it off.

View 3 Replies View Related

Forms :: Option Button String Value

Aug 3, 2015

My frame name is "Frame1" with Option buttons "Circle" and "Square"; My code line : Name = me.Frame1.however "Name" get a value of 1 or 2 depending on the selection.how I can get a return of the String Values instead of the Numeric values.

View 3 Replies View Related

Forms :: Option Group With Command Button

May 31, 2015

I'm using option group with value 1 and value 2 with a command button to open two different forms. This is the code:

Code:
Private Sub Command9_Click()
Dim strForm As String
Select Case Me.Cornice0
Case Is = 1

[Code] ....

I would like to close form's option group once clicked the command button after the opening of the requested value form. I tried Docmd.close but all I get is the option group no more working.

View 4 Replies View Related

Start Option /WRKGRP C:...system.mdw

Feb 10, 2006

I am trying to force the user into a specific .mdw but it doesn't seem to be working. Here is the exact entry from the shortcut properties:

"C:Documents and SettingswbDesktopSecurity_BB_Project.mdb" /WRKGRP " G:WorkgroupsProject FilesBB_Project.mdw"

As you can see the .mdb is local but the .mdw is on a network drive. The db opens up but it is not using the right .mdw.

Thanks

View 2 Replies View Related

Forms :: Option Button Link To Invisible Subform?

May 8, 2014

I have two option buttons, 1_optn and 2_optn. I have two subforms, 1_frm and 2_frm.

When clicking the little round dot (the option button) for 1_optn, I want the subform 1_frm to become visible. Likewise, when clicking 2_optn, I want the subform 2_frm to become visible. In the properties panel, both forms visibility is set to No.

I have tried creating a Macro and the best I've gotten is using the OpenForm function but that opens up the forms in a new window. I'd set the Macro to the OnClick event for a combo box (as I couldn't get the option button to work) so when "1" is clicked, the form would pop up. But they have to be in the same form. No pop ups. It also has to be an option button, not a combo box or list box.It also has to be a Macro. No Event Procedure coding unfortunately.

View 1 Replies View Related

Forms :: Lock / Unlock Textboxes Based On Option Button?

May 11, 2014

I have a form with 2 option buttons on it one with year 12 on it and one with year 13. I have a simple form with drop down menus and text boxes allocated for year 12s and 13s. I want all of the year 13 text boxes and drop down lists to be locked if year 12 is selected and I want all of the year 12 text boxes and drop down lists to be locked if year 13 is selected. I do not want to over complicate the form by hiding parts of it or having a new form open depending on the option button selected.

View 9 Replies View Related

Forms :: Option Button And Date Fields To Pass Parameter

Oct 4, 2014

I have a form with option group (two option buttons) and date fields (to select a date range). The form should pull/pass parameters from the query. There's a form button that generates a report based on the query.

Issue: I can't figure it out how to link option buttons and date range to the query so when the button is clicked it generates the report with chosen criteria. The form is for the user to enter parameters.

View 14 Replies View Related

Forms :: Create Rectangle Covering Only Desired Controls And Then Make Back Colour Light Gray

Apr 15, 2015

A2010 - on an existing form I have a few controls that I want to hightlight. I thought I would create a rectangle covering only the desired controls and then make the back colour a light grey. But if I do then I cannot see the controls. If I change the back style to transparent then the colour reverts to nothing and I'm back to square one.

It feels like I want to bring the existing controls to the font - but how?If I create new controls on an existing grey rectangle then it works fine.

View 10 Replies View Related

Option Button ??????

Jun 6, 2005

Lets say that I have a large list of locations in a listbox. What I want to do is to be able to have an option button that I can press in that will sort these locations. Like 3 or 4 different buttons, lets say like retail, finance, ect. Anyone know what kind of code I might have to use to make these sort on clicking the option button?

View 4 Replies View Related

Option Button - N/a

Mar 23, 2006

I'm working on a survey database, I'm having the users select the opton button to rate (1 - 10). Then as an after thought, I thought I would add a button that says N/A or doesn't apply. Course option buttons store numbers.

ANy idea's on how to accomplish this? What ever value gets stored I wouldn't include it in the results.

View 1 Replies View Related

The Option Button

May 30, 2006

Hi peeps,

I am encountering a few problems when I'm using the options button on a form.

Is there a way for the options button to display a different value instead of a -1 when the data is transfered to a linked table? i.e Good or Poor or Fair?

Also can a number of option buttons have the same control souce? at the mintue I have three buttons pointing at one control souce and when I select one of the buttons they all get selected.

Any help will be much appreciated.

View 14 Replies View Related

Option Button

Dec 7, 2006

I have a table that has 300+ peoples names on it. Each of these people has a region they belong to 1,2,3,or 4. I also have a form that has 3 combo boxes that are linked to this one table. This information is sensitive and can change by importing new data as well. Is there a way that I can add 4 option buttons, depending on what the user clicks on Opt1, 2, 3, or 4... that is what populates the combo boxs? This seems rather simple, but I can't figure it out.

View 1 Replies View Related

Value Of Option Button

Jan 24, 2006

Hello,

how do I reference the value of an option button in an option group?

i tried this:
Code:If [exact] = -1 Then where = where & " AND [SerialNumber] = " & Me![serialno] ElseIf [exact] = 0 Then where = where & " AND [SerialNumber] = " & Me![serialno] Else where = where & " AND [SerialNumber] Like '*" & Me![serialno] & "*'" End If

attached is an image of the form.

thanks

View 1 Replies View Related

Traffic Database

Oct 21, 2004

Hi,

I am new to access and databases. I have taken on the job of creating a new one form scratch for my company. We are an advertising company and want a system to log, track and search all jobs that go through our traffic and production departments.

I have attached the basic plan for what I think we will need. Can anyone have a look at this and tell me if it looks ok or am I going in the wrong direction. The database will record many different job types with each having unique information in it. I was thinking of splitting these job types in to separate tables but always looking up a value JobsID in the jobs table in order to provide a unique number. And would it be or how would ii go about linking jobs with each other? So one JobID may have more than one job type linked to it ?

Sorry if I have not explained this well but I am trying to learn as I go along.

Thanks brian�.

View 2 Replies View Related

Option Button Unclick

Feb 2, 2006

Hello,

Does anyone know how to unclick an option button on a form after a selection has been made?

One option is to go to the form and delete it there. But I am looking for a more effective way.

Thanks!

View 3 Replies View Related

Grey Option Button

May 23, 2006

Hi,

I have a group of option buttons. A user can select more than one. However, currently all of the option buttons have a grey spot in them except for the first one which is blank. I want all of the option buttons to be blank.

Any thoughts?

Thanks

View 2 Replies View Related

Calculation Using The Option Button

Jun 14, 2006

Hi there guys,

I have set up a form that is going to be used as a survey.

I have 19 questions that need to be answered and have set up an option group for each question containing 5 option buttons in each.

Is there away to calculate a total score?

for example if all questions were answered using opt5 then the total in the textbox would appear '95'

Thanks for all your help!

View 7 Replies View Related

Reducing Network Traffic

Aug 3, 2005

We are shortly going to start using tablet PCs over a GPRS bearer circuit for some of our employees to update our core business system from within customers homes. To do this we have purchased a very streamlined version of our core system, designed to work at a reasonable speed even over a normal GSM connection.

The employees that will be using this also use an access database that I've created though. Whilst it isn't crucial that they can use this while they're out and about, it might be useful and it's something I am interested in looking into. In order to make it feasible though, I think I would probably need to dramatically reduce the amount of data transferred between the be and fe due to the high cost of data over GPRS (as well as the speed). So I have a few questions.

1) Am I right in thinking that if I am using ms access as a backend, all the processing is done at the front end? i.e. I run a query on the front end, the whole table is retrieved from the back end and then filtered at the front end?

2) Is there any way to get around this? Or would it require switching the back end to SQL Server or something?

3) Is there any way of measuring how much data (in bytes, kb etc) is being transferred between the front end and back end while running queries, updating records etc.?

I'll probably think of some more questions but this will do for starters. :)

View 9 Replies View Related

To Untwist A Site Traffic!

Nov 22, 2006

�� : �� , �� , �� , �� , �� , �� , �� ...

�� : �� , �� , �� .

�� . �� , �� , �� , �� -�� "�� " (� ��, �� ;) ). �� "��" ��:

��

��, �� , �� . �� : �� , �� . �� , �� .

�� . ��? � �� !
�� (http://www.mulka.ru)
�� (http://www.mulka.ru)
�� (http://www.mulka.ru)
�� (http://www.mulka.ru)
�� (http://www.mulka.ru)
�� (http://www.mulka.ru)
�� (http://www.mulka.ru)
�� (http://www.mulka.ru)
�� (http://www.mulka.ru)
�� (http://www.mulka.ru)
�� (http://www.mulka.ru)

View 4 Replies View Related

Option Button Description Table

Nov 13, 2007

Option Button Description table

I would like to create a table containing description value of my option button group.

This is my description table:
tblLenkeDESC
IDLenkeDescLenkeDESC
1Lenke 1
2Lenke 2
3Lenke 3
4Lenke 4
5Lenke 5
6Lenke 6

And this is my table containing selected option from the form:
tblLenke
IDIDNameLenke
114
225
336
441
552

How can I associate description with the selected options?

Many thanks,

Debbie

View 1 Replies View Related

Option Button Linked With Combo Box

Jun 28, 2006

Morning folks,

Todays problem is as follows!...

Is there away to set the values in a combo box depending on what option button you have selected.

What I would like is to select an option button in an option group then that would trigger certain vaules in a combo box. And if I selected another option button it would change the values in the same combo box?

So if I selected optWhite, the values in cboEthnic = British AND Irish AND Other

If I select optMixed, the values in cboEthnic = White and Black Asian AND White and Black Caribbean etc...

Hope this makes sense.

View 1 Replies View Related

Locking A Record Via An Option Button

Oct 11, 2004

On my form is an option button called "optClosed". When the option button is selected, I want to lock the current record so that data cannot be changed. Is this possible?

View 2 Replies View Related

Access Check Box And Option Button

Apr 25, 2013

I'm new to access. I have created table with following fields.

ID No, Name, Address, Gender, Favorite Food

I want to create form to insert data into tables. I have used option buttons for Gender and Check boxes for Favorite Food. But data didn't insert to the table specially option button and check boxes data didn't insert but other data successfully inserted into the table.

Database1.accdb

View 2 Replies View Related

How To Use Option Button To Store Value Into Table

Dec 9, 2013

I want to make option button in access to allow user choose status like: Single, Married and Widower

Single
Married
Widower

When user choose the value must save into table. How to do this?

View 4 Replies View Related