Percentages In Option Groups

Mar 24, 2006

Been searching for an answer to this one but still cant quite get it.

I am using an option group to subtract and add percentages on an amount in a text box. This is the code i am using but there is something wrong. My syntax is out.

Me.TechsRate = ((Me.Chargeout.Text - (Me.Option17.OptionValue /100))

I am trying to calculate 5% or 10% or 15% and so on, up to 35%

Thank you in advance

View Replies


ADVERTISEMENT

Option Groups

Jan 13, 2006

Hello Everyone.

I have a form that gets its data from a query.

There is a field in the query called "FinalisedDate" which is a date/time field. I want a button called Current that when pressed it shows all records where the FinalisedDate field is Null which is to be the default of when the form is open.. Another button called "Aged" is pressed it only shows records that have the FinalisedDate field has a value (i.e. not null). I want another button that shows All Records (i.e Current and Aged).

I hope anyone can help. I have searched the forums but did not find a similar problem that I can copy.

Regards

View 1 Replies View Related

Option Groups

Nov 23, 2004

This is a multi-faceted question may the answer to the first may help the second.
I have two option groups each with two options in each.
The first is called Frame 57 and has two options A ( the wizard assigned a value of 1) and B (assigned a value of two).
The second is called frame 58 and has two options C ( the wizard assigned a value of 1) and D (assigned a value of 2).
I have set enable on Frame 58 to No.

My aim:
If I choose A in Frame 57 then I want Frame 58 (with both options) to become enabled.
If I choose B in Frame 57 then I want Frame 58 to remain un-enabled.

When writing the code do I
Put it in the Click event of the FRAME?
and should i refer to the option groups by their name (ie: A or B) or by their assigned value (1 or 2).

This is what I have at the moment
Private Sub Frame57_Click()
If Frame.57 = 1 Then
Frame58.Enabled = True
Else
Frame58.Enabled = False
End If
End Sub

This seems to work though when I return close and re-open the form Frame 58 (even if it was chosen and enabled) is now not enabled even though the option is Frame 57 is correct and visible.

Hope this makes sense - any help appreciated

View 4 Replies View Related

Two Option Groups, One Won't Work

Mar 19, 2008

I'm trying to create a form for entering data for new items for a warehouse inventory. So far, I've figured everything out, but now I'm stuck.

I want to create an option group for two separate snippets of information: Whether a product is damaged or not, and whether a product is in numerical order or not.

I have created two bound option groups with option buttons, one for "Damaged?" (Yes or no) and one for "Sequential?" (Yes or no).

When I open the form, however, only the "Damaged?" buttons work. I can click either one, and it changes from yes to no and vice versa. However, the "Sequential?" options do not work. It doesn't matter which option group I try to click first, I cannot select "Yes" or "No" under "Sequential.

Any input would be greatly appreciated!! Thank you!

View 1 Replies View Related

Option Groups That Run Reports In Forms

May 18, 2005

In the file MembershipV3A2K.zip that was posted at the link listed below...I found a form that had a feature I would like to use or create on my own. I'm not sure what to call this feature. But it looks as if the form has two option groups and a listing of all committee members. In one of the option groups you selected which report you wanted. The second group you selected your output method for the report. The form in the database posted is labeled as frmPreReport but I was not able to get this form to work, so I think various components are either disabled or removed???

I'm not familiar with visual basic and want to know if there is a way to create this feature without visual basic knowledge? If so, would anyone be able to point me in the right direction? If visual basic knowledge is required, what would be a good source for this information?

http://www.access-programmers.co.uk/forums/showthread.php?t=85876

View 4 Replies View Related

Option Groups Will Not Stay Null.

Jun 29, 2005

I have a form with 6 option groups, each with 2 option boxes (-1 & 0). They are triple-states and start off in null mode with a validation rule of "Not Null". The idea is to ensure the user has decided something for each option group before being allowed to save the record.

The problem is that each time I load the form, the first box I select, all the others then default to the same option (no longer null).

Any Ideas?

Thanks,

Ben

View 2 Replies View Related

Changing Stored Value Of Option Groups

Aug 8, 2005

Sorry if this is an easy one and I just missing it, but I have a form in an Access2003 database with option groups for ratings for 18 individual tasks ie:
Safety: 1. Satisfactory 2. Marginal 3. Unsatisfactory 4. N/A
The value stored in the table is 1,2,3, or 4 for each one, obviously.
How can I change the stored value in the table to "Sat" "Marginal" "Unsat" etc?
Or, if easier, make the report convert the numerical values to names?

View 4 Replies View Related

Modules & VBA :: Linking All Option Groups

Mar 13, 2014

I have 26 different option groups all with numeric values set for YES , NO, and N/A.

I attempted code to have the code read if the frame values were 1 Or 3 for all frames then a text field would read as "Pass" or it would be "Fail" but its not working. How to link all the options groups so that if YES or N/A have been selected then it will generate a PASS but if any of them selected NO it will be a FAIL.

View 3 Replies View Related

Forms :: Web Form Option Groups

May 13, 2013

How to create a Web Form and include an option group (5 or 6 radio or check boxes)? I really need the page to layout all of the options (not in a drop down). This will allow users compare answers on the fly looking at the form.

View 2 Replies View Related

Reports :: Option Groups To Filter Report

Nov 14, 2013

I have a report with 2 option groups, I cannot get both of them to filter the data simataneously, they will each inititally filter the data, but when the opposite group it clicked, the previous filter data does not remain filtered. I have posted the code for the two option groups, I know I'm doing something wrong.

First option group code:
Private Sub Frame43_Click()
Select Case Me.Frame43.VALUE
Case 1
Me.Filter = "allowable_weight Like '263000'"
Me.FilterOn = True

[Code] .....

View 5 Replies View Related

Show Query Fields In Subform Using Option Groups

Aug 13, 2006

Hi there

Is there any way to control the "show" criteria in a query from option groups... i.e... a check box for someone to say if they want to view items in the query or not? (But not to affect the actualy query data in any way).


Cheers!

View 6 Replies View Related

Forms :: Changing Combo Boxes To Option Groups?

Dec 11, 2013

I've created a form using the form wizard and all of the fields show up as combo boxes. I would like to change a couple of them to option groups with radio buttons. Is there anyway to do this without deleting the fields and making the option boxes from scratch? The reason I ask is because when I do the option boxes from scratch with the wizard, it alters the way the information shows up in the datasheet (it's a split form).

