Search results

Thanks.

Solved. Thanks so much.

What do you mean with this?

Thanks. And what's the I have to put on main form?

Hello. I tell you my problem. I want, when clicking on the form button that you see in the image I attached, to check if the active field is the dropdown also marked in said image and obtain the value. What is the objective of this? I want to add a code in that button to update the pricing...

I don't know. The only thing I know that I don't get it work, but if I do in the way I show it works for me and that's so what I need

Done

Ok, I'll do it then, cause I'm busy now. Thanks

I do it in VBA. When I update the product name, I take the value of the entered text which appears to me as HTML. This string is what I search for the code using instr and mid, adding a previous if with instr in case the searched text does not exist: what I want to find is = and style on the...

I understand what you are saying, but I have tried every possible way, including the one you propose, and none of them worked for me. For that reason, I had to look for another alternative, and it is the one I indicated before. Thank you so much.

I have not used the function that you indicated, because it has not worked for me. If in HTML, for the color you have to write "color=#FFFF style", what I do is look for the position of = and style, and extract the color code with those two position values, which may give an error, which is why...

In the end I solved it another way. With the mid and instr functions I have searched for the characters that determine the color in html and I have extracted the string that represents the color of the text and the background, saving both values in the table. Since the color may not appear, I...

Ok, thanks. And now the question is: "how do i use it?", cause I need FromBase As Integer, _ ToBase As Integer but I don't know what I have to write there.

Hello. I have prepared an example of what I want to achieve. I have a long text field with rich formatting that, after updating, saves in some fields the color of the text and the background of the text that the user has given it. Well, I want to apply that color to a string that unites the...

Ok. Thanks

Ok, thanks. I will check it out!

Thanks to both. I think I'm going to stick with Mike's option. Although in essence it is similar to what majP proposed to me with the list boxes, it uses a subform and I don't need any code, just the table that connects the clinical record with the options table. Good night.

I have upload a copy. I have deleted the tables that we don't need now.

Thanks, this afternoon I saw that database of examples, which I had saved, but it didn't work for me and searching here in the forum I couldn't find it. I do not know how it works. For example, it does not save the selection to any table. Therefore, how do I know what data you have chosen in a...