How to suppress a dialog box, shown below
Office 365. Have a word doc that is merged to a query in access, using the command: MergeSingleWord "C:\Users\nevadamax\OneDrive\Documents\BudgetCorp\NewBudgetCorpDocs", True Where MergeSingleWord is a procedure: Public Function…
How do list results of a column in a table in one field separated by commas in MS Access
I would like to know how to get a column into a query field. Similar to how in Access if you use the multi-value field in MS Access. However, i do not wish to use the mutli-value. For example, if I had a table column1 with A C D F G (one…
I am trying to fill up fields on a document in word from my access database and I keep getting errors. I have added an image that shows me an invalid merge field. Kindly assist, as this is quite urgent ans important. Any help is appreciated. Thanks!
I am trying to fill up fields on a document in word from my access database and I keep getting errors. I have added an image that shows me an invalid merge field. Kindly assist, as this is quite urgent ans important. Any help is appreciated. Thanks! I…
What can I do if there is no answear after submitting the verification form? How can I get back my account?
My hotmail account is blocked by Microsoft. I have submited the form for verification. It was promised that the result will arrive to my contact e-mail account in 24 hrs. It was 3 days ago, but no answer. What can I do if there is no answear after…
Column Designation error
I have a list box (ERPNewOrderList) on a form (AddNewOrders). The rowsource for the list box is a query: Column(0): SONo: [SalesOrderID] & "." & [SOLineNbr] where [SalesOrderID] datatype is ShortText and [SOLineNbr] datatype is Number…
Error Message: Grant Access - Additional Permissions are needed to access the following file
The last update of Microsoft 365 has screwed up my computer and I cannot access the files that I have created with Word. Please help! I am using version 16:89.1 of Office.
How do I fix the OLE Object in Access Error 3118?
Cannot join on Memo or OLE Object <name>. (Error 3118)
Access error "This database is in an unrecognized format"
When open a Access file, get the error "This database is in an unrecognized format". Can anybody help?
graph.microsoft.com api to raise group access request that can though myaccess.microsoft.com approval process
I want to use myaccess.microsoft.com programmatically. but it do't have apis, it say that i can use graph.microsoft.com api . but when i am using graph.microsoft.com api , it give below error. i want to use graph.microsoft.com api to raise group access…
How do I close orphan database connections?
The last step in my Access application (before DoCmd.Quit) is to close the connection to the backend database on the network drive, as follows: This has always worked until one of the workstations was upgraded to Windows 11. Now when that workstation…
MS Access 2021 not reading DSN Entries from 32 bit ODBC
I have created a few DSN using the 32-bit ODBC app located in C:\Windows\SysWOW64\odbcad32.exe Now I open a new MS Access 2021 file and intend to link database tables using the ODBC DSN. However, when I use the Menu Options New Data Source->ODBC Data…
Within Microsoft Access 2019 is there a way to see or script out all Tables definitions keys/constraints/indexes, etc...?
Hello, within Microsoft Access 2019 is there a way to see or script out all Tables definitions keys/constraints/indexes, etc...? Was given an Access DB and need to migrate and need to know if they are all simple straight forward stand alone Tables or if…
Cannot Access Admin Account
Hi I have an Organization and an Admin account here. I just pick up my wife from School and when I got back. I have logged out to my Admin account but the users I created using that account are still accessible. Please let me know how can I get back…
Importar datos - Opción desaparecida de Excel y Outlook - Microsoft Office Profesional Plus 2019
Hasta ahora no me había percatado que en OUTLOOK ha desaparecido la opción de IMPORTAR DE OTROS PROGRAMAS O ARCHIVO, los archivos de ACCESS y en EXCEL ha no está la opción de OBTENER DATOS desde un documento PDF
MS ACCESS 2021
/ functions in MS Access Filed properties in tables and most useful / important features
showing coonection string window
how can i connect MS Access database file, why i am getting this type of window while adding data base connection. there is no browse button to connect my file.
there is no browse button to link the data base file
why i am getting this window while adding MS access database file, there is no browse button to link the data base file, please help.
index or primary key cannot contain a null value!
Hi, I'm just trying to update a previous table from a query and I'm getting the above mentioned error. What should I do? Best, Nash
Error - Requested session access is denied
I'm having trouble logging into my virtual machine using an authorized local user account with all the necessary permissions. I keep receiving the error message "The requested session access is denied". However, I am able to log in successfully…
Clear History Problem in east asia countiries when they want to login in the application
Hello, We have offices in Copenhagen and several Asian countries, including China, Hong Kong, Indonesia, and Thailand. We are using a West Europe server in Azure, and our users in Europe can log in and work with our application without any issues.…