809 questions with Access Development tags

Sort by: Updated
1 answer

How do I change validation rules in Access when I can't find the original table?

Please excuse my ignorance...I have not had the need for Access for five years. I have a data input table that was designed to make it easy for data entry, with form view, design view, and datasheet view. When entered, the data can be seen in the Data…

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.
809 questions
asked 2024-03-16T23:00:02.1833333+00:00
Dan Boyle 0 Reputation points
answered 2024-03-27T12:53:19.9166667+00:00
Ken Sheridan 2,666 Reputation points
0 answers

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former Access MVP, Dale Fye who will be discussing working with…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
289 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.
809 questions
asked 2024-03-26T09:27:15.27+00:00
Colin Riddington 146 Reputation points MVP
edited the question 2024-03-26T09:37:32.8933333+00:00
Colin Riddington 146 Reputation points MVP
1 answer

Microsoft Teams chat

Hello, I have one question for you. I don't know that is work or not But i just want to know. Now we created the teams chat group and add the all office department members for IT Help Desk issues. At that time, one of member from marketing dept(eg:) send…

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
3,596 questions
Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
8,903 questions
Microsoft Deployment Toolkit
Microsoft Deployment Toolkit
A collection of Microsoft tools and documentation for automating desktop and server deployment. Previously known as Microsoft Solution Accelerator for Business Desktop Deployment (BDD).
812 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.
809 questions
Microsoft Teams Phone
Microsoft Teams Phone
Teams Phone enables call-control and Private Branch Exchange (PBX) capabilities in the Microsoft 365 cloud with Microsoft Teams.
108 questions
asked 2024-03-15T07:10:29.1133333+00:00
IT Support 266 Reputation points
commented 2024-03-22T02:45:40.5766667+00:00
LiweiTian-MSFT 12,930 Reputation points Microsoft Vendor
2 answers

how to format ms access dates with odbc data source

M365 Access App FE on PC win 11 - SQL Server Express back end on server. Can't format dates in form txt controls bound to appropriate date field from BE.

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,477 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.
809 questions
asked 2024-03-20T14:07:09.7366667+00:00
Nick Coe 0 Reputation points
answered 2024-03-21T18:09:10.0133333+00:00
Albert Kallal 4,566 Reputation points
0 answers

Why am I receiving this Error - Records in table <name> would have no record on the 'one' side.

All of a sudden my Access Query is giving me the error - Records in table <name> would have no record on the 'one' side. Works on my Laptop doesn't work on Clients Laptop!

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.
809 questions
asked 2024-03-18T04:49:35.5033333+00:00
John Fields 0 Reputation points
edited a comment 2024-03-19T20:53:12.0133333+00:00
Viorel 110.7K Reputation points
1 answer

How can we automate snipping tools through VBA?

Hi everyone! Im trying to automate the Sniping Tool Windows 11 and to use his OCR feature. Somebody knows how can I get it?

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,395 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,399 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.
809 questions
asked 2024-03-18T11:03:35.4366667+00:00
Alessandro Pereira 0 Reputation points
answered 2024-03-19T15:46:19.4466667+00:00
Claudia Dos Santos Haz (CONCENTRIX CORPORATION) 620 Reputation points Microsoft Vendor
0 answers

Outlook saveas did not save the embedded image added from vba or build manually

Hi folks, We run a vba code that create email using data from an Acess database. We add some picture using html format for the email and save it in Outlook format(msg) to read them later. When I display it, we see the image inside the email. After using…

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,399 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.
809 questions
asked 2024-03-18T12:10:11.8433333+00:00
Simon G364 0 Reputation points
3 answers One of the answers was accepted by the question author.

summary report for blank values per field in access

We have a large table of data (several thousand records), and a significant amount of fields is recorded for each record. The design of the table means at present some fields are mandatory (required), and others are not required – which I think was…

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,252 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
289 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.
809 questions
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
1,971 questions
asked 2024-03-11T12:58:39.2+00:00
crib bar 491 Reputation points
edited the question 2024-03-18T08:13:02.63+00:00
Emi Zhang-MSFT 20,901 Reputation points Microsoft Vendor
0 answers

IIF function and dates

Hello I was asked to make a change in the code I am currently calculating how much a student should pay The students have an arrival date, from here it automatically calculates for them the amount according to what was agreed monthly and the days of…

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.
809 questions
asked 2024-03-17T10:42:21.8733333+00:00
eshai 1 Reputation point
commented 2024-03-17T16:29:26.12+00:00
eshai 1 Reputation point
1 answer

verify jwt (access_token) by python

hello, I have a front in angular and a backend in Django Python. I take my access_token from my front by: this.msalService.instance.acquireTokenSilent and send it to my backend api, i need to verify and validate this access_token before anything will…

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.
809 questions
Microsoft Entra External ID
Microsoft Entra External ID
A modern identity solution for securing access to customer, citizen and partner-facing apps and services. It is the converged platform of Azure AD External Identities B2B and B2C. Replaces Azure Active Directory External Identities.
2,609 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,087 questions
asked 2023-11-07T15:17:15.7033333+00:00
bar c 0 Reputation points
commented 2024-03-11T12:18:22.7766667+00:00
Chethan L Reddy 0 Reputation points
1 answer

