823 questions with Access Development tags

Sort by: Updated
Updated Created Answers
0 answers

LINKEDIN ERROR: STATUS 403 Api Organization version: 202310

I am working to get data from public pages with Api "Organization" with the last version (202310), but I always get status 403, "Not enough permissions to access" eventhough I got the specific scope for this request. If I switch to…

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
823 questions
asked 2023-10-31T15:03:04.9633333+00:00
Juan Carranza 0 Reputation points
edited the question 2023-11-03T20:17:53.27+00:00
Juan Carranza 0 Reputation points
2 answers

Access shortcut

I used to be able to copy a field entry from the previous record in a table by Ctl '. It now no longer works. Is there now another way? Copying and pasting takes too many key strokes.

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
823 questions
Microsoft 365 Publishing
Microsoft 365 Publishing
Microsoft 365: Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line. Publishing: The process of preparing, producing, and releasing content for distribution or sale.
597 questions
asked 2023-10-16T11:21:18.06+00:00
Alan Green 0 Reputation points
commented 2023-10-31T23:07:38.8933333+00:00
Colin Riddington 85 Reputation points
2 answers

Access Europe meeting on Wed 4 Oct - The future of Access

The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central Europe and 10AM in Seattle / PST Please note that the UK…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
309 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
823 questions
asked 2023-09-26T13:03:20.97+00:00
Colin Riddington 85 Reputation points
answered 2023-10-10T20:22:03.4433333+00:00
Colin Riddington 85 Reputation points
1 answer One of the answers was accepted by the question author.

How to control the attachment mini toolbar in access

Hello, I just started to work with the attachment field in access, and noticed that the attachment mini toolbar is in auto hide mode, can I switch that to be allways visible, and reposition its place and control its size? Regards,

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
309 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
823 questions
asked 2023-09-26T06:29:59.4966667+00:00
Abdulrahman Althunayan 40 Reputation points
accepted 2023-10-04T04:59:18.59+00:00
Abdulrahman Althunayan 40 Reputation points
1 answer One of the answers was accepted by the question author.

Query on License

Hi All I am using Microsoft 365 E5 license, Is Microsoft Access part of this license. when i search in Volume licensing portal with the word access i dont find any product with this name. please guide me

Microsoft Exchange Online
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
309 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
823 questions
Microsoft Exchange Online Management
Microsoft Exchange Online Management
Microsoft Exchange Online: A Microsoft email and calendaring hosted service.Management: The act or process of organizing, handling, directing or controlling something.
4,199 questions
asked 2023-10-03T13:45:04.6833333+00:00
Rising Flight 3,751 Reputation points
accepted 2023-10-03T17:25:54.7433333+00:00
Rising Flight 3,751 Reputation points
1 answer

MSAccess Does Not Close Under Windows 11

I'm using the Access 2010 runtime for some applications I support. These applications run fine under Windows 10 but when I run them under Windows 11 the MSAccess executable still runs in the background when I quit the application using DoCmd.Quit. I've…

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
823 questions
asked 2022-05-10T22:13:04.713+00:00
Bill Bordiuk 1 Reputation point
commented 2023-09-25T10:17:48.0733333+00:00
Johan Welman 0 Reputation points
1 answer

Old Access 2002 runtime application will not run when virtualized.

I have a client that uses an old Access 2002 runtime application. It uses a split Access database system on a Windows 2003 server. The developer has long since gone out of business and they cannot get it recompiled. We tried to update to newer version of…

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,321 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
823 questions
asked 2023-09-20T14:06:45.3433333+00:00
Day Goree 0 Reputation points
commented 2023-09-21T17:22:21.69+00:00
Albert Kallal 4,806 Reputation points
1 answer

aceoledb.dll crash

My application opens 2 connections to 'accdb' files. Whenever I close the second connection I have an access violation in the aceoledb.dll (16.0.5320.1000). I don't see what could be wrong in my code. I use ATL and this should already ensure that I…

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
823 questions
asked 2023-09-17T14:56:54.9333333+00:00
Rudolf Meier 271 Reputation points
answered 2023-09-18T05:25:28.1966667+00:00
Tanay Prasad 2,105 Reputation points
1 answer

Problem exporting forms with DoCmd.TransferDatabase from an accde file.

Access 2021 Hello, In a database, from a button on a form, I create another database and export a table and a form to this new database. This functionality is in VBA code. In the accdb file everything works perfectly. I then create an accde file from the…

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
823 questions
asked 2023-09-15T08:02:45.37+00:00
jacky Perpète 41 Reputation points
answered 2023-09-16T04:50:06.7133333+00:00
jacky Perpète 41 Reputation points
3 answers

How can I add x amount of working days to a date?

Suppose I wanted to add 85 working days, meaning only the weekdays, to a field with an existing date, how could I do this? Same scenario, but also take into account holidays so don't count the holidays as a working day. How could I do this?

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
309 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,519 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
823 questions
asked 2023-09-12T18:15:40.18+00:00
Lopez, Ahiezer 216 Reputation points
edited an answer 2023-09-13T16:49:41.06+00:00
Ken Sheridan 2,666 Reputation points
1 answer

