Microsoft Access Quick Queries #23: AutoHeight v CanGrow, Overlap ListBox, Language Options, More!
ฝัง
- เผยแพร่เมื่อ 7 ก.พ. 2025
- In this Microsoft Access Quick Queries #23, we'll cover a range of quick queries, including how to correct misconceptions about transparency in images, the benefits of using Access over other software solutions, mapping shared drives, and understanding the quirks of report properties. We'll also address practical questions around keyboard layouts in VBA, overlapping controls, and more.
TOPICS:
Transparent images in Access forms and reports
Mapping shared drives as trusted locations in Access
Auto height vs. can grow/shrink in Access reports
Overlapping controls in Access forms
Switching keyboard layout using VBA in Access
Finding extended cuts of videos on TH-cam
Access Database Cloud and user access
AI-generated voice options on TH-cam videos
Freezing columns in Access forms and tables
Option compare settings in VBA modules
Purpose of the instring function with comparison
Using Access vs. SQL Server
Copying query fields to a table in Access
Using status command to display info on forms
Enter parameter value error in Access
BECOME A MEMBER:
TH-cam: / @599cd
or My Site: 599cd.com/THMe...
LEARN MORE:
Quick Queries #23: 599cd.com/QQ23
PREREQUISITES:
Quick Queries Listing: 599cd.com/Quic...
Quick Queries #22: 599cd.com/QQ22
LINKS:
Access Developer Network: 599cd.com/Acce...
Auto Height vs Can Grow Shrink: 599cd.com/a?98173
Text Box Over a List Box: 599cd.com/a?97552
Access Database Cloud: 599cd.com/ADC
InStr Function: 599cd.com/InStr
Change Case: 599cd.com/Chan...
Append Query: 599cd.com/Append
Status Box: 599cd.com/Status
Enter Parameter Value: 599cd.com/EPV
UP NEXT:
Quick Queries #24: 599cd.com/QQ24
RECOMMENDED COURSES:
Access Developer Courses: 599cd.com/Deve...
Access Beginner 1: 599cd.com/ACB1
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Cont...
Order Entry & Invoicing: 599cd.com/Invo...
More Access Templates: 599cd.com/Acce...
DIAMOND SPONSORS:
More info on our Sponsors: 599cd.com/Diam...
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
How to Use Access in 30 Minutes: 599cd.com/30Mi...
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/Tech...
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.o...
products.offic...
microsoft.com/...
KEYWORDS:
TechHelp, Access 2016, Access 2019, Access 2021, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Quick Queries, Performance over VPN, Record Locking, Transparent Images in Reports, Custom Database Solutions, Shared Drive Mapping, Internet Domain Name Mapping, Auto Height Property, Can Grow Can Shrink Property, Overlaying Text Control, Activate Keyboard Layout VBA, Freezing Form Header, Access Database Cloud
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.
Richard, thank you for another great Quick Queries!
🖖
I really appreciate these summary videos
Thanks
love to be the part the access lover, i do try other databases but i dont know why access is like the first love. it makes me come back to it
You've tried other databases? Shame on you. Just kidding. Always good to see what's out there. Still can't beat Access on the desktop though.
@599CD I ve cheated on access 😔
Hi Richard, thank you very much for your bunch of interesting information. If you can explain what you can do with the combination of Pyton and SQL in comparison with MS-Access, I think, your followers can deal with similar comments. If your MS-Access is on drop box, is it unsafe?
A tip for your followers who are not native English. Yes, Richard is speaking English with an American accent. I think it is much more understandable than other not native English speaking persons (like from India etc.) But here is a tip to understand video's better. In You Tube you can set under titles and/or you can set the speed slower (or if Richard is making things nice, quicker). At the speed of 75% you can better understand what he is saying and follow what he is doing. The only disadvantage of subtitles is that English speaking teachers forget that the bottom of the screen is used by the subtitles! You can manipulate the size of the letters, the opacity of both the background and the subtitle letters. 😄
Indeed
Hi Richard thank you for all the years video this year,merry Christmas and new year for you and family. Excellent videos. Would please make a video about creating passwords database so companies deal with to help them out I would be very grateful they keep asking me I help them free of charge. All the best steve b
Happy holidays
I have never seen anything here, will there ever be coverage for dataverse and PowerApps which is supposed to work with Access?
Probably eventually.
Hi Richard. WIth freezing columns, Access allows continuous form column freezing ( of a kind ). Right-Click the column header and select Freeze Column. It does this though by placing the frozen column to the extreme left AND when Unfrozen it doesn't move the column to the orginal position.....so not very useful...
Yeah, but only in datasheet view, which I never use. I mention this around 15:00.
Append or update depending on the action required.
Indeed
18:24. Maybe he's already listening to one of the AI generated voiceovers and that's why you "have an accent..." 🙂
I didn't think of that. Quite possible.
No disrespect but you sound like American lol. Also, love the IDE😊
No disrespect taken. I am American. :)
Please don't tell me this is the first time ChatGPT has apologized and said you were right in the first place. It does that all the time, and even then you still can't trust that its agreement with you is correct.
Definitely not the first time. LOL