172 questions with Microsoft 365 and Office | Access | For education | Windows tags

Sort by: Updated
Updated Created Answers
2 answers

Acccess Macros

This thing no matter what wont let me get access to this downloaded link for this assignment and its so annoying no matter how how try to get to it to change stuff its still saying microsoft is blocking it even when I try to unblock it its not working,…

Microsoft 365 and Office | Access | For education | Windows
asked 2026-03-17T20:14:45.09+00:00
Young, Brooklynn 0 Reputation points
edited an answer 2026-03-18T23:27:24.9933333+00:00
Hendrix-C 13,405 Reputation points Microsoft External Staff Moderator
2 answers

microsoft access blocking macros even though the site is added to trusted sites

ive added the website to trusted sites but access is still blocking macros

Microsoft 365 and Office | Access | For education | Windows
asked 2026-02-28T14:30:20.68+00:00
Chandler,Madison 0 Reputation points
commented 2026-03-03T07:51:31.3+00:00
Austin-H 8,345 Reputation points Microsoft External Staff Moderator
1 answer

Best free training for Access

I have an Excel file that needs to be converted to Access. I have programming background but I need to learn how to use Access.

Microsoft 365 and Office | Access | For education | Windows
asked 2026-02-27T18:15:06.7033333+00:00
Barbara Aide 0 Reputation points
answered 2026-02-27T18:15:24.93+00:00
Q&A Assist
1 answer

Why is it not recognizing this as a query?

Why is Access not recognizing this as a query: Dim lsql As DAO.Recordset Set lsql = "SELECT OrderHistory.PID, OrderHistory.PONo FROM PONoQ WHERE (((OrderHistory.PONo) Like '*' & [Forms]![POSearchF]![POS] & '*'));" I get a compile…

Microsoft 365 and Office | Access | For education | Windows
asked 2026-02-04T23:10:10.79+00:00
Maxine Nietz 1 Reputation point
commented 2026-02-13T07:02:14.1933333+00:00
TiNo-T 11,980 Reputation points Microsoft External Staff Moderator
3 answers

I want to unblock my Microsoft Access File

When I open the file, Access file say that the active content in the file is blocked I have try Properties and Internet Option also cannot. Properties dont have unblock Internet Option is the type of URL is unvalid

Microsoft 365 and Office | Access | For education | Windows
asked 2025-12-04T00:57:44.2466667+00:00
Hennry Yeoh 0 Reputation points
commented 2026-02-09T10:23:49.92+00:00
Gabriel-N 15,130 Reputation points Microsoft External Staff Moderator
1 answer

Trying to find a value

PONo is a text field; PID is an autonumber (key) field. POS is a text box on a form. PONoQ is a select query as follows: SELECT OrderHistory.PONo, OrderHistory.PID FROM Purchases INNER JOIN OrderHistory ON Purchases.PID = OrderHistory.PID ORDER BY…

Microsoft 365 and Office | Access | For education | Windows
asked 2026-02-04T23:00:00.8366667+00:00
Maxine Nietz 1 Reputation point
commented 2026-02-06T08:27:25.66+00:00
Dora-T 11,460 Reputation points Microsoft External Staff Moderator
2 answers

I have an Access class I am taking that I need to use the Microsoft TreeView Control

I have an Access class that requires the Microsoft Treeview Control to be installed on my computer, but it says it does not support this ActiveX control. I am wondering why it is listed as an ActiveX component to use in Access. I am using the current…

Microsoft 365 and Office | Access | For education | Windows
asked 2026-02-02T01:33:56.5933333+00:00
Ken Wykoff 0 Reputation points
edited an answer 2026-02-03T23:58:56.84+00:00
TiNo-T 11,980 Reputation points Microsoft External Staff Moderator
1 answer

Unable to Open Access 2019 Expert Educator Course Files

All Office 2019 course educator files can open except for the Access 2019 educator files. It advises to request for permission.

Microsoft 365 and Office | Access | For education | Windows
asked 2026-01-30T14:06:46.78+00:00
Gurdeep Jassal 0 Reputation points
commented 2026-02-03T07:30:20.2666667+00:00
Michelle-N 13,740 Reputation points Microsoft External Staff Moderator
1 answer

security risk

I have troubles in my Microsoft Access it say " Microsoft has block macros from running because the source of the file is untrusted" so how am I supposed to do it?

Microsoft 365 and Office | Access | For education | Windows
asked 2026-01-07T07:01:12.4566667+00:00
SITI NUR RAMADHANI BINTI ABDUL RAHIM 0 Reputation points
answered 2026-01-07T07:01:21.2366667+00:00
Q&A Assist
1 answer

Microsoft Access

I downloaded a file through microsoft access for a school project. I enabled the macros because the file was "untrusted". I consistently saved the project but eventually it randomly reloaded it and said it blocked macros even though i have…