How to execute pass-through query with long connect string in MS Access VBA

In MS Access VBA, when I create a temp querydef object with odbc driver to run the SQL by pass-through query, a warning occur "XXX is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too…

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.
809 questions
asked 2024-03-02T09:33:45.5833333+00:00
Woolf Wei 20 Reputation points
answered 2024-03-09T23:47:33.8566667+00:00
Peter Doering 160 Reputation points
1 answer

Access Europe: Better Access Charts – The Next Generation (Thomas Moeller) – Wed 6 Mar

The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back (by popular demand) Thomas Moeller who will be discussing…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
289 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.
809 questions
asked 2024-02-28T12:48:36.9366667+00:00
Colin Riddington 146 Reputation points MVP
answered 2024-03-08T18:36:27.4766667+00:00
Colin Riddington 146 Reputation points MVP
2 answers

access copy and paste issue

We have a strange intermittent issue in an Access 2016 database application (classic architecture with individual front end per user with links to a central backend database), that prevents users copying text from emails, word docs, xlsx spreadsheets etc…

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,252 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
289 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,399 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.
809 questions
asked 2024-03-08T08:21:54.9866667+00:00
crib bar 491 Reputation points
commented 2024-03-08T13:08:20.7033333+00:00
crib bar 491 Reputation points
9 answers One of the answers was accepted by the question author.

msaccess.exe (all versions) won't close properly when process EoAExperiences.exe is running

I have a msaccess-application (accdb) working as frontend-client to a sql-server database. The FE-database consists of forms, reports, modules, etc. On one client, when I open a form with controls others than label, it is not possible to close 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.
809 questions
asked 2022-01-03T09:40:05.007+00:00
Christoph Schweizer 36 Reputation points
commented 2024-03-05T18:31:41.23+00:00
Cyclobiker 0 Reputation points
2 answers

Two finger scrolling not working in Access

Two-finger scrolling on a touchpad is not working on an Access form. It works OK in Excel, so it's not the computer or the mouse/touchpad drivers. It's also fine on the Navigation Pane in Access. If I open a table, it does scroll but is jerky and…

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
3,596 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.
809 questions
asked 2023-03-29T10:34:43.46+00:00
john fallows 10 Reputation points
answered 2024-03-02T20:26:01.5633333+00:00
Tom van Stiphout 1,616 Reputation points MVP
3 answers

How do I compare two access database tables, both the table has same rows and columns ?

I have two access database tables. Table A Account #, Name, Addres, City, State, Balance, Purchase, Order, Year, TotalCost Table B. Account #, Name, Addres, City, State, Balance, Purchase, Order, Year, TotalCost My purpose is to compare Table A and…

.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,261 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,395 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,094 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.
809 questions
asked 2024-02-13T06:46:20.43+00:00
Josh S 26 Reputation points
edited an answer 2024-02-29T22:16:58.11+00:00
Peter Doering 160 Reputation points
3 answers One of the answers was accepted by the question author.

RefreshLink has started failing with Error 3611 - Version 2312 (Build 17126.20014)

Having posted in the Community forum, it has been suggested that this is a better place to ask my question. I have a split Access database that has started raising Error 3611 (Cannot execute data definition statements on linked data sources) in the…

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
3,596 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,399 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.
809 questions
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
1,971 questions
asked 2023-12-08T22:47:02.6333333+00:00
DaveBWC 20 Reputation points
edited a comment 2024-02-28T00:36:16.2266667+00:00
Karl Donaubauer 1,566 Reputation points MVP
1 answer

MS Access 2019 Crashes - Exception 0xc0000005

I am attempting to upgrade an existing MS Access 2010 application, but I get intermittent silent crashes, typically when opening or closing a screen form. The Application Event Viewer logs the following typical details: Faulting application name:…

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.
809 questions
asked 2022-01-01T00:18:47.803+00:00
Craig Bransfield 1 Reputation point
commented 2024-02-26T17:17:02.2833333+00:00
GPE 41 Reputation points
1 answer One of the answers was accepted by the question author.

I got an error when using MSSMAA and cannot migrate to SQL Server

When I start MSSMAA i got an error: Starting conversion... Analyzing metadata... Converting table Samod_Relèves.[AMaTable_Elec] ... Information: A2SS0005: The Zero-length-not-allowed flag on the column 'ResultID' was converted to a check…

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.
809 questions
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
1,971 questions
asked 2024-02-04T21:43:19.5533333+00:00
RENE COUZINIER 20 Reputation points
edited the question 2024-02-26T06:34:39.6033333+00:00
Emi Zhang-MSFT 20,901 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

How to enter contributions records for different years. E.g 2010 to present

I am creating an MS Access file for welfare contributions for my local church. I have created a table to record the details of the contributions which includes, payment date, contribution month, contribution year, etc. I entered data for 2017 for example…

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.
809 questions
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
1,971 questions
asked 2024-02-05T23:02:04.3766667+00:00
Enoch 20 Reputation points
edited the question 2024-02-26T06:34:20.9566667+00:00
Emi Zhang-MSFT 20,901 Reputation points Microsoft Vendor