Search results

Sorry i ment rhe PK-primary key How do you set it? Is it an auto number?

What do you get when you try to use DoCmd.GoToRecord , , acNewRec ? do you get a no value record? an error ? How do you set your PF keys ?

can I use an update query similar to this? It won't work as it is now. UPDATE [Materials] SET [MaterialDescription] = Replace([MaterialDescription], '<FONT STYLE='BACKGROUND-COLOR:#FFFF00'>', '') Problem is the string I'm looking for is <FONT STYLE='BACKGROUND-COLOR:#FFFF00'> which include both...

Thank you can you please explain me this: sPattern = "<" & v & "[^><]*>|<." & v & "[^><]*>" How will it find the </font> ? also, can it deal the # that are part of the colors codes ? What is the Div tag ?

Thanks (y) My eyes :LOL:

I can't make it work :( Can't find what am I doing wrong here It won't crash nor raise an error, I just get no link working Here how it looks in the ribbon XML <hyperlink id="hlnkAbout1" getLabel="Ribbon_GetLabel" getTarget="Ribbon_GetTarget"/> Here are the functions Public Sub...

I want to customize a Hyperlink I already have in the BackStage part of the Ribbon. I use getLabel/setLabel, getStyle/setStyle.... to change things in VBA I'm trying to do the same with getTarget/setTarget to alter the target of an Hyperlink, with no success :(

Thanks, as you noticed there is still more text to be removed after the first <Font...... till the enclosure with > it can also be with Upper, Lower or mix characters. So how do I catch it to replace?

Hmmm... No There I asked about the right-click ribbon. I already managed to create my own ribbon as I like and limit the text formatting. What I need now is to remove the formatting from text and leave only the B, U and I ones.

How can I remove all Font Styles from a rich Text field in table. I want to leave only the <B>, <U> and <I> styles font styles will start with <Font.... > and end with </Font>

If I need to update only a field or two for a specific record in table. What method is better, faster, cleaner.... ? Open a recordset or use an Update query ?

I'm using VBA to download files from my domain (A Sub Domain) I'm getting an error that there is a problem with the secured channel. This will happen if I try to Download the file using HTTPS address but will not if I use unsecured HTTP addres The domain do have SSL, and I have no problem...

Just to clarify - I don't connect to outlook or use outlook in my App in any way. I do send mail using CDO

I have a problem that Outlook Express cause my Access App to hang :( Anyone else has this problem ? Just to clarify - I don't connect to outlook or use outlook in my App in any way. I do send mail using CDO

I'm trying to use the following code It will fail for the last 4 elements (Font colors and size). I guess they have wrong numbers. Where can I find the correct ones? I looked in here https://bettersolutions.com/vba/ribbon/face-ids-2003.htm Sub CreateRichTextShortcutMenu() Dim cmbRightClick...

It's not in the ribbon when you select a text in a RichText box it load a floating ribbon I want to replace (Or remove) this one

Thanks Will try I do use custom ribbons

It's a long text so I prefer it to be a Rich one

Thanks, I'll try will it hide the original RichText menu and the RightClick one ?

Is it possible to replace the ReachText toolbar for a field ? I want to create my own toolbar adding the Copy, Paste, Cut buttons and removing some of the text formatting existing in the default toolbar. I also want to disable the right click toolbar for this field