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

Sort by: Updated
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,320 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
1 answer

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 0 Reputation points
answered 2026-08-11T21:00:29.1233333+00:00
Hendrix 780 Reputation points Independent Advisor
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 2,695 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,160 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,486 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 17,990 Reputation points Microsoft External Staff Moderator
7 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
edited a comment 2026-07-20T15:12:58.0466667+00:00
Rob Curtis 0 Reputation points
2 answers

how to create a new data relationship in Access

I am trying to create a new query in Access but cannot work out how to include a surname (from ADDRESS} in a table composed of PAYMENTS data. Can you help?

Microsoft 365 and Office | Access | For home | Windows
asked 2026-07-15T20:58:46.17+00:00
Peter Cleasby 0 Reputation points
answered 2026-07-19T15:40:24.18+00:00
Richard Rost 315 Reputation points MVP
3 answers

setting up tables and relationships for a personal book inventory

Is there someone that I could contact (preferably in person but could try to do online) to assist me in setting up a proposed table layouts and relationships for a massive book inventory that I have acquired and need to better organize. I have used…

Microsoft 365 and Office | Access | For home | Windows
asked 2026-07-15T18:51:18.3766667+00:00
Lisa Reid 0 Reputation points
edited an answer 2026-07-19T14:15:40.0733333+00:00
Ken Sheridan 3,581 Reputation points
1 answer

SQL Question

I'm using the following SQL to display records with today's (17th) date and past due date: Problem is it also displays 2 records that dated on the 20th duplicate the 2 records. Any ideas? James

Microsoft 365 and Office | Access | For home | Windows
asked 2026-07-17T18:35:34.4266667+00:00
James 130 Reputation points
answered 2026-07-18T13:23:25.5333333+00:00
George Hepworth 23,120 Reputation points Volunteer Moderator
1 answer

How do I show the grand total which excludes one sub-account.

Report displayed Sub 1 item1 20.00 item 2 25.00 Total Sub1 = 45.00 Sub 2 Item 3 10.00 Item 4 15.00 Total Sub 2 25.00 Sub 3 Item 5 …

Microsoft 365 and Office | Access | For home | Windows
asked 2026-07-14T03:43:50.1766667+00:00
Art Carino 0 Reputation points
edited an answer 2026-07-14T04:32:50.9+00:00
Duane Hookom 26,935 Reputation points Volunteer Moderator
1 answer

Refund for ACCESS

can I get a refund for ACCESS ? I purched from Microsoft store .

Microsoft 365 and Office | Access | For home | Windows
asked 2026-07-11T15:33:13.0733333+00:00
Joseph Savukinas 0 Reputation points
answered 2026-07-11T16:02:23.17+00:00
Kristen-L 15,650 Reputation points Microsoft External Staff Moderator
2 answers

FM20.dll Missing (in the past 2 weeks), Breaking MS Forms 2.0 Controls in MS Access - How to Replace It?

In the last two weeks, FM20.dll was removed by Windows 11, and now, essential and current applications have stopped working. These are all MS Access-based desktop applications, who specifically use the MS Forms 2.0 Textbox, which is an essential…

Microsoft 365 and Office | Access | For home | Windows
asked 2026-07-06T14:36:14.7933333+00:00
Vexen Crabtree 0 Reputation points
answered 2026-07-07T13:57:24.07+00:00
Vexen Crabtree 0 Reputation points