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

...point objCalendarItems should be pointing to the \\iCloud folder Set curdb = CurrentDb strWhereCond = "SELECT * FROM Entertainment WHERE ReferenceNo = " & Me!ReferenceNo Set entertainmentRst = curdb.OpenRecordset(strWhereCond) Do While Not...

...objOutlook.ActiveExplorer.CurrentFolder = FoundFouder Else MsgBox "Folder: " & folderName & " Not Found", vbInformation End If '*** I have no idea how to get from the found folder to the creation of objCalendarItems. 'This next one should be fine, once we have the correct...

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

...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' Clicking on yes, Word then opens the document and throws the following error: Error has occurred: The Microsoft Access...

...Then .QueryDefs.Delete ("Contact_Select_Query") End If strContactSelect = "SELECT * FROM Contacts WHERE [Contacts].[ContactID] = " & Forms![Contacts Browse]!ContactID & ";" Set qdfNew = .CreateQueryDef("Contact_Select_Query"...

...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 object/methodology is?

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