Search results for query: *

strWhere displays as Left([Message], 29 + ii) = "Reference:\n Booking No: 1031.1" Throws the following error: Runtime error '440': Condition is not valid.

I have a module that will manipulate "appointments" in an Outlook calendar. The calendar entry has a reference number that is keyed to the Access database. Unfortunately, I cannot use a custom field to hold this reference number as there are other restrictions which prevent this. I have this...

I did try downgrading to Windows 10 but apparently there is a 10 day limit to this and it too late. A clean install would be a VERY last resort as there is A LOT of software to reload, some requiring third party configuration support. And yes, I believe that it is a Windows 11 upgrade bug, but...

Clarification ... It is not possible to run ANY programs as administrator. For example, select cmd from Search box and try to click on "Run as Administrator" ... nothing happens. For example, right click on any desktop icon ... nothing happens.

No, it is not possible to do. The account is already in the Administrators group. AND it is not possible to log into the Administrator accout. It was never created with a password and now it appears to want one.

I updated from Win 10 to Win 11 at the end of December and have since discovered that I have no administrator rights. This is a single desktop machine with no other users. There are only two accounts on the machine: administrator owner Neither have passwords. The last thing I checked/found...

My app has been running for years and all of a sudden my line of code to close and save a report has stopped working. I am running Office 365 on Windows 10. I have attached the relevant subroutine to this post. What do you think? Ron...

I run Microsoft Office 365 and have Outlook connected to iCloud in order to sync to several mobile devices. This is on a Windows 10 machine with 32GB RAM. I recently discovered some random entries had been duplicated and in each case one of the entries cannot be deleted; when trying to edit the...

Thank you for pointing out the trusted locations setting. After upgrading the computer, this application worked just fine so "something" created the trusted location issue, like an update causing the setting to change. Seems to be OK now.

Some time after upgrading to a new (and very fast i9) computer running Windows 10 and Office 365, my Access applications are VERY slow to start. It takes around 20 seconds to start the application directly BUT Access itself will start immediately. Opening any of the applications from there is...

I missed the typo error you mentioned, but I have made the change and reduced the code area to the following: Set objNameSpace = objOutlook.GetNamespace("MAPI") folderName = "iCloud" Set foundFolder = FindInFolders(objOutlook.Session.Folders, folderName) If Not foundFolder...

I have a CRM type of application that manages contracts for an entertainment business. One of the functions creates a calendar object in Outlook. This has been running just fine for a long time. I am trying to implement synchronization via iCloud to my phone and tablet. Unfortunately, this...

Thank you MajP. I'm not sure I get why the pointer would change, but that is for another time. The code you posted, however, does not compile. It fails at dbname = db.name with the error "object required. What am I missing?

As you said, Duane, that REALLY doesn't answer the question. Nor does it explain what Word is doing with the query.

Same error and Word opens two versions of the document (one is the full screen reading view).

The message reads: Error has occurred: The Microsoft Access database engine cannot find the input table or query 'ontact_Select_Quer' The leading 'C' and the trailing 'y' are BOTH missing. I'm runninng: Windows 7 Office 2010

Duane: Although changing the query property may be a better approach to setting the query parameter, this does nothing to solve the problem. When Word starts up, it presents the usual message: Opening this document will run the following SQL command: SELECT * FROM 'Contact_Select_Query'...

I have an application that has been performing a mail merge successfully for some time. I recently performed the following structural changes to the database: 1. I converted from .mdb to .accdb 2. Later I split the application and database to frontend/backend which reverted the types to .mdb In...

I am in the process of transitioning an Access application from version 2007 (running under Windows XP) to version 2010 running under Windows 7 (64-bit). I cannot find the mapi*.ocx object to include in the references. Does anyone know where to find the appropriate OCX or what the replacement...

I just added an iBook to our Windows network, and have just about everything up and running the way it should. The one missing piece is the printer which is connected to a print server. The OSX 10.3 install does not include a PPD for our ("mature") printer. During the configuration I...