20,922 questions with Microsoft 365 and Office | Access | For home | Windows tags

Sort by: Updated
1 answer

microsoft access append query key violation when there is no primary key

I have Access as a subscription of Microsoft 365 under Windows 11 Pro. I am trying to run an append query, but I get an error message: "didn't add records due to key violations". However, the table I am trying to append it to, doesn't have ANY…

Microsoft 365 and Office | Access | For home | Windows
asked 2026-09-27T01:41:22.0233333+00:00
Harold E1 25 Reputation points
commented 2026-09-30T02:22:37.8366667+00:00
Teddie Dang 1,365 Reputation points Independent Advisor
2 answers

Cannot enforce referential integrity, even though there are NO records in the child table without an ID in the parent table

Cannot enforce referential integrity, even though there are NO records in the child table without an ID in the parent table.

Microsoft 365 and Office | Access | For home | Windows
asked 2026-09-27T01:47:08.3433333+00:00
Harold E1 25 Reputation points
recommended 2026-09-30T02:18:24.2633333+00:00
Kai-Ex 1,570 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

How do I install Microsoft Access on my new Windows 11 computer?

I have used Access for decades. I just bought a new computer with Windows 11 and downloaded Office 365 since my subscription for Office 365 Family was current. I then upgraded to Office 365 Premium to get better CoPilot experience. But now I cannot find…

Microsoft 365 and Office | Access | For home | Windows
asked 2026-09-24T20:45:40.9066667+00:00
Dan Bishop 20 Reputation points
accepted 2026-09-26T21:06:13.8466667+00:00
Dan Bishop 20 Reputation points
1 answer One of the answers was accepted by the question author.

how to solve the run problem it dont let me click it

it dont let me click the run button on microsoft access.

Microsoft 365 and Office | Access | For home | Windows
asked 2026-09-18T21:04:35.4866667+00:00
Marisol Lopez 20 Reputation points
commented 2026-09-18T21:19:06.3033333+00:00
Marisol Lopez 20 Reputation points
5 answers

A form in MS-Access that has worked since 2016 now fails on the report field with =Date() as the control

The same field is used on a number of reports to show the date when the report was printed. It is an unbound field with "=Date()" to provide the current system date (in medium date format). This has worked wonderfully well and simply for the…

Microsoft 365 and Office | Access | For home | Windows
asked 2026-09-12T07:58:44.5666667+00:00
Neville Williams 0 Reputation points
commented 2026-09-14T12:32:47.42+00:00
Roebe Ta 1,375 Reputation points Independent Advisor
2 answers

Microsoft Access 2000 problem started yesterday 8/11/26. I can see header in Report View but have disappeared in Print View. Does anyone know how to restore/fix.

Microsoft Access 2000 problem started yesterday 8/11/26. I can see header in Report View but have disappeared in Print View. Does anyone know how to restore/fix.

Microsoft 365 and Office | Access | For home | Windows
asked 2026-08-11T20:36:25.9733333+00:00
Edna G 5 Reputation points
edited an answer 2026-09-11T11:25:37.0433333+00:00
Karl Donaubauer 3,661 Reputation points MVP
1 answer

Decimal field error

I received this error. How do I fix it. The decimal field's precision is too small to accept the numeric you attempted to add. (Error 3761)

Microsoft 365 and Office | Access | For home | Windows
asked 2026-09-10T13:29:42.9666667+00:00
Nichols, Shanyse 0 Reputation points
answered 2026-09-10T13:33:45.02+00:00
Marcin Policht 109.6K Reputation points MVP Volunteer Moderator
8 answers

Recordset is not updateable -- where is help on MS Access 365?

For years I have just used Access 2007 on my laptop, though I have Office 365. As the disc wouldn't work on my Win11 PC, and the laptop has a problem, I finally decided to use the later access, and opened a 2007 database. I updated a number of records…

Microsoft 365 and Office | Access | For home | Windows
asked 2026-07-12T05:42:38.31+00:00
Rob Curtis 20 Reputation points
answered 2026-09-03T09:42:00.71+00:00
Rob Curtis 0 Reputation points
1 answer

is there a way to remove duplicates but leave one record?

im using access and have a table that contains company name, id and a date, time, to include the second stamp within unfortunately, its been imported on a number of occasions so there's multiple duplicates. i know i can run a find duplicate query, but…

Microsoft 365 and Office | Access | For home | Windows
asked 2026-08-28T07:35:13.7166667+00:00
Mark Powell 0 Reputation points
commented 2026-08-30T08:42:27.33+00:00
Elena-VH 1,890 Reputation points Independent Advisor
1 answer

Access Union Query

Hi, I have multiple queries with Calendar dates and selected field dates and their amounts. Each individual query works. The Union query brings these multiple fields together. There is no errors, but the datasheet view is only showing Est Deposit Date…

Microsoft 365 and Office | Access | For home | Windows
asked 2026-08-14T22:15:35.6033333+00:00
Jennet Knuckey 45 Reputation points
commented 2026-08-22T20:37:35.1866667+00:00
Jennet Knuckey 45 Reputation points
1 answer

Trouble calling Excel Data Analysis ToolPak functions from Access VBA

