941 questions with Microsoft 365 and Office | Access | Development tags
Access App which Front-end intermittently fails to connect to shared back-end database
分割構成の Microsoft Access アプリ(各端末に ACCDE フロントエンド、ネットワーク共有に ACCDB バックエンド)を使用しています。一部のユーザーで「ファイルが使用中のため開けない」エラーや、フォーム表示の遅延・接続切断が断続的に発生します。 権限や構成に変更はなく、複数ユーザー同時利用時やネットワーク不安定時に発生しやすい状況です。 このような バックエンドのロックや接続不安定 をどのように切り分け・対処すべきでしょうか。
Microsoft 365 and Office | Access | Development
How to disable "tell me what you want to do" security flaw
How do I disable "tell me what you want to do" , it's a security flaw! I'm a small business , we work with charities. I have just discovered this flaw ( I know its been there for years but i never knew what it could do! ) which bypasses all…
Microsoft 365 and Office | Access | Development
Monaco editor is messing up Pass-through queries
I have documented some issues with the Monaco editor in the video linked below. I'm hoping to get the attention of the Access team. The editor should not format the SQL of pass-through queries without consent. The formatter is adding carriage…
Microsoft 365 and Office | Access | Development
i have a microsoft access for ,32 bit, need to update to 64 bit. i have added PtrSafe to the Declare statements , now the form will not open
i have a microsoft access form ,32 bit, need to update to 64 bit. i have added PtrSafe to the Declare statements , now the form will not open
Microsoft 365 and Office | Access | Development
IIF Function broken in Expression Builder for MS Access 2016 MSO 365
I have the same issue as mentioned here : https://learn.microsoft.com/en-us/answers/questions/4918053/iif-function-broken-in-expression-builder-for-ms-a Only my regional settings are okay, so I don't have the dot. issue but I can't make any IIf function…
Microsoft 365 and Office | Access | Development
Question dans access
Dans un formulaire access je veux introduire un nombre dans un champ non lié
Microsoft 365 and Office | Access | Development
How do I get Microsoft Access to quit blocking macros?
Access is stopping the macros I wrote under a different version and will no longer execute the macros.
Microsoft 365 and Office | Access | Development
how to convert access 97 database to access 365
No tool provided by Microsoft to convert old databases created in Access 97, 2000 to current version of Access. Access 365 not opening databases created in Access 97 or 2000. Is this kind of support Microsoft providing to existing customer ? We are…
Microsoft 365 and Office | Access | Development
How to make "Search As You Type" in MS Access continuous form
Hello everyone, I have this code which filters records in continuous form of MS Access when the user is typing, but the issue is that it does not accept the "Balck Space", meaning when I am trying to add "Space" it's removed…
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
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
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
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…