Microsoft 365 and Office Access For business Windows

3 answers

IMMEDIATE! Access error 2004 There isn't enough memory to perform this operation

It appears that the same issue from June 2023 is happening again. At that time I posted the following to the MS Community the issue being experienced by numerous clients. KB5026446 seems to cause Access error 2004 There isn't enough memory to perform…

asked

COW Farmer 40

commented

Data Dev 0

2 answers

Access database doesnt save entries to existing forms

When i add data to a box in the Access database it is not saved after going to another form

asked

Mario Ostrowski 0

commented

Ivory 1,825 Independent Advisor

3 answers

duplicates within a table

i have a table that contains the following CallDate Customer Callid i seem to have a load of duplicates,i want to get rid of all the duplicates but leave one remaining. im a novice so is there a basic way to do this please or anyone who has the skills…

asked

Mark Powell 0

answered

George Hepworth 23,120 Volunteer Moderator

3 answers

How can I get a sequential numbered list for a Microsoft 365 Access SQL Dynamic Query

I have a table named WaterTestChemUset that has 25 fields. I want to be able to select the data from any of these fields using a combo box located on a form. The following SQL query selects all records from the underlying table WaterTestChemUset great…

asked

Carol Davis 25

commented

Kai-L 19,830 Microsoft External Staff Moderator

2 answers

My access database has opened in design view not a user view

My access database has opened in design view not a user view How do I get the user view back

asked

Accounts 0

commented

Kristen Tran 2,040 Independent Advisor

3 answers

Normal form view missing for Access database version 2608

I have an access database that was written for us with a personallised ribbon. I normally open the database and have a personalised form view that allows me to search, update and create records. I have opened it up as normal and all I can see is the…

asked

Accounts 0

answered

George Hepworth 23,120 Volunteer Moderator

4 answers

My Access Report is printing differently.

My access report is printing a form that has lines in it. The lines are now about 1/8 of the regular size and up in the Left corner of the page. The rest of the form is printing correctly. How do I fix this?

asked

William Pursley 0

answered

Karl Donaubauer 3,661 MVP

3 answers

Access formula for calculating part round-trip part one-way mileage

I need help with a formula to calculate the rate for part one-way and part round-trip travel. For example; I have a group of 4 riders traveling from A to B and B to A, however, one of the riders decided not to take the return route. So there were 4 going…

asked

Robbie Doo 65

commented

Roebe Ta 1,375 Independent Advisor

1 answer

Using report.subreport.hasdata with multiple IIf's

When I'm using (subreport.hasdata.report) feature on main form to pull data with one IIf option, it works fine. However, when I add another IIf, I get and error. For example: =IIf([rpt01_TestCount].[Report].[HasData] And [PU_Loc]=1 And…

asked

Robbie Doo 65

accepted

Robbie Doo 65

1 answer

how to delete a row of #error in each column in access

I had a row of #error during a import of data and I can't delete any of the row "Not A Valid Bookmark" is there any way to save this import?

asked

President CAV 0

edited an answer

President CAV 0

2 answers

What is the most current Microsoft Jet Database Engine version and how to get the installer package?

We have a legacy software written in VB6, which stores a lot of data in various Access database files. Getting recordsets are working, but getting the values from fields causes problems for some of our customers. For the majority it works fine, but for…

asked

VASARI Akos 0

edited the question

Gérard Oomens 132.4K Volunteer Moderator

1 answer

Need help with Microsoft Access access report not printing page header, page footer or report footer you can see them in report view but not in print view.

Problem started yesterday 8/10/26. I can see header in Report View but have disappeared in Print View. Does anyone know how to restore/fix. See before and after snap shot below. Thanks in advance.

asked

Edna G 5

commented

Kai-L 19,830 Microsoft External Staff Moderator

3 answers

Access Reports not printing correctly

Have an Access program that has a report that prints lines between rows. We have one user that the lines are not showing in the Print Preview nor do they print on paper. This issue is affecting only 1 user in the company. No other user seems to be…

asked