View 2 Replies View Related

Percentages

Apr 7, 2006

Simple question: how do you convert vlaues into percentages?
I have a boolean expression so when it's ticked the bookings are regular, and if they're false they are occasional bookings. I have used 10 bookings as test data (5 regular - true, 5 occasional - false). How would I convert these into percentages? For example, I've used the "Count" total to fint the number of regular and occasional booknigs, which are both 5. This is 50%, but how would I do that? Thanks for your help guys. :)

View 2 Replies View Related

Percentages Help :)

May 4, 2006

hey there i need help :)

ok, so i have to work out week by week percentage uses
i have a query that already finds the bookings in the week already, that works fine, but then i need to find the % use for that week, which is the count of the number of bookings in the week / 21
ive tried doing this in an update query, but it doesnt like me :)
any help would be great :)
i have a % use field in my table that it updates to, but im flexible :)
thanks

View 1 Replies View Related

Percentages Of Time

Apr 5, 2007

Hello all,

I have a requirement to give a % figure from 2 time fields. I would have thought this was simple, but when I divide the fields I keep getting #Error. Its not an error caused by a divide by zero, i can recify those. Can anyone point me in the right direction to get a % from 2 time fields.

Cheers
vmed

View 5 Replies View Related

Displaying Percentages

Jan 13, 2008

This is probably simple but it's something I haven't had to do before.

I have a main table.
I have a filter query based on this table.
I have a report, based on the query, which displays the total number of records in the query.
In the same report, I would like to display this total as a number (already done, obviously) and also as a percentage of the total number of records in the main table.

How would I go about this?

View 1 Replies View Related

Query Percentages

Apr 20, 2006

Hey guys.
I have a boolean expression which I want to calculate the percentage of.
I have the field 'Regular Booking' which is either true or false. I have 6 true and 5 false, equalling to 11 in total. I've tried using: 100*[CountOfRegular Booking] / [TotalRegular Booking] but this gives me the same percentage for both true and false. So if I enter 5 I get 45.54% for both true and false... why is this? I've had trouble with this for ages now and I'm pulling my hair out, lol. :(
Thanks guys!

View 13 Replies View Related

Modules & VBA :: Cannot Seem To Get Percentages In Query

Aug 10, 2015

I am using following function to return percentage spend by testing against number of months elapsed. I am unable to show the CSpend as percentages and I cannot seem to get the percentages in the query.

