Microsoft Access Quick Queries #10. DB in Use, Max Records, Criteria for Different Data Types, More!

Welcome to another Quick Queries video brought to you by Access Learning Zone. I am your instructor, Richard Rost. Quick Queries videos are for me to answer your questions that may not need a whole video themselves. In today's video...
TOPICS:
Why I Repeat Stuff
Database is in Use on Compact
Tracking Salespeople for Outlets
Max Number of Records in a Table
Expand/Collapse SubDatasheets
Query Builder in the Form
Limit on Linked Backend Tables
Lookup Previous Record's Value
MySQL Data Limits
Replicate Autonumbers
DLookup Criteria for Different Data Types
Split Database Share Names
Show Field Value and Not ID
LEARN MORE:
599cd.com/QQ10
PREVIOUS QUICK QUERIES VIDEOS:
Quick Queries: 599cd.com/Quic...
LINKS
Why I Repeat Stuff: 599cd.com/WhyI...
Troubleshooter: 599cd.com/Trouble
Backup Access: 599cd.com/Backup
Relationships: 599cd.com/Rela...
Many-to-Many Relationships: 599cd.com/Many...
Association 1: 599cd.com/Assoc
Subdatasheets: 599cd.com/Subd...
DMax: 599cd.com/DMax
AutoNumbers: 599cd.com/Auto...
DLookup: 599cd.com/DLookup
Split Your Database: 599cd.com/Split
Invoicing: 599cd.com/Invo...
RECOMMENDED COURSES:
Relationships Seminar: 599cd.com/Rela...
BECOME A MEMBER:
KZbin: / @599cd
or My Site: 599cd.com/THMe...
COURSES:
FREE Access Beginner Level 1: 599cd.com/Free1
$1 Access Level 2: 599cd.com/1Dollar
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...
ADDITIONAL RESOURCES:
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:
microsoft access, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, quick queries, qq
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[@kerrywsmyth]

Thank you for the solution explaining file path needing to be identical. We have ab ENORMOUS shared file for our shop at work. Everyone has access to all the shared files and its no problem, EXCEPT...If anyone tries to email or post a LINK to the file, some of us can get it but most cannot. I never knew until watching this video that the cause was that we all have different letters representing the network drive path. So the path is different for most users. This makes total sense now. All we need to do is get with out IT department to get everyone's drives to the same letter.

[@599CD]

Welcome

[@theelevatorSRT8]

F the comments. You do a great job presenting in your style. I realize you need feedback to grow, but you gotta be careful with these knuckleheads.

[@599CD]

Thanks

[@stephenbeswick2163]

Hi Richard excellent video steve b

[@599CD]

Thanks

[@luzkrg]

As always, great video 😊. How many users would you consider to be a healthy amount connected to a database on a network server? Thank you!

[@599CD]

This is a complex question to answer. I actually have a video coming out in this in the near future. Stay tuned.

[@luzkrg]

Looking forward to it, thank you! 🙂

[@katherandefy]

Hi also there are more ways to use the same technique or tool than just one. Showing other examples (for example) is a form of spaced repetition.

[@amelienoelle6969]

I agree! Sometimes example #1 and #2 don't quite click with me, and then example #3 is exactly what I need to finally understand. Not everyone will understand the same examples.

[@599CD]

Indeed

[@kerrywsmyth]

Keep teaching the same method and style you've been teaching please.

[@599CD]

Thanks

[@ronaldmodesett8579]

you can just click on the +, and data will drop down

[@599CD]

Sure

[@alanhill769]

Storing your files on the cloud or Dropbox, means storing your files on someone else's computer. I have all my files backed up on another computer and an external drive. I have never used the cloud (someone else's computer). I am old school. We are a dying breed I know.

[@599CD]

Yeah. I pretty much only use cloud drives for backups. If my house burns down at least my data is safe. :)