Go to Top

Using control tip property to display real time information

I was selected to be a guest blogger on the official Microsoft Access blog! You can read the article here:

http://blogs.office.com/b/microsoft-access/archive/2011/11/28/display-real-time-information-with-the-controltip-property.aspx

ADVERTISING
ACCESS SAFETY AND TRAINING DATABASE

Please read and come back here for some final thoughts on the technique.

Another alternative: DAO

When I wrote the guest post I automatically selected ADODB since that’s what I use almost always in my code. Here’s the same concept using DAO:

 

Persistent Recordset

If you find yourself constantly opening and closing the recordset, you can choose to create a module level variable, move out the line 30-32 into form’s load or current event and not closing the recordset by commenting out line 160 above.  If you do go down this route then you would need to retrieve all related records in one trip. You also may want to open the recordset as a snapshot-type recordset to ensure the request is pulled only once. If it’s a lot of records in memory it may not be worth it.

After all these years I’m continually amazed at the capabilities of Access and how we can stretch the envelope of what can be done.

About Juan Soto

Juan Soto is a Senior Access Developer at IT Impact Inc. and a Microsoft Access MVP. He specializes in Access with SQL Server databases. His passion for Access has led him to helping a wide range of businesses in helping them establish a secure, stable and efficient environment with SQL Server. He’s a frequent speaker at Access user groups nationwide and recently spoke at the Orange County SQL Saturday # 73. If you wish to have Juan speak at your next group meeting you can contact him here.

Leave a Reply

Your email address will not be published. Required fields are marked *

 

Contact Us
[gravityform id="16" title="false" description="false"]