Search results

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'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...

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...

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...

Wondering if anyone has a solution to the following scenario. Multi-user access app running in a Windows corporate environment. App on PCs, Db on server. The app uses images that are stored on the server file system. The db stores the path to the images. Permission to use the app is via AD...

Let's say we have a typical Access application setup - Access front end on PCs and back end on a network file server. Assume the app has 100 queries used on various forms (as the form recordset, for listboxes, combos etc). Queries are also used as recordsets for reports. When migrating an...

When I deploy my Access apps to client PC's I like them to look like I designed them. There is an Access property "use windows themed controls on forms". In my opinion this can make radio buttons (particularly) and check boxes look better. I've done some testing and while not drastic I am...

I'm in the process of converting a 32bit accdb front end to 64bit accdb. In my dev environment the backend (mdb) was copied from a 32bit environment and I haven't done anything to convert it to 64bit (such as save-as). So far I haven't encountered any issues with the 64bit front end interacting...

Many of us know that the later versions of Access have an issue displaying jpg images in print preview mode... image quality is terrible. In my case the images are on the file system and just referenced by path. I know there is an Access property to convert all images to bmp on the fly and...

Hi, I have a number of Office 365 32bit Access apps that are used all day, every day in commercial environments. Accde front end on user PCs Mdb backend hosted on server. Heavily coded including Win APIs. 3 x 3rd party ActiveX components. I'm happy to say that these apps have been incredibly...

Hi, Looking for recommendations for a 64bit imaging activex component for use in my 64bit Access app. I've used a 32bit component called ImageX in my 32bit apps and it did everything I needed but alas the provider has gone AWOL and no longer lists this product in 32bit or 64bit options. I...