Quick Queries #1 - Text Box Row Source, More

Welcome to the first ever Microsoft Access TechHelp Quick Queries video. I get hundreds of emails, comments, and forum posts every week. Obviously I don’t have enough time to turn them all into full TechHelp videos, but I want to do my best to help as many people as possible. So, I’ll be putting together Quick Queries videos from time to time to give short answers to quick questions. Most of these are variations on topics that I’ve already covered in other lessons, whether from my paid courses or other TechHelp videos. So think of this as doing my best to point you in the right direction.

Queries

QQ: Is it possible to add a "row source" to a "textbox" in design view of a form? – Vivek from India

QQ: The database that I am "trying" to build is for a small electronics repair business. When making tables, would it in your opinion be best to make a table for each type of component? Transistor, resistor, capacitor, diode, IC, etc. – Cliff from USA

QQ: Is it possible to convert an "Estimate" form into an "Invoice" form, from the Estimate form? I think she's going to blow Captain! – Cliff from USA also Carl from UK

QQ: DVD's to purchase. I don't know if you have this service or are planning to offer it. Just a suggestion to think about. – Dave from Thailand

QQ: I have downloaded your Customer Database Template that has family member size, how would I be able to add the other family member's names, ages & gender to the form?– Jennifer from USA

QQ: What I am looking for is a link on your website where I could type in for example "Combo Box" and it would list all the courses in which that subject was covered. As I am now starting to program, I could desperately use this as a reference tool.– Wesley from Texas

QQ: I want to make a database to track personnel in my organization. I need to track the assignment of employees, their previous office, current office, and when they were reassigned. – Dennis from Philippines

QQ: I am using access to replace a commercial home finance program. One function I am having a tough time with is split transaction. Say I pay $500 on my car loan. I would like the register to show $500 but allocate some to the principle and some to the interest. Thank you for your time. – Kenneth from USA

Links

• Access Beginner 8: https://599cd.com/ACB8
• Access Expert 1: https://599cd.com/ACX1
• Access Expert 10: https://599cd.com/ACX10
• Access Developer 24: https://599cd.com/ACD24
• Invoicing: https://599cd.com/Invoicing
• Search Form: https://599cd.com/Search
• Access Index: https://599cd.com/AI
• Self Join: https://599cd.com/SelfJoin
• Geneaology: https://599cd.com/Genealogy
• DMax: https://599cd.com/DMax
• Relationships: https://599cd.com/Relationships
• Subforms: https://599cd.com/Subforms
• Amortization: https://599cd.com/Amort
• Form Footer Totals: https://599cd.com/FormFooterTotals

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

microsoft access, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, quick queries, row source, text box, quotation, invoice, estimate, dvd, cd, shipping, relatives, family members, search form, combo box, office assignments, employee tracking, split transactions, amortization, interest, principle