Charles Coleman 25

commented

George Hepworth 23,120 Volunteer Moderator

1 answer

Reports No Longer Printing Lines

I have two clients now, that are using M365 Access, where they are no longer able to print reports with lines or boxes. What is weird is that in Print Preview the lines are missing, but in report view they are there. Changing printers did nothing and…

asked

William Wade 0

answered

Duane Hookom 26,940 Volunteer Moderator

2 answers

Microsoft Access latest documentation

Hello, Where can i find the latest document on MSFT's Access DB ? thanks, Cooper

asked

HomerAlpha 6

commented

JephenStones 0

3 answers

I created a macro in Microsoft Access 365 and I am blocked by Microsoft Access from using this macro and I can't find a way to unblock macros in access.

I created a macro in Microsoft Access 365 and I am blocked by Microsoft Access from using this macro and I can't find a way to unblock macros in access. I have tried the recommendations to unblock macros provided in Microsoft help but nothing works or I…

asked

Stanley J Bednarczyk 0

commented

Duane Hookom 26,940 Volunteer Moderator

2 answers

After updating Microsoft 365 Apps / Access to build 16.0.20026.20182, our ASP.NET Web API application began crashing. The IIS worker process (w3wp.exe) terminates with an unhandled fault in mso20win32client.dll whenever application code calls into the Acc

After updating Microsoft 365 Apps / Access to build 16.0.20026.20182, our ASP.NET Web API application began crashing. The IIS worker process (w3wp.exe) terminates with an unhandled fault in mso20win32client.dll whenever application code calls into the…

asked

Prashant Nichal 0

commented

Karl Donaubauer 3,661 MVP

2 answers

Office plus access as one time purchase

Hi Microsoft, I have just started a small business and want Microsoft Office and Microsoft Access. I just want a one time purchase for one computer, how do I do this.

asked

William Skeates 0

answered

Richard Rost 315 MVP

2 answers

Access Data Base - copying one cell to multiple cells in a selected column

If I want to copy data or a cell with data in it, I would ctrl + c to copy it. I then want to copy that into a column of selected cells that has an existing different value so I can quickly fill those cells all the same. Example. I want to copy…

asked

Todd Higgins 0

answered

Ken Sheridan 3,581

3 answers

Can We Convert Microsoft Access databases into A Newer, Better Tool?

We have a 20+ year old Access database that contains all the customer information for our real estate company. We also use this database to run queries to assist in marketing. Can this all be converted into another data platform that could perhaps run…

asked

Susan Chadwick 20

accepted

Susan Chadwick 20

Microsoft 365 and Office | Access | For business | Windows

Filter

Answers

Comments

2,036 questions with Microsoft 365 and Office | Access | For business | Windows tags

IMMEDIATE! Access error 2004 There isn't enough memory to perform this operation

Access database doesnt save entries to existing forms

duplicates within a table

How can I get a sequential numbered list for a Microsoft 365 Access SQL Dynamic Query

My access database has opened in design view not a user view

Normal form view missing for Access database version 2608

My Access Report is printing differently.

Access formula for calculating part round-trip part one-way mileage

Using report.subreport.hasdata with multiple IIf's

how to delete a row of #error in each column in access

What is the most current Microsoft Jet Database Engine version and how to get the installer package?

Need help with Microsoft Access access report not printing page header, page footer or report footer you can see them in report view but not in print view.

Access Reports not printing correctly

Reports No Longer Printing Lines

Microsoft Access latest documentation

I created a macro in Microsoft Access 365 and I am blocked by Microsoft Access from using this macro and I can't find a way to unblock macros in access.

After updating Microsoft 365 Apps / Access to build 16.0.20026.20182, our ASP.NET Web API application began crashing. The IIS worker process (w3wp.exe) terminates with an unhandled fault in mso20win32client.dll whenever application code calls into the Acc

Office plus access as one time purchase

Access Data Base - copying one cell to multiple cells in a selected column

Can We Convert Microsoft Access databases into A Newer, Better Tool?