Public Function CSpend(mMonths)
If (mMonths) = -4 Then
CSpend = 1
ElseIf (mMonths) = -3 Then
CSpend = 0.99956
ElseIf (mMonths) = -2 Then

[code]....

View 4 Replies View Related

Data Type For Percentages Or Text?

Jan 25, 2006

Is there a data type that I can use that will handle both text and numbers such as percentages? Or is there a way I can set the field type to text then convert the text to a percentage? I plan on using this field in a form so when the user inputs the info I will want to display it in the correct format. Any ideas or suggestions?

Thanks

View 2 Replies View Related

Calculate Percentages Of Survey Responses?

Apr 22, 2008

I'm setting up a database for student evaluations. Students have several options as to how well the instructor did for each survey question. I've been able to set up the data entry form to my liking, and I can use a query to average the total answers to each question, including a count of how many people responded. HOWEVER, I need to calculate the percentage of responses for each option. For example, I need to know the percentage of students who picked "Excellent" for question 1, how many students chose "Very Good", how many chose "Good", etc., so on and so on for every question. How can I do that? I'm completely stuck and a novice user. HELP!!:eek:

View 3 Replies View Related

Percentages In Table Design View

May 4, 2006

can anyone explain how to use a percentage in a table.

i have a field designated as data type "number" and format set to Percentage.

when i go to datasheet view and attempt to enter in these percentage (1%,50%, 34%, etc) it is multiplying the data entered by 100 (100.00%,5000.00%,3400.00%, etc).

gotta be something easy.

TUKTUK

View 3 Replies View Related

Tables :: Fiscal And Percentages Calculations

Apr 20, 2015

I'm trying to create a table in an Access Form or create a block of code to export the table with query results to Excel or PDF. In the end I would like to run a query or queries to populate the table or export the query results creating the table. I'm not sure the best way to create the table.

View 3 Replies View Related

Reports :: Percentages Of Approved Proposals

Nov 20, 2013

I'm creating a report that list multiple users providing an input of "approved" or "not approved" for a plurality of proposals. I'm trying to create a report that lists the percentage for each user that calculates the number of times the user inputs "not approved" over the total number of proposals that particular user reviewed.

For example,

Steve reviews 50 proposals, and of the 50 proposals Steve inputs 10 of those proposals to be "not approved". I need a calculated field that counts the number of times that Steve inputs "not approved" and calculates that 20% of proposals reviewed are not approved, of all the proposals he reviewed. The number of proposals are continuously being added so the number 50 will not always be the denominator.

There are at least 10 other users that I have to do the same calculation but if I'm able to do the example above.

View 6 Replies View Related

How To Allocate Percentages Of A Number Across Different Fields

Jul 27, 2012

We have a model at my job which shows every job code one can do (there are only about 25 of these jobs) For example, let's say one job is called "Trade Settlements" and it's been estimated that we spend about 1000 minutes a day doing this particular job across the entire floor.

Well, I want to come up with a way to allocate the minutes of this to certain hour blocks and determining whether our group is over/understaff given the results.

So let's say I want, 30% of it to be done from 9-10 am, 10% done over the next 4 hour time blocks, and 2-3 pm for the remaining 30%.

Thus, we'd get something something like 300, 100, 100, 100, 100, 300 minutes and 0's for other time blocks.

These percentages would be input fields so if anyone types in a percentage, they get # of minutes spent for that hour on that job. Ultimately we would add these numbers up with other jobs and be able to easily update from there for any job type we wanted.

View 1 Replies View Related

Simple Query Problem - Calculating Percentages

Mar 7, 2006

Hi, first post!

Just started doing access at work and have a problem.

I have a database. Each record has a bunch of different fields.

In one field, the record can either be DC or DS (different classifications).

I would like to run a query which would tell me the percentage of DCs and DSs.

I have managed to create a query that counts the total of each one, but for the life of me i cannot figure out how to do the percentages.

Can anyone help?

I am using Access 2000 and my query is being made in design view

The Query has 2 columns:

Column 1
Field: DC/DS
Table: Main
Total: Group By
Show: yes

Column 2
Field: DC/DS
Table: Main
Total: Count
Show: Yes


Can I add the percentage section as another column (using an expression?) or will it have to be another query, that runs the above query then uses data from that?

Thanks, Craig

View 2 Replies View Related

Create Check Boxes/Option Buttons/Option Group Using VBA

Mar 14, 2008

I’m really stuck on how to create: Check Boxes/Option button/Option Group in VBA.

Could someone help on either all of them or some of them please?

Thanks

Richard

View 2 Replies View Related







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