Search results

Thanks Edgar, I actually just worked it out too and was coming back here to post my example. Dim edgeBrowser As Object Set edgeBrowser = Me.Controls("MyEdgeBrowserControl") Dim htmlTextboxValue As Variant htmlTextboxValue =...

Thank KitYama, I believe that only works with the older browser control. Unfortunately speech to text is only fast in the Edge browser control so I need to use that. .object is not available to the Edge browser control. ChatGPT is struggling to give me a solution that allows me to read the...

Hi Edgar, I'm referring to speech to text, not text to speech.

Hi Pat, my original post was about speech to text in a text box on an Access form - it is noticeably slower than in Word. In fact when I hit Win + H I got a popup saying it isn't supported, although it does work, albeit slowly. I then decided to try a html page in the Access Edge browser ctl...

I added a web browser ctl to an access form, loaded a simple html page with a text box and shazam! Speech to Text is fast like in MS Word. Now I just need a way to transfer the text from the html page to the textbox on my Access form.

In MS Word (365) there is an icon on the ribbon for speech to text. It works quite well and the transcription is fast. If you press the Windows Key + H in MS Access, the same speech to text microphone widget pops up and your speech will be transcribed to text, for example in a text box. Does...

I solved it. In the CDO library I was using the .TextBody parameter. I changed this to .htmlBody and the link now formats correctly. Of course this means you need to format the entire body as html, not just the link. I would post the code but no matter how I try, I get a popup saying the post...

Thanks, but what I am talking about is creating an email msg in VBA that contains a hyperlink in the body of the email. As an eg, in the email the hyperlink should look like this Visit W3Schools.com! And when you click the hyperlink you would be taken to the url.

Yes it pastes verbatim which illustrates the issue. So referring to my original post, I am creating the hyperlink string in vba, then using it in the body of an email which I create via vba using the CDO library, and I get the same result as I do when pasting into a mail msg. Is there a way of...

Yes I have tried that. Try pasting the text in the attached image into a mail client to see what I mean. (I had to use an image as pasting the link into this post results in it getting blocked as spam)

I'm trying to format a hyperlink string in vba and then use the hyperlink in the body of the email msg I am creating using the CDO library. However the hyperlink displays as is, rather than just the text. The easiest way to test what I mean is to create a string in VBA that contains the url...

Today I have had 4 instances of the same application (running at different sites) not being able to auto connect to the backend (on network server). A compact and repair fixed the problem. In all cases the compact and repair process reported that the database was in an inconsistent state. So I...

Thanks, I'll have a look at export/import from text. In this instance I can't have one db for both bitness because of 32bit/64bit activex components that I require.

Perhaps I didn't explain myself clearly enough. My aim is to make the UI changes to the 32bit version. Then make a copy of this file which will become my 64bit version. But rather than spend time making changes to the 32bit code to make it 64bit compatible, I want to copy the code that I...

I have two Access dbs that are identical except for the bitness and 32bit vs 64bit API code. I want to make UI changes (only) to all of the forms - different font, larger font, increased field sizes etc. While a lot of these UI changes can be done with code, there's always manual adjustments...

I have a few ideas, but just wondering how others handle this situation. Dropdown recordsource is a query. The query returns tblCust.Firstname, tblCust.Lastname fields where the tblCust.Inactive field is false. 1 year ago a user had selected John Smith in this field on a form and saved the...

Thanks for the feedback everyone.

Not sure why you would suggest that. 1to1 or 1toMany depends on the design of the db.

Thanks for the feedback everyone. I just wanted confirmation that I wasn't using an incorrect approach, rather than verbosely explaining my exact situation. For clarity: Parent form opens a popup form. They have a 1to1 data relationship. If child record is found by link criteria, it is...

I've always been of the assumption that if you open a bound form (that allows additions) using linking criteria (eg DoCmd.OpenForm stDocName, , , stLinkCriteria) Access will: Display the matching record(s) if the linking criteria was found. or Move to a new record, ready for data entry, if no...