I am trying to run Excel's Data Analysis ToolPak functions from Access VBA, but I receive an error message: Application-Defined or Object-Defined error. Here is my code: objExcel.Run "ATPVBAEN.XLAM!Regress", objSheet.Range(rng_y),…

Microsoft 365 and Office | Access | For home | Windows
asked 2026-08-19T14:19:34.1433333+00:00
Rick Thackeray 0 Reputation points
commented 2026-08-20T21:54:33.73+00:00
Rick Thackeray 0 Reputation points
1 answer

Half height footer bar on access

I have tried adjusting the height in the design view "Form Footer" but whatever size I put in has no bearing on resolving the problem of only seeing half height details in the footer which makes it very difficult to read. What help can you…

Microsoft 365 and Office | Access | For home | Windows
asked 2026-08-20T15:37:35.4533333+00:00
Tony Parker 0 Reputation points
commented 2026-08-20T16:26:49.74+00:00
Tom van Stiphout 40,216 Reputation points MVP Volunteer Moderator
5 answers

Why is the paste function no longer working in Access, in design view of a Form? But, copy works.

While in the design view of a Form, I am unable to paste. I am able to copy. But, the "paste" is greyed out when I right click to paste. The Ctrl C works, I can see it select items. But, the Ctrl V does not do anything.

Microsoft 365 and Office | Access | For home | Windows
asked 2025-09-26T23:22:30.7166667+00:00
Tammi R 5 Reputation points
commented 2026-08-17T18:11:41.69+00:00
David Mancini 1 Reputation point
3 answers One of the answers was accepted by the question author.

Access Database Date issues

Hi I am waiting to show ALL dates in a calender and sum amounts from another date field. Screenshot of query below. Please note the joins is option 2. Include all from master calender and only those dates from the other that match. It runs but the…

Microsoft 365 and Office | Access | For home | Windows
asked 2026-08-01T03:10:32.21+00:00
Jennet Knuckey 45 Reputation points
accepted 2026-08-14T22:04:59.6533333+00:00
Jennet Knuckey 45 Reputation points
3 answers One of the answers was accepted by the question author.

Access Calculation in query issue

In Query 'Carpet Purchases Date Calculations' Field: Final Due Date I want the calculation to pick up the answer from field 'Invoice Date Used for Calc Actual or Est' + Supplier Terms. Supplier Terms are found in the Table 'Supplier Information'.…

Microsoft 365 and Office | Access | For home | Windows
asked 2026-04-17T20:45:18.06+00:00
Jennet Knuckey 45 Reputation points
accepted 2026-08-07T21:43:53.6533333+00:00
Jennet Knuckey 45 Reputation points
2 answers One of the answers was accepted by the question author.

Entity Framework: in visual basic how do i create class model

what projects IN visual basic do i need to create and their purposes I have an existing MSAccess data base which needs to be extended with more functions

Microsoft 365 and Office | Access | For home | Windows
asked 2026-07-31T15:22:23.5366667+00:00
Gordon Lanham 20 Reputation points
accepted 2026-08-07T18:05:42.3266667+00:00
Gordon Lanham 20 Reputation points
3 answers

Access 2000 Form - save record, clear KEY field but leave all other fields as they are.

A Database and entry form created by a dead relative in 2003 is giving me trouble. I would like to change the FORM to save the record data entered - clear the KEY field and leave the other data fields loaded. The wish iis defeating me at the moment. I…

Microsoft 365 and Office | Access | For home | Windows
asked 2026-08-02T20:17:23.5966667+00:00
DAVID DE-LA-COUR 0 Reputation points
commented 2026-08-04T01:26:56.4933333+00:00
BabybooHN 3,290 Reputation points Independent Advisor
2 answers

how to fix the repair error on my MS access

whenever I open my MS Access database there is a tab that says repair and nothing happens when I press the button nothing happens the error still appears what should I do?

Microsoft 365 and Office | Access | For home | Windows
asked 2026-07-25T07:54:11.94+00:00
John Gicheru 0 Reputation points
commented 2026-07-26T06:23:57.6966667+00:00
Senthil kumar 2,500 Reputation points
2 answers

What do I do if I have an Access dtabase now that it is no longer available?

I have used Access for several years and have built a database of thousands of records. I had to move to a new desktop, and Access as an application appears to be no longer avaialble. What do I do with all of my work?

Microsoft 365 and Office | Access | For home | Windows
asked 2026-07-22T22:06:36.29+00:00
Tom Roush 0 Reputation points
commented 2026-07-23T13:04:43.5466667+00:00
Karl Donaubauer 3,661 Reputation points MVP
4 answers

How do I get multiple users use my Microsoft access database across computers at different locations

Hi everyone, I have designed a Microsoft access database that I am using and it's working fine I have deployed it to some clients and they like it but the major challenges is how to get users remotely use the database at different locations From…

Microsoft 365 and Office | Access | For home | Windows
asked 2026-07-07T20:42:01.5633333+00:00
Faraday 0 Reputation points
commented 2026-07-20T22:52:50.6033333+00:00
Kai-L 19,830 Reputation points Microsoft External Staff Moderator