413 questions with Microsoft 365 and Office | Access | Other | Windows tags

Sort by: Updated
2 answers

Conditional Formatting?

Can Access do conditional formatting like Excel? Can I compare two text boxes? If text box 1 has a value and text box 2 has a different value, can text box 2 change color if it does not meet the conditions of text box 1? If the above is possible, if…

Microsoft 365 and Office | Access | Other | Windows
asked 2025-12-11T20:56:26.2733333+00:00
Patrick Snyder 0 Reputation points
edited an answer 2025-12-12T22:26:37.8933333+00:00
Duane Hookom 26,555 Reputation points Volunteer Moderator
0 answers

Importing data into a table from Excel, funky results

See snippet below, I've imported data from excel to access, several rows but some of the results look like the snippet below. The cell that I am importing from is formatted as Text. The field that I am placing the data into is Short Text. I have…

Microsoft 365 and Office | Access | Other | Windows
asked 2025-12-12T14:02:20.87+00:00
Patrick Snyder 0 Reputation points
commented 2025-12-12T16:56:17.62+00:00
Patrick Snyder 0 Reputation points
2 answers

I WANT TO CREATE SUB AND SUB SUB TABLE IN MSACCESS

I WANT TO CREATE DATA BASE IN ACCESS ON THE BASIS OF ATTACHED TABLE OF MSEXCEL. IF YOU WANT MORE DETAILS FROM MY SIDE WILL FORWARD TO YOU. Moved from: Community Center | Discuss the Q&A site | Get started on Q&A

Microsoft 365 and Office | Access | Other | Windows
asked 2025-12-10T13:23:53.04+00:00
Ahmed Kutty 40 Reputation points
commented 2025-12-12T09:02:28.9+00:00
Gabriel-N 9,950 Reputation points Microsoft External Staff Moderator
1 answer

Forms- Empty text boxes that do not go away

I've created a form based off of a table. When I open the form and start moving the text boxes around, i notice that there are several other text boxes but in the Properties, the name or section type is "Empty Cell". I would not let this…

Microsoft 365 and Office | Access | Other | Windows
asked 2025-12-11T16:13:21.5166667+00:00
Patrick Snyder 0 Reputation points
answered 2025-12-11T18:41:01.1833333+00:00
Duane Hookom 26,555 Reputation points Volunteer Moderator
2 answers

MSACCESS PET - FOR TRAINING

I found pet training template similar to msaccess some years back. Is it available just like Northwind? I need it. Also I need a book from web site. The one I told above should be in the book. Move from: Community Center | Discuss the Q&A site |…

Microsoft 365 and Office | Access | Other | Windows
asked 2025-12-06T09:49:55.04+00:00
Ahmed Kutty 40 Reputation points
accepted 2025-12-11T04:15:06.47+00:00
Ahmed Kutty 40 Reputation points
3 answers One of the answers was accepted by the question author.

MSACCESS NORTHWIND

I want training in msacces northwind. Northwind is a sample msaccess training program. Moved from: Community Center | Not monitored

Microsoft 365 and Office | Access | Other | Windows
asked 2025-12-06T09:21:54.5866667+00:00
Ahmed Kutty 40 Reputation points
edited an answer 2025-12-06T14:45:52.71+00:00
George Hepworth 22,220 Reputation points Volunteer Moderator
1 answer One of the answers was accepted by the question author.

Export MSAccess table to CSV

