30 questions with Microsoft 365 and Office | Access | For education | Other tags

Sort by: Updated
Updated Created Answers
4 answers One of the answers was accepted by the question author.

How to change the validation rules for one field based on another

making a booking form where you can book as a group or individual a field for whether it is a group or individual booking is a Yes/NO A field for the number of participants is a number data type I want the participants field value to equal 1 whenever the…

Microsoft 365 and Office | Access | For education | Other
asked 2025-11-24T10:24:12.2+00:00
James Martin 20 Reputation points
commented 2025-11-25T17:30:02.2566667+00:00
Ken Sheridan 3,546 Reputation points
1 answer

is there a way to close all open forms

Hi can you help? i want to on close of a form close every form that may be open in background then go to a main screen. if there a way to do this rather than added code to each form to close individually thanks again

Microsoft 365 and Office | Access | For education | Other
asked 2025-05-01T16:11:21+00:00
Anonymous
3 answers

how to stretch text in a fixed textbox in ms access report?

how to stretch text in a fixed textbox in ms access report? i want to show variables text length in a fixed textbox's width without changing the font size.

Microsoft 365 and Office | Access | For education | Other
asked 2025-01-15T05:48:41+00:00
Anonymous
11 answers

Adding additional fields to a linked excel table in Access where the data in those additional fields is retained as the Excel data source is updated

Hello all, I am looking to understand how best to link an excel spreadsheet (that contains a list of courses) to Access and where I can add additional 'comment' type columns to that linked data and eventually query it all or view bits of it in a form. …

Microsoft 365 and Office | Access | For education | Other
asked 2025-01-22T15:48:43+00:00
Anonymous
3 answers

How do I reference the name header for a report in Access?

I have formatted a label in each footer to reference a name for each quarter/year, but it is not translating correctly when I preview it. For example, in the footer of the design view, I have… =“Total for “ and [saleQuarter] in hope for it to read on…

Microsoft 365 and Office | Access | For education | Other
asked 2024-12-04T18:59:02+00:00
Anonymous
7 answers

I have windows 11 it has all microsft applications i have to subscribe to 365 when i subscribe it shows a list of apps included in the subscription but access isn’t included is it true

Its a laptop by the way

Microsoft 365 and Office | Access | For education | Other
asked 2025-01-24T20:11:41+00:00
Anonymous
3 answers

make ledger book

In MS access I want ledger book. in ledger book i want to manage my all customer with debit credit entry balance and can download particular customer report with starting to ending in report have SN, date, Description, debit, credit, balance…

Microsoft 365 and Office | Access | For education | Other
asked 2024-10-04T17:08:42+00:00
Anonymous
3 answers

Combo Box Multiple Selection and show all records if not record selected

Hello, I have a query that needs to pull the records based on the criteria. * If the combo box value is blank, then I would like to pull all of the records * The combo box would allow to make multiple selection * When I click the button, I will see the…

Microsoft 365 and Office | Access | For education | Other
asked 2024-08-27T00:00:04+00:00
Anonymous
2 answers

How can I transfer data from Access to Excel

How do I transfer data from Access to Excel

Microsoft 365 and Office | Access | For education | Other
asked 2024-09-18T09:09:46+00:00
Anonymous
5 answers

Why does it say my account doesn't exist when I try to sign into Microsoft Access.

Whenever I try to sign into Microsoft Access, it says "That Microsoft account doesn't exist. Enter a different account or get a new one." I know this isn't the case because when I use it for things like Microsoft Word, Power point, Excel and…

Microsoft 365 and Office | Access | For education | Other
asked 2024-11-28T03:37:24+00:00
Anonymous
1 answer

Remove the grey lines in a report

i just cant remember how to do this sorry The grey lines/shadow on a long report, can i ask how to remove them thanks you

Microsoft 365 and Office | Access | For education | Other
asked 2024-07-04T13:54:41+00:00
Anonymous
2 answers

remove blank pages from report

Hi, im running a report but it prints one page then puts a blank then prints the next one, what am i doing wrong please

Microsoft 365 and Office | Access | For education | Other
asked 2024-07-04T17:20:09+00:00
Anonymous
4 answers

how to get access on MacOS?

How to get access on MacOS ? I need it for one of my classes.

Microsoft 365 and Office | Access | For education | Other
asked 2024-01-16T04:02:56+00:00
Anonymous
1 answer

Hi I have not been able to access my unisa mylife email. It says it takes about 24 hours to be created but for me it's been days now and don't what to do.

Hi I can't seem to be able to access my unisa mylife email. I have claim my unisa account and I have waited for 24hours for my unisa mylife email to be active but it's been days now so I don't know what to do now.

Microsoft 365 and Office | Access | For education | Other
asked 2024-02-03T02:38:58+00:00
Anonymous
2 answers

OFF TOPIC Text sent to old phone number for authentication

I have updated my phone number in my profile and after the successful authenticator verification I keep on getting the text option to be sent to my old phone number. So, this is preventing me from logging in.

Microsoft 365 and Office | Access | For education | Other
asked 2023-08-24T14:49:50+00:00
Anonymous
6 answers One of the answers was accepted by the question author.

I am trying to save a copy of my query in Microsoft Access but it won't save. Please help.

When I try to save a copy of my query in Microsoft Access, I press File, Save As, Save Object As, rename the file, and save it. I expect the query to save and show up in the Navigation pane but it will not. Only the original query shows up in the…

Microsoft 365 and Office | Access | For education | Other
asked 2023-11-01T20:55:41+00:00
Anonymous
5 answers

I need to get data out from an ancient Access database (2007) into (preferably) a flat file I can work with.

I'm working on an academic research project (MPhil stage) and have inherited a set of Access files (consisting of multiple tables) with 2000 names and associated data (home town, European city studied at, eventual profession (in some cases multiple) and…

Microsoft 365 and Office | Access | For education | Other
asked 2023-11-23T10:33:16+00:00
Anonymous
2 answers

Quick Start Fields in Access More fields drop down not available

I am currently taking a class online that teaches all about Microsoft applications and how to use them. We are currently working in Access building a database. One of the steps in the textbook is to add quick start fields. In access you are supposed to…

Microsoft 365 and Office | Access | For education | Other
asked 2023-03-25T13:32:50+00:00
Anonymous
3 answers

I integrated Flip into Canvas. Now, it will not allow me to sign into Flip via Canvas. login.microsoftonline.com refused to connect. How can I fix this issue?

I integrated Flip into Canvas. Now, it will not allow me to sign into Flip via Canvas. Message: login.microsoftonline.com refused to connect. How can I fix this issue?

Microsoft 365 and Office | Access | For education | Other
asked 2023-01-11T01:37:37+00:00
Anonymous
2 answers

I can't access my new school's outlook calendar in the staff memos team.

Hi, I'm unable to access my school's outlook calendar. I am part of the team (staff memos) but i can't view the calendar. It isn't showing in the directory when I search for it to add to my calendars. It's a new school I have joined.

Microsoft 365 and Office | Access | For education | Other
asked 2023-01-19T14:12:57+00:00
Anonymous