Build a Context-Sensitive Help System For Your Microsoft Access Databases

Sdílet
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.

Komentáře • 8

  • @Dr_Mel
    @Dr_Mel Před 2 lety

    I actually enjoy the little diversions into the the history of the systems you're describing. Good stuff.

  • @marianmalone8995
    @marianmalone8995 Před 3 lety

    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!

    • @599CD
      @599CD  Před 3 lety +1

      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

  • @mamunmuscatbd
    @mamunmuscatbd Před 3 lety

    Hellow Sir, I was build Laundry Management System, how can i send message from whatsapp with Customer name and Number just one click