Solved

Is it possible to set up control tips using DLookup?

Posted on 2008-09-30
5
213 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 - Access MVP) 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
ODBC driver not showing up in access 2 43
view mode vs edit mode 17 46
Direct Mail software 4 42
Open CSV, modify and save as xls from Access 12 19
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Familiarize people with the process of utilizing SQL Server stored procedures 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 Micr…

947 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now