Search results

I know what you mean. I've seen it elsewhere, not sure where. But this works as it supposed to. I made something similar in Excel, as UserForm object colours cannot be set neither to HEX nor RGB value. In access I was not able to set the rectangle background colour directly from the recordset...

A bit old post, but had to do the same and the above does not seem to work properly. To go from '#00FF00' to Long ('65280') , this will do the trick: Private Function HEXtoRGB(strHexVal As String) As Long 'function converts HEX value to RGB value On Error GoTo ErrHndlr Dim strR As String...

Hi MajP, I finally had some time to play with the code. You were right, it is working, exactly as I wanted to. I set a new Form with 3 Labels on it and no issues. Now I just need to figure out why is it not working on my original Form. Thanks a lot.

Hi MajP, I tried your solution. Added mLabel.Caption = "qq" in Set TaskLabel under TaskLabel, to make sure it is running through it. And yes it is changing all Labels caption to qq but not assiging the _Click event. What is the purpose of cmdDemo_Click? As I can see from the code you still...

Hi isladogs, A mentioned code is just an example, not the actual purpose. The Form I have has 10 labels displaying, value (TaskID) in a Gantt Chart style. I want to capture the value of a clicked label to update the Form footer controls data source query, also change a caption in form footer...

Hello there, I've been looking for similar thing recently. Access is quite limited with embedded photos, especially if it is not a bitmap. What I would suggest is to store user photos on hard drive (shared folder with access for multiple users). Then on the side of the combo box create image...

Hello, I stumbled across the following problem. I have a Form with 3 Labels on it, created within Designer Mode. Let's call them Lbl1, Lbl2, Lbl3. Additionally, I created a class module "clsLbls" which code is: '>>>> Option Compare Database Option Explicit Public WithEvents lblTask As Label...