933 questions with Microsoft 365 and Office | Access | Development tags
Mishandling of outer joins with column = value conditions
I understand that potential Access bugs can be reported here, and an MVP will pass them to Microsoft if they are validated. I'd be grateful if someone could do that with this one please. There is a problem in Access 365 editing certain outer join queries…
Microsoft 365 and Office | Access | Development
accesing a remote table in access sql error 8000-4005
I using an excel macro to manipulate an access database, whith no change i start to get error 8000-4005, using an sql like SELECT * from [;DATABASE=C:\AdmData\Base\tempo.accdb;].tablename. microsolft support told me that in 64-bits access remote table…
Microsoft 365 and Office | Access | Development
How can I update to Office 365 Access Database Engine on a machine that has Office 365 already installed?
I develop an application that reads data from MS SQL Server and updates an MDB file I read that Office 2016 driver is no longer supported so I updated to Office 365 (…
Microsoft 365 and Office | Access | Development
ACEOLEDB.DLL from Microsoft 365 Apps crash with Exception code 0xc0000005
ACEOLEDB.DLL from Microsoft 365 Apps (at least versions 16.0.14228.20248, 16.0.14430.20006, 16.0.14701.20040 in "C:\Program Files\Microsoft Office\root\VFS\ProgramFilesCommonX64\Microsoft Shared\OFFICE16\") appear to cause an application crash…
Developer technologies | C++
Microsoft 365 and Office | Access | Development
GetObject WMI Bug in Access 2510 (Build 19328.20244)
Attempting to call GetObject("winmgmts://./root/cimv2") from the Form_Activate event handler when opening a form using a Hyperlink SubAddress fails with an automation error "Unspecified error". Opening/activating the same form using…
Microsoft 365 and Office | Access | Development
Microsoft Access form controls not updating after table changes
In Microsoft Access where updates I make to the underlying table aren’t being reflected in my bound form controls. I’ve already tried refreshing the form, rebuilding the record source, and even recreating the form from scratch, but some fields still show…
Microsoft 365 and Office | Access | Development
Search key was not found in any record Access 2016
weird Characters can not be deleted nor edited in access 2016
Microsoft 365 and Office | Access | Development
Update a year in a date field
hi i have a access db with a date field that hold data in the following format 02/10/2024 11:01:29 all i want to do is to be able on mass to update anything in the 24 year to 25, is there a way this could be done please? thanks in anticipation
Microsoft 365 and Office | Access | Development
Access Report Prints Form Instead — Seeking Insights from the Community
Hi everyone, I'm hoping someone here can shed light on a frustrating issue we've been facing with Microsoft Access. We have a database where users click a button on a form (labeled “Delivery Sheet”) to open a report in Print Preview mode. The report…
Microsoft 365 and Office | Access | Development
Ms access reading data from c# code is giving unspecified error
Hi team, Facing issue while reading data from ms access in one of our widows service. after restarting the vm , the issue is getting resolved. Thank you
Microsoft 365 and Office | Access | Development
Microsoft Access 2007 login button not working solution
How to create login form in Access 2007 step by step
Microsoft 365 and Office | Access | Development
How to sum column C and D if columns A = Starmer and B = Elected.
I have the following table. I need a way to a) aggregate elected position for each name b) aggregate non-elected position where it does not match the name c) a total of each one So for example Starmer wins. The Elected result should show 38. Non-Elected…
Microsoft 365 and Office | Access | Development
How-to get RichText from LongText AppendOnly ColumnHistory()?
Is there a workaround to get the HTML-ish RFT from ColumnHistory() of a LongText field set with RichText format and AppendOnly versioning? I'm not trying to defend AppendOnly vs better solutions. Or storing HTML-ish RTF in Access. Just asking if anybody…
Microsoft 365 and Office | Access | Development
Update Table Column with Sum of Two Numbers in Two Tables
I have ran into a brick wall trying to create an update query. I want to update the number stored in the column of a table with the sum of another number in the same table and another number in another table. Attached is the relationship between the…
Microsoft 365 and Office | Access | Development
Error in InStrRev with respect to VarType
The MS ACCES has problems with this statement: HAVING ((( 1 * InStrRev ([Query21].[Naam tegenrekening], "Broek")) = 13 )) It reports "Type Mismatch", yet VARTYPE on this expression reports type = 3 (long…
Microsoft 365 and Office | Access | Development
My MS Access can connect to Azure Synapse SQL Serverless Pool, but failed to obtain data.
I connect from local MS Access File to Azure Synapse SQL Serverless Pool. I can connect to the db, and select the table and its column, but failed after select the column and got the error above. And another error message said the process is occupied by…
Microsoft 365 and Office | Access | Development
Query to copy distinct records - no duplicates
I need to create a query to copy ONLY DISTINCT records to a new table where the old table has many duplicates? Should I set the query to copy only the First of each field? Also how do I insure that the new table accepts only distinct re records going…
Microsoft 365 and Office | Access | Development
Microsoft Access Database Engine(ACE OLE DB 12.0)
How can I download Microsoft Access Database Engine(ACE OLE DB 12.0)? And how can I equip it with my visual Studio 2022?
Microsoft 365 and Office | Access | Development
Can I change Azure SQL Server port 1433 to a different port (Connecting externally using MS Access ODBC)
Hi, Our IT has flagged port 1433 as being high risk and has requested that we change the way we connect our Access DB to our Azure SQL server. Currently we are connecting using the standard ODBC connection string. Any ideas or information would be…
Microsoft 365 and Office | Access | For business | Windows
Microsoft 365 and Office | Access | Development
Setting TabIndex Property in VBA No Longer Working After Recent MS Office Updates
September: After my PC installed recent MS Office updates (within the last two weeks), currently running Version 2508 Build 16.0.19127.20192 (32-bit), setting the TabIndex property is no longer behaving as expected. I have procedures, in MS Access forms,…