Hello all.
Is it possible for a check box within a subform to make that entire row turn into one colour when selected true? What I want is when the check box is selected (True) that one row and the rest of the row turns into a colour e.g. red and become disabled? Any ideas?
Cheers
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
I have a form with a number of fields for users to enter data into, with a "Total" being calculated. The users also have the option to ignore these fields and just enter a total manually into a seperate "Totals" field.
I want to set the form up so that when the form is opened the manually entered "Totals" field is hidden, leaving users to enter the component values, with the total being calculated automatically.
However, I want to add an option button so that if users just want to type in a total manually rather than enter the component values, they click the option button and the manually entered "Totals" field appears and the other component fields become disabled. This would prevent both a calulated total and a manually entered total being entered into the form.
Any help on the code that I need to use when the option button is clicked would be greatly appreciated.
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
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
I was wondering if anyone can help.
Please see attached jpg
I need to change the background color of the lead status box when one of the options is selected. i.e. when warm (amber) when Hot (red)
Can anyone help please?
I have a database where new products are entered into it. Over time there are revisions that are made to these products and to capture this, a drop down box has been added that allows the user inputting the product to select the current revision number of this product.I also have another form which shows the product serial numbers, and then a bunch of fields relating to revision numbers (a check box for each), this can be used by field technicians who can locate older models and tick off a revision when they have updated a product to this specification.
What I am hoping to do is that when the user initially enters in a product and selects the revision number of it, the other form will automatically update (the check boxes) up to and including this revision... so for example if a product is being entered and is up to revision 5 - the check boxes under this serial number on the 'revision' form will all be checked automatically (Revision 1, Revision 2, Revision 3, Revision 4, and Revision 5 check boxes).
I have an simple option group (3 options 1,2 and3!!)I am building a query where I need to display records whose option group field in the table is empty. I have tried:
field = Int(0)
field = ""
field = null
isempty(field)
do not work.
I am using an Access database for a foreign language dictionary project.
One of the forms I use is populated by a query (qryLemmaTable) to retrieve information from tblLEMMA.
This form works precisely as I intend it to work, but there is a glitch on it that is driving me mad.
The form in question has an option group with 11 radio buttons that correspond to the parts of speech associated with each word in tblLEMMA.
When I click on the button optAdjective I apply a filter and the only records that are displayed are adjectives. (The same applies for Nouns, Verbs, Prepositions etc.)
Here is the glitch: even though the radio buttons apply the filter correctly, no “black spot” appears in the button. Other signals on the screen let me know what word type is selected, so I can accomplish what I want, but I want the “black spots” too!
Perhaps this will be a clue: For each radio button I use the following code in the GotFocus event.
Me.FilterOn = False
Me.Filter = "wordtype = 'A'" ‘(or N, etc)
Me.FilterOn = True
And this for the Lost Focus event
Me.FilterOn = False
Thanks for the help.
Hi
I've got an Option Group with 3 options; Yes, No and Future.
I also have a range of Check Boxes; 1 for every day of the week.
When one of the check boxes is selected I want the Option Group to change to Yes.
Currently, the Option Group defaults to Future and No will only be available by manually selecting it. This doesn't need to be changed.
Any help will be greatly appreciated!
Cheers
I stumbled upon the Option Group function just yesterday and, happy as a clam, I created a group with 2 options in radio button style. I assigned the values to a field called Registration_Type as the 2 options are "Confirmed Registrants" and "Prospective Attendees".
[Great. That part works well. When I look at the table, a 1 or a 2 is in that field so it's great to know how to control accidental ticking of radio buttons (previous 450 records or so didn't have this option group functionality so one might easily tick one of the buttons. So one part of controlling option group I know I can handle via the table itself for now.]
The challenge is how to ensure the user always ticks one or the other ... I went back to the main table and tested the 'required entry' option for the Registration_Type field but forcing an action like this is not ideal in my mind. The usual error message vagueness for the average user is no good and I don't want to limit the user so much.
Is there a way to simply have a popup come up warning that neither radio button was ticked? Perhaps something linked to the form - i.e., maybe "after update"?? I only learned about attaching code to before and after update on controls a couple of days ago, so not sure if this would be best approach.
Just something to let the user know that nothing has been ticked in the option group as that controls in which of 2 reports the data will show up in so any record not ticked might mean a registrant being left out, which would be rather disastrous <g>.
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 RelatedLong time lurker, first time poster.
I'm in need a of a check-in/check-out application for my company. We have about 550-600 employees at any given time and our turnover is about 20-30% per year. Our check-in/check-out process requires our employees to personally visit between 30-40 areas in our company (personnel, safety, credentials, parking, insurance, etc) within the first month of employment. This is currently done manually and is a huge drain on labor, especially when check-in sheets are lost, misplaced or, in some cases, forged.
I'm looking to build a database that would be intranet based, password secure (by check-in area) that would allow the new employee to present at a particular check-in, check-out site, complete that portion of the check-in/out process and then allow the person responsible for the check-in/out to enter the status into the database. At any point in the process, I would want to know the status of the person checking in/out (how long they've been checking in/out and what portion of the process have they completed).
Can this be done in ACCESS?
Thanks
Hi
I have sendkey "{f7}" on loss focus.
this works great as a spell check but then I get the mesage box that spell check is complete.
How do I stop this box from occuring?
Hi,
I have a list of four options and i want the user to be only able to click one option and not have multiple options ticked, so once one option is clicked the others cant be clicked whilst that one is clicked
in other words you have to untick your option to pick a differnt one
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 RelatedI made on option box on a form called Status. The 2 radio buttons are marked Open = 1 and Closed = 2. Is it possible to open a query based on what the user selects. In the query I want open to stand for Is Null and closed would be Is Not Null. I know this sounds unusual but it works in the query they way I want it to. Is this possible? Thanks...
View 2 Replies View RelatedI got an MS Access 2003 db which I think has an general option disbabled or so dnno, here's the case:
When I create a query, and choose to close the query (just be clicking the "X" button at the top), Access doesn't ask me to save the query or not.. it directly displays the box to fill in the name of the query
When I execute an action query, Access just executes it when I click "!" button, without asking me if I want to "deleting, updating, adding xx records"
I've been searching ages to find an option to enable but I can't seem to find anything
Can anybody help me?
Hi,
I have an existing desktop Access database for a Membership system which is working fine (+- 1000 members). We have an existing website that is also working fine and developed using Frontpage 2003 - due for conversion to Expression Web.
Challenge:
We want to offer a facility for members to update their details online via the website. That's the easy part - my query is how do I manage to synchronise both the desktop and the website DB? Replication seems to have disappeared with Access 2003.
New members would be added locally whereas updates would be handled either locally or remotely.
Any ideas very welcome.
Regards
Tony Randell
Say I have two bubbles (options,buttons, whatever you know them as) I want the system to be set up so that only one of the two can be "true" at a time. Say they are titled Option1, and Option2. What code would I put on them so only one can be "true" at a time. If Option1 was true, and then someone clicked on option2, I want it to cause option 1 to go false.
Any help would be greatly appriciated. THANK!
Hi Everyone,
I have a message box that says "Backup complete" but it has an Ok button. Is there a way for the user to see the message and then close without hitting the ok button?
here's my code
MsgBox "Backup was successful and saved", vbInformation, "Backup Completed"
Thank you
I have a table called students and one attribute is called Ethniticity and have a text datatype.......I'm setting up a form to add a new student.... for the Ethniticity part I set up a set of combo boxes ---- African American, White, Hispanic, Native American, Asian, Multicultural, Other: ---- beside the "other" option there's a text field where the user can type in their own answer. I want the text for the option selected to be placed in on the student table in the ethniticity field and if the "other" selection is selected the text in the textfield will be placed on the students table........................how could i get this to work???? any help would be appreciated
View 1 Replies View RelatedAt present I have a form which is used to select a date range then using one of three buttons I can select one of three reports. I want to use an Option Group with three options to replace the three buttons. I have fiddled around using three separate Option Buttons and they work ok but in my opinion they are not the way to go. I need some assistance with the code as the Option Group is slightly different to the Option Buttons.
View 5 Replies View RelatedHello...
I am a newie to the forum... but like the system.
I was wondering if anyone can provide either some tips or sample of how to set up a form that give you the option of linking it to one of two forms.
Say the Main Form = General Plant Description
Sub Form One is for Info on Tractors
Sub Form Two is for Info on Trucks.
On the main form you select an option to show one of the subforms.
I have spent about 1.5 hrs trying to search the forum and so far havent found specific advice on this issue.
Thanks in advance.
Dave P
Hello,
Still trying to figure things out with this software. Never have messed with it much. The question that I have is this. We have about 9 forms that we will be filling out. I was originally going to have it to where you swapped between the forms in order to put the data in that we needed but was wondering if its possible to create 1 single form. Have a Mult Option box in place and depending on how that box is checked will depend on where the data is going to be stored. Is this possible? As I have said i'm new so forgive me for not knowing a whole lot.
Thanks
Hello...
Here is what i have, a database with names, addresses and all sorts of information.
I have made an answer query that the report form is based off of with all the fields needed. The fields will not change from here on out.
I also have a form, which I have successfully bring up the report.
(big step for me, newbie here )
So, now, new queries will have to be made from the form, which is where I get lost.
Sometimes it will need to be filter based on zip code, mostly thats what it will be, but I have to have the option of doing it other ways.
whats the best way to go about this?
pleaes be specific as im new to this kind of thing.
Martin