Access 2007 Multiple Control tip texts

[AlexanderBB]

My form view is set to continuous and I'd like a text box control tip text that could be unique for every record.

Is that possible ? Hopes !!!

I'm also wondedring is the delay before it shows is adjustable ?

Thanks.

 

[HiTechCoach]

Thanks for the info.

I thought that sounded like one of Stephen Lebans examples. He has some great examples but most were design to work with Access 2003 and older. Some of the things his example help you do in the older version are now built into Access 2007 or later. There are still some example that do have cool functionality that still do not exist in Access. Unfortunately some need some work to convert to a accdb.

 

[AlexanderBB]

Yes I wish I had some of his expertise!
Did you make any further progress? I've spent the last couple of days trying to modify his routine
to output not just the row number, but also the column number (or name). Not succeeded yet.
I do have a small textbox overlaid on colums where comments are, and my thinking is the x.y. coordinates
could detect that and open/close a popup form showing them.

 

[AlexanderBB]

HiTechCouch, I struck a snag... thought I could use the change event of his Me.txtCurrentRowDat
to open/close a popup form. But I cannot, the change event is not triggered. Can you suggest any way around that please ?

 

[HiTechCoach]

What you are wanting to do is more difficult than even advanced VBA coding. That is probably why no one has figured out how to do it with the standard Access controls. If they hae they are not willing to share for free.

Did you also look at the is example that working in Access 2003 and older: ToolTip

With Aces 2007 and newer their were lots of changes to allow themes. This has really change they way we can interact with how things are display. Stuff that worked in Access 203 and prior just do not work in the newer versions.

I am still working on a way to do what you want. I think it would be a good thing for the users.

 

[AlexanderBB]

A couple of us have been trying various things with Stephen Lebans code, but far from anything concrete, and from what you say, may never succeed.
Anything you come up with will be very much appreciated by all the folk in our group.
Haven't as yet looked at the 2003 ToolTip but will do as soon as I have 2003 running. Obviously that wouldn't convert to 2007 ?\
Regards, ABB

 

[HiTechCoach]

Stephen Lebans' Tool Tip example does exactly what you want but works in Access 2003 and older.

 

[AlexanderBB]

Hi, I opened A2kTooltipver34.mdb in Access 2007 expecting it to offer to convert it, and maybe not work, but it just worked as is. I didn't expect that!
I changed frmCustomerDatasheet to continuous view mode (which we want to use) and found it still worked.
I have not yet looked at how or if this could be incorporated into our database. Or should I wait and see what you are designing ?
With this do you know offhand if the delay before it shows can be shortened. And if forecolours and font attributes can be used?
In Excel we used a mix of forecolour and a Bolded first row, and would like to keep that.
Regards, ABB

 

[AlexanderBB]

Oops apologies... just read Enhanced features include: and found all the answers.

 

[HiTechCoach]

If you can get it to work, go for it. Don;t wait on me. I am curious to see you you can figure out with the example.

Were you able top get it to converted to a .accdb and still work?

 

[AlexanderBB]

Were you able top get it to converted to a .accdb and still work?

I expected Access 2007 to offer to convert it, it just accepted it and kept the .mdb extension.
So my thinking was to copy or import the required components.
Yes, figuring it all out may be beyond me, but going to try.