Have written the Code but Elseif statement is not working rest all working

Private Sub Convert_Rate_Unit_AfterUpdate() If [Convert_Rate_Unit] <> [Rate_per_Unit] Then [ConvertRate] = [Rate] / 1000 ElseIf Me.Convert_Rate_Unit.Value = "m2" And Me.Rate_per_Unit.Value = "kg" Then [ConvertRate] = [Rate] /…

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
823 questions
asked 2023-09-10T10:04:06.2566667+00:00
rd_sheth 0 Reputation points
answered 2023-09-10T20:48:23.7566667+00:00
xps350 376 Reputation points
0 answers

Access Europe meeting on Wed 6 Sept - Database Analyzer and other tools

The next Access Europe meeting will be on Wednesday 6 Sept 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central Europe and 10AM in Seattle / PST Please note that the…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
309 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
823 questions
asked 2023-09-02T10:07:35.0666667+00:00
Colin Riddington 85 Reputation points
commented 2023-09-10T17:56:37.56+00:00
Colin Riddington 85 Reputation points
1 answer

Different datatypes for ADO record count in Access 2013 and 365

Hello, is there a difference in the data type for the ADODB Record Count in Access? I have an Access database in which I define the variable into which I copy the value from the RecordCount as long under Access 2013. Under Access 365, however, I get…

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
823 questions
asked 2023-09-04T07:15:33.3333333+00:00
Hans Furmann 40 Reputation points
edited a comment 2023-09-10T17:26:44.87+00:00
Albert Kallal 4,806 Reputation points
4 answers One of the answers was accepted by the question author.

Runtime error 3061 too few parameters

I'm exporting data from a joined table in MS Access to an Excel spreadsheet. When I use a SQL query (without criteria), it works fine but when I try to put a criteria in the code i get the run time error message. The following is the SQL query code:…

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
823 questions
asked 2023-09-02T16:47:14.8633333+00:00
David McAfee 20 Reputation points
edited an answer 2023-09-08T13:42:46.03+00:00
David McAfee 20 Reputation points
0 answers

Seting up a "language for programms not supporting unicode" only partialy solved MS Access' "problem communicating with OLE server or ActiveX control"

While trying to migrate an Access 2003 mdb database to Access 2021, I got an error that there was a "problem communicating with OLE server or ActiveX control" After a web search I changed the "Language for programms not supporting…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
309 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
823 questions
asked 2023-03-26T11:41:14.0933333+00:00
George Soulis 5 Reputation points
commented 2023-09-08T13:15:03.6666667+00:00
Tony Alvertis 0 Reputation points
0 answers

Blocked Access 385 Editor for Ctrl-C, Ctrl.V code changes

Usually I pass some code from a Access 365 VBA app to another by Ctrl-C, Ctrl-V and now the editor does not accept the new code lines and remain blocked

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
823 questions
asked 2023-09-05T09:28:00.1966667+00:00
Rafael Dominguez de Gor 0 Reputation points
commented 2023-09-06T10:50:09.6+00:00
Viorel 112.5K Reputation points
1 answer One of the answers was accepted by the question author.

Signature validation of my access-token, Private-key?

Hello I want to know how to get the keys to verify the access token. I got the x5c from https://login.microsoftonline.com/{{tenantid}}/discovery/keys?appid={{app-id}} but if i put this key in jwt-decode function its failing. Do i need to do some…

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
823 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
19,606 questions
asked 2023-09-04T09:18:23.3766667+00:00
Akhtar Naved 20 Reputation points
accepted 2023-09-06T08:26:30.4366667+00:00
Akhtar Naved 20 Reputation points
1 answer

Connection String for Ms Access in ADF Linked Service

I have been trying to create MS Access Database Linked Service in Azure Data Factory. I have used the below formats for creating the MS Access linked services in Azure Data Factory: Provider=Microsoft.ACE.OLEDB.12.0;Data…

Azure Database Migration service
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,777 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,624 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
823 questions
asked 2022-11-07T04:37:13.36+00:00
Hemanath Goud Kandula 1 Reputation point
commented 2023-09-05T11:45:15.9866667+00:00
Muhammad Sohail Nawaz 0 Reputation points
1 answer

Hello Everyone, I am unable to figure out the difference between ComboBox LimitToList property and ShowOnlyRowSourceValues property in Microsoft Access.

I mean, Is it not true that only what's in the Row Source can be seen in the List? How can you make display something that's not in the Row Source? Thanks for your assistance in advance!

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
309 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
823 questions
asked 2023-08-24T01:02:04.94+00:00
Shreyas 0 Reputation points
commented 2023-08-26T16:48:06.0233333+00:00
Albert Kallal 4,806 Reputation points
0 answers

Access VBA SelStart Issue

I am using VBA to react to a "Mouse Down" event in an Access Form. This was the only way I could think of getting around this PROBLEM. I want to paste "plain" text in a RichTextBox (Entry). I place my cursor in the textbox then Right…

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
823 questions
asked 2023-08-24T07:12:20.0033333+00:00
Michael Storm-Levia 0 Reputation points