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
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
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
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!
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
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
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?
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.
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 RelatedI 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] .....
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!
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 RelatedI thought this would be easily found by searching the forum! But I had no luck.
Having trouble with an Option Group. I have an option group with 2 options, YES and NO. Value of Yes set to -1 and value of No set to 0. The field this is bound and is set to Yes/No. The problem is.... No matter what I try it keeps assigning a value to this field in my form! The option group is the last item on the form. Date being the first..... After you enter a date, and an auto number is created, it gives the option group a value of YES or "-1" There is nothing in the default value of the radio button, the frame, or the field to which it is bound. Why is this assigning a value and how can I stop it???? This group needs to remain blank to force the user to THINK before it has a value.
I have managed to get around this by changing the bound field to "Number" instead of a "Yes/No" .... But I am concerned with future queries and filtering. So is this the only way around this problem? Setting the field to "Number"?? And where is it pulling the value of the option group from when I have everything set to null??
Thanks
Curtis
I have a table for holding client responses to a questionnaire. 10 of the fields in this table are List Boxes with options "Yes", "No", and "Blank/Other". The "Blank/Other" option is supposed to be reserved for forms handed in where the field has been intentionally left blank. If the form has not been handed in at all, I want the fields to just be NULL. The problem is that if someone accidentally fills out information for a row that should all be NULL, there is no way to correct it. I have tried adding NULL (no quotations) as an option in the list box, but this does not work. I have also tried adding "" as an option, but no luck there either.
How do I add an option in a list box to leave a field NULL?
We just upgraded from 97 to 2003. Just a few little issues.
We have an option group.....3 different toggles. One is supposed to bring up incomplete records by check if the 'end time' field is empty:
ElseIf Frame240 = 3 Then
Me.filter = " [End Time] = Null"
Me.FilterOn = True
It worked in 97 version. Nothing shows up now in the 2003 upgrade version.
Any ideas
Hi everyone
Is there a way of setting a forms propertie's so that the form always stays 'on top' and visible, even if it isnt the focus. The only example i can think of to explain what i mean it the msn messanger window that you can choose to 'stay on top' even if you click on a window behind it?
Any suggestions much appreciated.
James
I have a Main Form that utilizes tabs to control several other forms by opening, closing and making them visible/invisible. One of the forms needs to be closed when its tab on the Main form is unselected. The problem is that once the form is closed, when it opens up again it opens right infront of my Main form's tab control so I need to move it down an inch to get to the tab control.
I've positioned this form where I want it and saved it numerous times. But once I select the tab, it opens up right ontop of the Main form's tab control again. I have the AutoResize set to No and the Auto Center also set to No.
Any ideas how I can get this form to stay put?
Any help is most appreciated. Thanks.
In the zip code field of my form, if the first number of the zip code is a zero, such as 02436, the zero is deleted as soon as I leave that field. The zero won't stay and I want it to so I will have a valid 5 digit zip code. In other words, as soon as I leave the field the zipcode is changed to read 2436 - without the zero. How do I fix that? Thanks.
View 2 Replies View RelatedI have a problem with validation attached to a field or an entire record (displayed via a form) in that, if the user exits that field/record by moving to the next Access record, when the message comes up, it is this next record that is displayed, not the invalid one. This is confusing.
My users usually use a filter when updating (sorry about the alliteration!) & this mostly displays just the one record out of thousands. When they remove or change the filter, the message is, as above, displayed over the wrong record.
Ideally, I prefer the entire, quite complex record to be validated at one 'go' as many of the fields are interlinked.
I have achieved this, sort of, with a button called Validate which the users are supposed to click when they have completed adding or updating a record. Most of the validation code is attached to this & it does keep them on the right record. However I can't make them click it.
I have tried controlling the record displayed by making the record pointer go back one or forward one when an error is found but this causes problems with the first/last record in the table or filtered results.
Each record has an unique number. I have tried storing this number & coding a filter to re-display it when an error is found but this is confusing when the users were not filtering to only one record. Also it only works once. If further errors are found, the application gives up.
Hi everyone,
I have created a combo box in my form, the options for the combo box are coming from a table. It all works fine expect for some odd reason, when I click on an option in the combo box then come out of access, when I go back into the database the one I had chosen has gone. Do you know how I do so what I put in the combo box will stay?
Thank you in advance for your help.
I have a process that takes a few minutes to finish. I would like a message box to appear and stay up for the entire process. I have a message box that tells the user it may take a few minutes to complete and one that tells them when its complete.
View 1 Replies View RelatedWhen I try to edit fields in a subform the cursor always jumps to the first record's first field with a tab stop. I can not complete the modification and the cursor jumps back to the first record. When on the first record and on any other field the cursor will jump to the first field with tab stop.
I use Access 2003.
My form has a button that has a calculated field on it (a dcount(...)). When the button is clicked, a couple of conditions are checked and if all is ok, it runs the vba code. If the tests fail, it returns to the form without running the code. All works correctly, except that the dcount number has disappeared. I finally figured out that it is now hidden behind the button. How do I bring it forward again programmatically?
View 11 Replies View RelatedI have a database For customers of the company, when you open the main form through the search form , there are a filter . when you try to move between orders of this customer, there are a mssage (Asking you to approve of movement between the customer orders). to this point no problem, when you approval to move , cancel the filter on the main form with a stay at the current record (current customer).
View 14 Replies View Relatedis it possible to have a form page stay open for a time limit and then automatically close and open another form?
Reason I ask when a user clicks to open the database I want a splashscreen stating terms of use etc to stay open for a few seconds before it opens into the main database.
I have two forms ( main and Sub) . Every time I want to enter a new record the main data goes blank (not required) and the sub data goes blank for new data ( required). The new subdata is related to the main data. This way I have to retype all the same data in the main form which I wish not. Need making the main form data stays so I only type the subform.
View 1 Replies View Related