Тёмный

Dynamic Forms with Big Buttons for Data Entry in Microsoft Access (Combo, List Box Replacement) 

Computer Learning Zone
Подписаться 237 тыс.
Просмотров 2,9 тыс.
50% 1

In this Microsoft Access tutorial, I will show you how to create dynamic forms with big buttons for data entry, replacing cascading combo and list boxes. We will also explore utilizing VBA code to enable button controls on the fly, ideal for touchscreen applications in environments like greasy workshops.
Adam from Fort Dodge, Iowa (a Platinum Member, Moderator, Badge Geek) asks: Have you covered creating button controls on the fly anywhere? Can Access even do that? I need to select the year, make, and model of a vehicle. I agree cascading combo boxes or list boxes would be so much simpler, but for the people that would be using this with tablets and touch screens, they are not as friendly as buttons I've found. Especially covered in grease. LOL.
BECOME A MEMBER:
RU-vid: / @599cd
or My Site: 599cd.com/THMe...
LEARN MORE:
Big Button Form: 599cd.com/BigB...
PREREQUISITES:
Intro to VBA: 599cd.com/Intr...
Vehicle Maintenance: 599cd.com/Vehicle
Cascading Combo Boxes: 599cd.com/Casc...
Custom MsgBox: 599cd.com/Cust...
TempVars: 599cd.com/Temp...
LINKS:
AutoNumbers: 599cd.com/Auto...
Nested Subforms: 599cd.com/Nest...
Synchronize Subforms: 599cd.com/Sync...
UP NEXT:
Big Button Form, Part 2: 599cd.com/BigB...
RECOMMENDED COURSES:
Access Developer Courses: 599cd.com/Deve...
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:
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, Dynamic form buttons, Microsoft Access big buttons, replace combo boxes, VBA dynamic form, cascading list boxes, touch screen data entry Access, vehicle data entry Access, grease-friendly buttons Access, Access form automation, programming forms VBA Access, creating button controls Access, TechHelp free database.
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.

Опубликовано:

 

8 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 11   
@fotiosfotinakis8359
@fotiosfotinakis8359 Месяц назад
You are our "barista", but for our programming inspirations. Thank you so much for caring & sharing!
@fotiosfotinakis8359
@fotiosfotinakis8359 Месяц назад
I just realised my comment of you being a barista is not that of you being just a servant! I meant to be stating how important and inspiring is your experience to us all!
@gregoryjeffries8475
@gregoryjeffries8475 Месяц назад
Love the ModelT reference. Also, very in tune with you on automating simple repetitive tasks, I tend towards making them single function modules.
@Shadow.Dragon
@Shadow.Dragon Месяц назад
This is going to be a great series! Thanks Richard!
@Nigel1writer
@Nigel1writer Месяц назад
Looking forward to this one. Presumably you could also have an "other" button that would link to a cascading entry form? Could you then add that to the buttons? And am i getting ahead of myself? 😊
@AdoptedAndy
@AdoptedAndy Месяц назад
Hello, I am starting to use access to print single line labels. Do you have any videos for overflow if I go over character limit to have the text start a new line?
@TEdu-kt2lw
@TEdu-kt2lw Месяц назад
Hey Richard, what's up? I'm Brazilian and I need to clear up some doubts and get some help with access, could you help me?
@DytliefMoller
@DytliefMoller Месяц назад
Thanks RIchard, I have learned so much from the beginner free course. Im thinking of making a living using Access to create all kinds of apps for small businesses and eventually quiiting my low pay job. In your many years developing access... Got any tips for pricing access work for a client(like a small lightweight POS system)? Any objections you faced many times? Are there any licensing considerations/constraints using MS access to make money?
@599CD
@599CD Месяц назад
See this page: 599cd.com/Advice. Good luck with your endeavors! Let me know how it goes.
@shadowmonkeyking5278
@shadowmonkeyking5278 Месяц назад
just so you know, to have a perfect paste into a table column, ask chatgpt to put the data into a plaintext box with each data line on top of each other, then simply click the copy button, go into the table and right click the the top of the column and select paste :)
@599CD
@599CD 26 дней назад
Yep. That works too.
Далее
Common Pivot Table Features People Miss (and you?)
12:45
Is Microsoft Access Still Viable in 2024?
21:19
Просмотров 41 тыс.
EASILY Make an Automated Data Entry Form in Excel
14:52