Build a Context-Sensitive Help System For Your Microsoft Access Databases
Vložit
- čas přidán 26. 07. 2024
- In this video, I will show you how to create a context-sensitive help system for your Microsoft Access database. No messing around with HLP files. You can build the whole thing right inside your database using a table and a form. Or, if you prefer, I'll show you how to launch a web page so you can keep your help files online.
Rick from Houston, Texas (a Platinum Member) asks: Can you create context sensitive help in Microsoft Access forms and/or reports? Something like clicking a field and hitting F1 to get a description or use for field.
BONUS FOR CHANNEL MEMBERS:
Silver Members and up get access to an Extended Cut of this video. I will show you how to trap the F1 key so that you can utilize that keyboard event. Then I'll show you how to determine what the active form and active control are so you don't have to include an ID each time you open the Help form.
MEMBERS ONLY VIDEO:
• Build a Context-Sensit...
BECOME A MEMBER:
/ @599cd
LEARN MORE:
599cd.com/HelpSystem
LINKS:
Microsoft's Guidelines for Help: tinyurl.com/y3phvbgt
Forms Keep Their Size: 599cd.com/AutoResize
Intro to VBA: 599cd.com/IntroVBA
Key Down Event: 599cd.com/TechHelpMoveKeys
DLookup: 599cd.com/DLookup
NZ Function: 599cd.com/NZ
Double Double Quotes: 599cd.com/DoubleDouble
LEARN MORE:
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 Customer Template: 599cd.com/Blank
Contact Management: 599cd.com/Contacts
Order Entry & Invoicing: 599cd.com/Invoicing
More Access Templates: 599cd.com/AccessTemplates
ADDITIONAL RESOURCES:
Get on my Mailing List: 599cd.com/YTML
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/Consulting
Twitter: / learningaccess
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
microsoft.com/en-us/microsoft...
Email Me: amicron@gmail.com
KEYWORDS:
microsoft access, ms access, #msaccess, #microsoftaccess, help file, help system, context-sensitive help file, chm file, hhp file, hlp file, F1 help, control tip text, status bar text, controltip, statusbar, hyperlink address, key preview, key down, keydown, screen.activeform, activecontrol, active control, active form, current form, current field
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
I actually enjoy the little diversions into the the history of the systems you're describing. Good stuff.
Thanks
I built a database for a dentist that needed training materials linked to documents on his network. A lot of fun. He also wanted to know who had read each document so there was an email link where they sent a simple email letting the Dr. know who had read what document. It was my 1st professional database. I got $500 for the database. That was way back in 2000!
Nice! Well done. I'm actually building a document management solution into my ABCD database right now. People always want to stuff documents and images INSIDE a database. No! Keep them on the server in a folder and store the LOCATIONS of those files in the database. 599cd.com/ABCD
Hellow Sir, I was build Laundry Management System, how can i send message from whatsapp with Customer name and Number just one click
No clue