Microsoft 365 and Office | Access | For education | Windows
asked 2025-12-07T01:26:05.5166667+00:00
Heather McCalla 0 Reputation points
commented 2025-12-10T08:54:37.6733333+00:00
Gabriel-N 15,130 Reputation points Microsoft External Staff Moderator
2 answers

Could Microsoft Add Access 2019 Expert to the MOS Associate/Expert Qualifications?

The "Microsoft Office Specialist: Expert (Microsoft 365 Apps)" qualification requires an associate in any 3 of Excel, Word, PowerPoint, or Outlook (Office 2019/365), plus an Expert in any two of Excel or Word (Office 2019/365) This means that…

Microsoft 365 and Office | Access | For education | Windows
asked 2025-12-02T12:09:25.49+00:00
JJ 0 Reputation points
answered 2025-12-02T14:43:05.5766667+00:00
Dora-T 11,460 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

Cannot find Microsoft Access in my Microsoft 365

Cannot find Access in my Microsoft 365 app...where is it located?

Microsoft 365 and Office | Access | For education | Windows
asked 2025-11-21T22:38:44.57+00:00
Harry Nimon 20 Reputation points
recommended 2025-11-23T20:51:27.8366667+00:00
Stefan Blom 336.4K Reputation points MVP Volunteer Moderator
1 answer

The error "Id is not an index of this table"

I have a problem, when I open files or close or open a form in my file I get the error ""Id" is not an index of this table". I also have tables and queries there is no such error.

Microsoft 365 and Office | Access | For education | Windows
asked 2025-11-22T18:13:36.01+00:00
Mariana Melen 0 Reputation points
answered 2025-11-22T18:37:21.95+00:00
Marcin Policht 83,190 Reputation points MVP Volunteer Moderator
2 answers

I downloaded Microsoft 365 for school and I'm not able to access important files.

I downloaded Microsoft 365 for school since I needed to be able to work with access. I downloaded the file I was provided with by my professor, and I need to edit it but when I download it and try to open it, it says that a potentially dangerous macro…

Microsoft 365 and Office | Access | For education | Windows
asked 2025-11-17T15:40:41.07+00:00
Brynna Kellogg 0 Reputation points
commented 2025-11-18T22:39:32.9666667+00:00
Jay Tr 10,120 Reputation points Microsoft External Staff Moderator
2 answers

How to unblock macros from access

I need to complete my homework but i cant use the access app. Moved from: Microsoft System Center | Other

Microsoft 365 and Office | Access | For education | Windows
asked 2025-11-15T21:29:19.82+00:00
Jalee Adams 0 Reputation points
commented 2025-11-16T22:33:48.66+00:00
Jay Tr 10,120 Reputation points Microsoft External Staff Moderator
1 answer

How to access blocked files for Microsoft Access from BrightSpace, despite numerous suggested routes already failing?

I am trying to download and open some files for Microsoft Access via BrightSpace for schoolwork. I have tried using my system, as well as the school's remote desktop. However, in both cases, the files are blocked for security reasons. I have never had…

Microsoft 365 and Office | Access | For education | Windows
asked 2025-11-04T22:37:53.8+00:00
Ryan McDonald 0 Reputation points
commented 2025-11-10T07:24:19.0266667+00:00
Dora-T 11,460 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

Problem with the landscape & margins after using report wizard

Good evening, the report wizard failed me and now this report won't go on landscape or even get the margins fixed, what am I doing wrong? AND I KNOW THE PROBLEM IS WITH MY LAPTOP, because I did everything again with the college's computer and it just…

Microsoft 365 and Office | Access | For education | Windows
asked 2025-10-31T17:32:15.1033333+00:00
Rimas 20 Reputation points
answered 2025-11-01T11:01:31.4+00:00
Rimas 20 Reputation points
1 answer

Blocking Macro thing

I am trying to open a access file for my classes in college and it keeps popping up saying its blocking a macro, i know its safe cause my friend had no issue opening his but it wont let me open mine I need this fixed asap to be able to do my assignments.

Microsoft 365 and Office | Access | For education | Windows
asked 2025-10-22T13:55:51.98+00:00
Genochio, Austin J 0 Reputation points
commented 2025-10-27T09:02:02.2433333+00:00
Michelle-N 13,740 Reputation points Microsoft External Staff Moderator
3 answers One of the answers was accepted by the question author.

Suggestions of best way to delete from subform

Hi i have a subform, i ideally want to add a command button to each of the updates within that will delete any line picked. is there a best way to do this please? sorry still a virtual newbioe

Microsoft 365 and Office | Access | For education | Windows
asked 2025-04-08T09:23:01+00:00
Anonymous
7 answers

The option button is not available

Hi, I have been trying to use the option button but the button is not there, I tried changing the text box to option button by right clicking it but the button is dimmed and i cant seem to click on it, Thank you

Microsoft 365 and Office | Access | For education | Windows
asked 2025-04-10T18:08:24+00:00
Anonymous