Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Is it possible to set up control tips using DLookup?

Posted on 2008-09-30
5
218 Views
Last Modified: 2013-11-28
H experts,

I would like to set up my control tip text as a dlookup as there are many buttons within my application that use the same text and I do not want to duplicate the work.

Any ideas?

Thanks.
Terry
0
Comment
Question by:TerenceHewett
  • 4
5 Comments
 
LVL 75
ID: 22606690
No can do.  It can only be a String expression, 255 characters max,

mx
0
 
LVL 75
ID: 22606700
If you put something like this:

=Dlookup("xx","yy")

it will simply display

=Dlookup("xx","yy")

mx
0
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 500 total points
ID: 22606725
However, you could I suppose set the Control Tip Text on the fly in the On Load event ... getting the text via a DLookup () ...

Like so:

Private Sub Form_Load()
    Me.Text1.ControlTipText = DLookup("SomeField", "SomeTable")
End Sub

mx
0
 

Author Comment

by:TerenceHewett
ID: 22606900
MX,  thanks very much.  I think your last post is exactly what I was looking for. Will try and then start a new post ifI still have issues.
Best regards,
Terry
0
 
LVL 75
ID: 22607030
you are welcome.

mx
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
On Key Down Access 2010 6 41
Insert Into syntax error 10 28
Send Meeting Request from Shared Mailbox 3 57
Access/Visual Basic Question 3 24
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
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 …

809 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