Solved

MS Access Form field directions

Posted on 2014-10-22
3
225 Views
Last Modified: 2014-11-01
I have created a form in Microsoft Access 2013.  I want to make sure the fields are uniform when filled in by different users.  I would like to have directions for each form field - I am envisioning a pop up box with directions for each form field and how it should be filled out.  Can you please help me either create a popup box that appears when I click on a form field, or in the alternative, if you have another way to give users directions about how to fill out the box, I am open to that too.  thanks!
0
Comment
Question by:Lisa Haba
  • 2
3 Comments
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 40398044
A popup might work, or possibly a messagbox somewhere on the form, or even the tooltip property of the control.

The tooltip property is probably the easiest, but require that the user mouseover the control, and will not popup if you simply tab into or click into a control.

Best method I've found for this type of thing is to create a table (tbl_Control_Tips) and populate that table with fields [FormName], [ControlName], and [Tip].  Then I would create a form based on this table.  Finally, I would create a help button on the form (automatically displaying the help would be annoying for experienced users).  The code behind the help button might look something (untested) like:
Private Sub cmd_Help_Click

    Dim strCriteria as string

    strCriteria = "[FormName] = '" & me.Name & "' AND " _
                & "[ControlName] = '" & screen.previouscontrol.name & "'"
    if DCount("*", "tbl_Control_Tips", strCriteria) > 0 Then

        Docmd.openform "frm_Control_Tips", ,, strCriteria

    End If

End Sub

Open in new window

This would give your users the ability to get the help if they need it, but not annoy them if they don't.  You could also call this from the GotFocus event of each of the controls if you wanted to be annoying.

One more thing, you might want to consider adding a line in tbl_Control_Tips with FormName = 'None' and ControlName = 'None' and Tip of "no help available for this control".  Then, if the Dcount ( ) function above returns 0, you could set the criteria to:

"[FormName] = 'None' AND [ControlName] = 'None'"

and still popup the help box.
0
 
LVL 23

Accepted Solution

by:
Eirman earned 500 total points
ID: 40398171
You could keep it simple by placing a label beside each field that might need an explanation.
The label could be a simple   ?
Then create a tooltip for each label.
They won't bother experienced users, but are there for those who need them.

Some help with tootip timings etc ....
http://www.msaccesstips.com/2009/02/controltip-text-and-time-delay/
0
 
LVL 23

Expert Comment

by:Eirman
ID: 40417448
Thanks
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question