413 questions with Microsoft 365 and Office | Access | Other | Windows tags
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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