Interesting and well paced. I wish that passing the value to the database was covered, though. I realize that for an experienced Access-user it is probably obvious, but I'm just starting out unfortunately.
@seanmackenziedataengineering Жыл бұрын
Good question and thanks for the feedback. For option groups, you will open the properties of the Option Group and set the Control Source to the desired field of the table/query that the form is bound to. Some people will try to set the control source to the radio buttons instead, which will not work. If your form does not have a RecordSource, you can set it to a table in the Form's properties. Then it will be available to choose for the Option Group.
@ariesmahal2 жыл бұрын
Make video on continuous form multiple record enter with one button
@seanmackenziedataengineering2 жыл бұрын
Great suggestion, thanks!
@venkatyalamati32852 жыл бұрын
Thank you so much for the tutorial!!!
@seanmackenziedataengineering2 жыл бұрын
Glad it worked for you! Cheers
@jorgecollazos20042 жыл бұрын
Muchas gracias, excelente video.
@seanmackenziedataengineering2 жыл бұрын
Bienvenido!
@jdlv12503 жыл бұрын
Thank you for the video. How can we convert those numeric options to text? I have been trying with this after update coding but it’ does not work. Select Case Me! [frameX] Case 1 Me! [textValues] = “Green” Case 2 ......
@seanmackenziedataengineering3 жыл бұрын
Your example code looks good. If you put it in the "after update" event, it should work! Do you get an error? Also, make sure that you dropped the "options" radio buttons onto the frame as it turned black, when you hovered over it to drop the option on there.
@txujcihmoob882 жыл бұрын
How can I build to show the column of datasheet is the color after update, do not show the number but show the color instead
@seanmackenziedataengineering2 жыл бұрын
One trick you can use is to set the forecolor and backcolor of the cell to the same color. You can also use conditional formatting for this.
@txujcihmoob882 жыл бұрын
@@seanmackenziedataengineering Please could you make sample and show how it works
@kyleoliver8142 Жыл бұрын
Thanks for the vid info Sean, much appreciated. I am very new to MS Access. With all the "Yes" / "No" radio buttons on my form, is there a way to reflect the selected value of either "Yes" or "No" in the Access database cause when I select the "Yes" the database shows the number "1" but does not show "Yes"?
@seanmackenziedataengineering Жыл бұрын
Welcome to the world of Access! An option group will give you 1 for yes and 2 for no in this scenario. If you go to your table in design, click on the field, then Lookup. Set display values to Combo Box, then row source type to Value List and row source to 1;"Yes";2;"No" and column count = 2. It will still store 1 or 2 but is an easy way to see Yes or No when you look at the table. Optionally, try using a Checkbox for Yes/No
@kyleoliver8142 Жыл бұрын
@@seanmackenziedataengineering Thanks Sean, I got it!!
@seanmackenziedataengineering Жыл бұрын
@@kyleoliver8142 Nice!
@davidparry97012 жыл бұрын
I can get an option group to update the criteria in a query using your technique in this video. Great job in explaining. But I need to go one step further so that the query finds all options. If I leave the criteria field blank, then the query finds all options, but I can't figure out how to make it work so that all options or any one option is returned by the query. Any advise on how to tackle this? Warm regards and many thanks for your great videos.
@seanmackenziedataengineering2 жыл бұрын
Good question! For this you can make use of something like you see at 11:30, where you'll set your filter or querydef in the After Update event of the form. Something like: If IsNull(Me!ogrpMain) Then CurrentDb.QueryDefs("MyQuery").SQL = "Select * From MyTable" Else CurrentDb.QueryDefs("MyQuery").SQL = "Select * From MyTable Where MyField = " & Me!ogrpMain End If If you are actually filtering on the same form, you can set the Filter property: If IsNull(Me!ogrpMain) Then Me.Filter = "" Me.FilterOn = False Else Me.Filter = "MyField = " & Me!ogrpMain Me.FilterOn = True End If
@digvijaygujale94333 жыл бұрын
Awesome !!! Can you please create video on multithreadig. With CsV file.?
@seanmackenziedataengineering3 жыл бұрын
VBA subs/functions run only on a single thread, so this might be a challenge!
@digvijaygujale94333 жыл бұрын
@@seanmackenziedataengineering with Python i am asking for.
@seanmackenziedataengineering3 жыл бұрын
I see! Ok, this will be interesting.. I will add this topic to my list. Stay tuned!
@larrywelch93592 жыл бұрын
Good evening Sean; just started watching your video(s). I would like to know if you have a video that shows how a textbox (on a form, continuous form or subform) can grow/shrink (to only show the numbers of characters in the textbox). I know that a textbox on a Report will grow/shrink, depending on the number of characters in the textbox. I have found several VBA Code(s) that help but does not force the textbox to grow/shrink. Any help in this would be greatly appreciated.
@seanmackenziedataengineering2 жыл бұрын
That's a great idea for a video! I don't think I have ever seen this implemented, but I have seen several solutions that use multiple sizes of unbound text boxes with a condition; ie. Show txt1 if this many characters, txt2 if this many and so on. The CanGrow property on Reports sure is handy! Cheers
@johnw49833 жыл бұрын
How can you use the Tab key to move from one radio button to the next in an option group?
@seanmackenziedataengineering3 жыл бұрын
Good question! The normal behavior is to tab from another field onto the option group, use arrow keys to select, then tab off to the next field. I suppose you could program some radio buttons outside of a frame, so that you could tab between them as a selection, but that would take some coding.
@sajiidkhan61003 жыл бұрын
Many thanks and appreciate your time and wonderful mentoring session,I have question, how can I use toggle button more than time in one option group frame. What I say, I have x ,y and z with the same toggle button see example ,xy units(label) in table: feet or meter and have field in the same table (zunits) feet or meter . So, I need to toggle on the same unit for x,y and z(feet) but error pop up you couldn’t use the same value more than time.
@seanmackenziedataengineering3 жыл бұрын
Option groups are mutually exclusive and only allow one entry. You can use your toggle buttons outside of an option group for the effect you're looking for, or you could put selections in a multi-select listbox. Let me know how it goes!