Dear all, from an MSAccess Database table I need to extract the content to a csv file. As this csv file needs to be imported in a SQLite table and especially for the Date field the format must be YYYY-MM-DD HH:MM:SS (like 2025-11-27 00:00:00 NOT…

Microsoft 365 and Office | Access | Other | Windows
asked 2025-11-27T14:29:41.25+00:00
Luca Tramontana 81 Reputation points
accepted 2025-12-01T13:27:31.29+00:00
Luca Tramontana 81 Reputation points
1 answer One of the answers was accepted by the question author.

Invalid Argument Error

I am receiving an invalid argument error when running a query in MS Access. I wasnt having this issue when I was using Windows 10 operating system. When I transitioned to Windows 11, I started receiving the invalid argument error. Do you know what is the…

Microsoft 365 and Office | Access | Other | Windows
asked 2025-11-21T21:59:11.0133333+00:00
riza 20 Reputation points
accepted 2025-11-21T22:05:43.51+00:00
riza 20 Reputation points
4 answers

Why Access and Publisher did not get the new 365 icons?

The Microsoft 365 apps are getting new logos (and I have received all of them) Access and Publisher were not getting these new icons as they were not shown https://microsoft.design/articles/fluid-forms-vibrant-colors/ here. Why so?

Microsoft 365 and Office | Access | Other | Windows
asked 2025-10-23T07:25:00.5166667+00:00
VedanshS933 20 Reputation points
edited an answer 2025-11-18T14:30:19.6566667+00:00
Karl Donaubauer 2,696 Reputation points MVP
1 answer

When will the issue with dao360.dll that is crashing my VB6 app connected to Access databases be fixed?

When will the issue with dao360.dll that is crashing my VB6 app connected to Access databases be fixed?

Microsoft 365 and Office | Access | Other | Windows
asked 2025-11-04T21:50:26.73+00:00
Richard Kraus 0 Reputation points
commented 2025-11-17T21:23:48.42+00:00
Richard Kraus 0 Reputation points
1 answer One of the answers was accepted by the question author.

MSAccess - Select max value of each group

Dear All, by the below query I get the following MSAccess data: SELECT [TEMP_TABLE].Serialnumber_Or_SNID, [TEMP_TABLE].Warranty_Code, Max([TEMP_TABLE].EXTENSION_SORT_ORDER) AS MaxOfEXTENSION_SORT_ORDER FROM TEMP_TABLE GROUP BY …

Microsoft 365 and Office | Access | Other | Windows
asked 2025-11-12T20:45:03.6+00:00
Luca Tramontana 81 Reputation points
commented 2025-11-13T23:25:47.97+00:00
TiNo-T 9,275 Reputation points Microsoft External Staff Moderator
2 answers

How can I print labels from selected records in Access?

How can I print labels from selected records in Access

Microsoft 365 and Office | Access | Other | Windows
asked 2025-11-05T15:38:53.4633333+00:00
Jairo Freyre 0 Reputation points
edited an answer 2025-11-06T15:10:05.66+00:00
Ken Sheridan 3,546 Reputation points
2 answers One of the answers was accepted by the question author.

Database Compare is asking for Microsoft.ReportViewer.ProcessingObjectModel.dll ver 12.0.0.0

Database Compare is asking for Microsoft.ReportViewer.ProcessingObjectModel.dll ver 12.0.0.0 which is not available to download in the web. screenshot attached. How to fix?

Microsoft 365 and Office | Access | Other | Windows
asked 2025-11-04T07:31:53.5066667+00:00
Kavitha Gopalakrishnan 20 Reputation points
edited a comment 2025-11-06T07:38:53.57+00:00
Gabriel-N 9,950 Reputation points Microsoft External Staff Moderator
1 answer

Access - VB - DAO library looking in wrong folder

The VBE under Tools / References says that DAO 3.6 is available at C:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dll However, there is no DAO folder in that location (and no dao360.dll). It is in the C:\Program Files (x86)\Common…

Microsoft 365 and Office | Access | Other | Windows
asked 2025-10-31T12:00:44.8666667+00:00
Greg Waymaster 0 Reputation points
commented 2025-11-05T06:51:32.9566667+00:00
Dora-T 8,520 Reputation points Microsoft External Staff Moderator
1 answer

How to fix Microsoft Access

I’m currently experiencing issues with our Microsoft Access application. I’ve already reached out to one of our IT personnel, and while they’ve been trying to troubleshoot, the problem remains unresolved. I was advised by one of our IT professionals to…

Microsoft 365 and Office | Access | Other | Windows
asked 2025-10-30T19:52:00.5066667+00:00
Manguiat, Francaix 0 Reputation points
recommended 2025-10-30T20:53:16.73+00:00
Duane Hookom 26,555 Reputation points Volunteer Moderator
2 answers One of the answers was accepted by the question author.

How to get linked jpg images to appear on an Access form. It seems to be a common issue.

I've done everything they tell you to do in various videos on youtube but I still cant get images to appear on the forms unless they're static which won't work in the setup I am working on.. I've had a VB script sent to me but not being familiar with VB,…

Microsoft 365 and Office | Access | Other | Windows
asked 2025-10-23T00:32:30.36+00:00
Chris Miller 20 Reputation points
commented 2025-10-23T18:35:28.1033333+00:00
Chris Miller 20 Reputation points
2 answers One of the answers was accepted by the question author.

Microsoft Access 2021 - Main Switchboard

I have an flat based Access Data Base developed many years ago and imported into Access 2021. It has a number of queries and reports linked to a Main Switchboard. I want to edit that Switchboard so that I can add new reports and delete others. I…

Microsoft 365 and Office | Access | Other | Windows
asked 2025-10-12T07:56:18.99+00:00
Hastings Seniors 20 Reputation points
answered 2025-10-17T13:17:31.9333333+00:00
ScottGem 68,775 Reputation points Volunteer Moderator
3 answers One of the answers was accepted by the question author.

Using value from forms in a query

I have several different data tables that use Project Number. I'm gathering data from the different tables and putting into one local table. I set up a form and used a text box for entering project numbers.....I have 2 different ones so I can enter…

Microsoft 365 and Office | Access | Other | Windows
asked 2025-10-02T17:05:00.3866667+00:00
Jen 20 Reputation points
commented 2025-10-06T21:45:45.8566667+00:00
Duane Hookom 26,555 Reputation points Volunteer Moderator
5 answers One of the answers was accepted by the question author.

Issues with Access's Analyzer Tools

Hello. I'm experiencing issues with Access's performance analysis tools. Once opened, when I move the mouse over dialog boxes, they give me errors and inform me about the events that caused them. For example, "The 'FldListMouseMove' expression you…

Microsoft 365 and Office | Access | Other | Windows
asked 2025-08-06T07:53:47.1066667+00:00
Ernesto 20 Reputation points
commented 2025-08-20T16:09:03.9633333+00:00
Ernesto 20 Reputation points
5 answers One of the answers was accepted by the question author.

I am new to access. I am setting up a new database and associated queries. I would like suggestions on the correct way to set up my tables.

I 've used Excel for many years and am relatively proficient with it. However, I am working on a project that requires far more than Excel offers. I believe access is the best prograqm for this. I am completely new to Acess so I am on a big learning…

Microsoft 365 and Office | Access | Other | Windows
asked 2025-07-28T16:53:06.2833333+00:00
Sean M 20 Reputation points
edited an answer 2025-08-03T12:31:35.3466667+00:00
Ken Sheridan 3,546 Reputation points