- 4
- 25 926
Try Catch Throw - Coding Tips and Hacks
Приєднався 9 лип 2017
MS Access Delete Event Procedure Examples
This video shows how to handle events related to deleting records in a Microsoft Access database.
Переглядів: 1 496
Відео
CSS Sibling Count Styling with Pseudo Selector Combos
Переглядів 1637 років тому
How to style elements in pure CSS based on sibling count. Lea Verou's original blog post - lea.verou.me/2011/01/styling-children-based-on-their-number-with-css3/ Code on CodePen - codepen.io/joeaugie/pen/VWJJob
CSS Calc Example Usage Walkthrough
Переглядів 8 тис.7 років тому
Code on codepen - codepen.io/joeaugie/pen/EXzNXG CSS Calc is a useful CSS value calculation operator when working with both fixed and variable dimensions in order to allow the browser to calculate the dimensions for you dynamically. This example explores using CSS Calc when working with flexbox when the flex children are a fixed width but the dimensional space in between them changes.
MS Access Highlight Row In Continuous Form
Переглядів 17 тис.7 років тому
This video shows how to highlight the current selected record row in a continuous form in Microsoft Access.
why if I save as .accde doesn't work? any idea?
This works great IF the field value is unique to one row. What if the data you're using is indexed using multiple fields?
thank you so much
This is awesome! Thank you. I use to teach this stuff. This would have been great to show my students. I am retired now due to a stroke and memory loss. I am getting back into this stuff just to exercise my brain and I am excited by this. Again, thank you.
Great tutorial. Am adding this functionality to all my forms. And it's powerful. Thanks
For people learning Access for the first time, you go far too quickly through what needs to be done. You make assumptions about the knowledge that people have. Every small detail should be explained. It's taking me a long time to figure this all out. When you know how to ride a bike it's tough to remember that some folks do not know how to. That is the perspective you should start from.
For starters where is your StateID field since I didn't see it displayed on the form? However, to keep the user from clicking in txtHighligher, you can set the Data/Locked property to Yes and TabStop to No. This will keep it from ever getting the focus. Also is the Me command not necessary when referring to a control on the current form? When I write code I can't get my control names to autolist without it. Please help me out with what you are showing at 5:15 & 7:50.
All my rows turn yellow, not just the selected. Any idea why?
StateID is not specified?
FWD from author comment: Hi... but below are the couple lines of code from this video. [txtCurrentRecordID] is the hidden field on the form that will hold the current record's [StateID]; which is then referenced by the conditional format we created on the [txtHighlighter] textbox. Hope that helps. Private Sub Form_Current() txtCurrentRecordID = StateID End Sub Private Sub txtHighlighter_Enter() StateName.SetFocus End Sub
@@richardnguyenduong Yes it is specified.
I set conditional formatting for the highlighter textbox, and give a field of continuous form equal to a specific value, then it works selectively as expected.
@@richardnguyenduong Yes I did all that, I followed the video step by step more then once, and still all my rows turn yellow.
Great
If you are consistent with content like this I am amazed that you dont have more subs. Seriously well put together man.
Super helpful! Thanks!
Could you please post the vba code, I can not see it. Thank you
Hi Emily, Sorry I saw this comment a week later... but below are the couple lines of code from this video. [txtCurrentRecordID] is the hidden field on the form that will hold the current record's [StateID]; which is then referenced by the conditional format we created on the [txtHighlighter] textbox. Hope that helps. Private Sub Form_Current() txtCurrentRecordID = StateID End Sub Private Sub txtHighlighter_Enter() StateName.SetFocus End Sub
Thank you for this little tutorial.
Thank you for this little tutorial. Simple and elegant. I used this with a bookmark when open a form and highlights the relevant data from a continuos subform.
thank you
Very useful and very clear explanation, Many Thanks~!
Nice Job! Very helpful. Microsoft Access UI super powerful and relatively easy to code. Can you imagine doing this in another programming language? Crazy. MS Access is at least 4x faster to implement an intuitive user interface design than any other programming language. However, when you need to scale, the platform becomes brittle. Google "microsoft access migration services Help4Access" for some case studies and videos how to migrate all or just a portion of MS Access functionality to other technologies.
For Microsoft it is much more profitable to sell technology stacks through network of partners (pay for SQL Server / IIS configuration, pay for Visual Studio, pay for expensive trainings) rather than simple self-service one-stop solution, that's why they killed FoxPro and not developing Access anymore.
thx so much
Thanks for the great video Jack. Good content, I'd like to see some more Access VBA videos. Good luck with it.
This worked perfectly! thank you!!
how to calculate the 104px ?
Child elements have 100px of width, and they have ones borders of 2px on each side. Then 100px+4px (The sum of each horizontal sides) = 104px